1) innodb_file_per_table видимо по умолчанию, ибо в my.ini он отсутствует. 2) говорят, что полетел дисковый массив у хостера. …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…values in the /etc/my.cnf file if you really want to… to generate the shards.ini file for testing an cluster of…INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_DIRECT innodb…
Comment: Percona Server 5.1.47-rel11.0
June 25, 2010 By 13 Comments
…,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg –with-big-tables –without-debug –with-tcp-port…-zlib-dir=bundled –with-ssl my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1 it work Percona…
Comment: Percona Server 5.1.47-rel11.0
June 24, 2010 By 13 Comments
…,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg –with-big-tables –without-debug –with-tcp-port…-zlib-dir=bundled –with-ssl my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1 it work Percona…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… data from my tests: computer 1: My.ini [client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 basedir=”C:/Program Files/MySQL… 1166 inserts per second into that one table. using autocommit for innodb inserts I got 1125, and 1158 inserts per second into the table using…
