1. tomoyk

    Posted

    tomoyk
Changes in title
+データベースのブロックサイズの初期値
Changes in tags
Changes in body
Source | HTML | Preview
@@ -0,0 +1,36 @@
+# MySQL
+
+innoDBでは,**16KB**である.
+
+> The default InnoDB page size is 16KB.
+> https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
+
+# PostgreSQL
+
+**8KB**である.
+
+> The default value is 8192 bytes.
+> https://www.postgresql.org/docs/8.4/runtime-config-preset.html
+
+# Oracle
+
+**8KB**である.
+
+> DB_BLOCK_SIZE
+> Default value 8192
+> https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams041.htm#REFRN10031
+
+# MS SQL Server
+
+**64KB**である.
+
+> The default value for SET BLOCKSIZE is 64.
+> https://docs.microsoft.com/en-us/sql/odbc/microsoft/set-blocksize-command?view=sql-server-ver15
+
+# IBM DB2
+
+**32KB**である.
+
+> Use the default DRDA block size (32767) if it does not cause too much paging on executing your application.
+> https://www.ibm.com/docs/en/db2/11.5?topic=tuning-db2-connect-server
+> https://www.ibm.com/docs/en/db2/11.5?topic=tuning-db2-connect-server