Two ways to grow: add a chunk with onspaces -a, or extend one through the SQL API only. GBase Database draws that boundary clearly, and GBase Database enforces it. #gbase#database#数据库
task('create dbspace',...) equals onspaces -c. GBase Database gives you two paths, and either one works when GBase Database operations go into scripts. #gbase#database#数据库
rootdbs for system objects, llogdbs for logs, tempdbs for sorting. GBase Database storage roles are best settled before the first database — GBase Database won't split them for you later. #gbase#database#数据库
BLOB and CLOB can't live in an ordinary dbspace. GBase Database smart large objects belong in an sbspace; without a put clause, GBase Database sends them to the default sbspace. #gbase#database#数据库
size and free in onstat -d are in pages, not KB. GBase Database output needs a pgsize multiply; GBase Database makes you compute the percentage yourself. #gbase#database#数据库
onstat -d has two sections: Dbspaces for the big picture, Chunks for files. With GBase Database storage issues, locate the chunk first — GBase Database reports both levels in one command. #gbase#database#数据库
Page size is forever. GBase Database lets you pick 2K to 16K when you create the space, and GBase Database gives you no second chance short of a rebuild. #gbase#database#数据库
Before onspaces -c: touch, chown, chmod 660. GBase Database won't create the file for you, and with the wrong permissions GBase Database fails when it opens it. #gbase#database#数据库
Create a database without in and the tables land in rootdbs. GBase Database defaults only guarantee it builds — GBase Database doesn't guarantee you can manage it. #gbase#database#数据库
Character set is fixed at initialization; get it wrong and you rebuild. GBase Database's script defaults to zh_CN.utf8; on the manual path, follow the site requirement instead of the GBase Database example. #gbase#database#数据库
onstat - returning shared memory not initialized is GBase Database reporting the instance is down — or that your environment points elsewhere. Check the shell first, then the process. GBase Database is usually fine; the session is not. #gbase#database#数据库
onmode -ky is immediate shutdown, not graceful. Assess in-flight transactions first; GBase Database will not decide for you whether it is safe to stop — that judgement stays outside GBase Database. #gbase#database#数据库
Manual initialization takes five steps and is worth it in production. Get rootdbs ownership or permissions wrong by one step and GBase Database initialization stalls writing the reserved page — GBase Database will not guess what you meant. #gbase#database#数据库
VPCLASS cpu,num=16,noage: set num to physical cores, confirm with lscpu. GBase Database won't separate hyperthreads from cores for you — GBase Database only uses the number you write. #gbase#database#数据库
LOCKS 10000000 is not automatically better. GBase Database lock structures live in shared memory and compete with the buffer pool for the same RAM — oversize them and GBase Database starts paging. #gbase#database#数据库
Initialization is the only free tuning window. Most GBase Database parameters need a restart; wait for the benchmark to fail and GBase Database costs you an unplanned outage. #gbase#database#数据库
gbaseserver onsoctcp <IP> 9088 is the minimum sqlhosts line. Put localhost there and GBase Database sees only the loopback address, so remote clients fail. In GBase Database deployments, write the external IP. #gbase#database#数据库
Three config files, three jobs: profile for environment, onconfig for parameters, sqlhosts for the network. When GBase Database won't start, classify first; GBase Database errors only name the surface. #gbase#database#数据库
Default page-level locking is a quiet bottleneck of a single instance. One line — DEF_TABLE_LOCKMODE row — fixes it. One restart, and GBase Database stops letting unrelated rows block each other. That is the cheapest concurrency fix GBase Database offers. #gbase#database#数据库
BUFFERPOOL size=16K,buffers=1000000 is about 16GB, and size must equal page size. GBase Database fixes page size at initialization — change it later and GBase Database makes you rebuild the instance. #gbase#database#数据库