…of nodes) php genconfig 20 > shards.ini Running the test For best …TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…you can verify the numbers in my next blog post. I will…
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/MySQL …TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” max_connections=100 query_cache_size=0 table_cache=256 tmp_table_size=93M thread_cache_…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
… RAM. and mysql with Innodb tables. 100mb of data is available. i have set normal configuration in ini with query_cache=64mb and innodb…_wait_timeout 120 max_heap_table_size 64M max_allowed_packet 16M query_cache_limit 2M query_cache_min_res_unit slave_net… i set again query_Cache=64M. Can any body suggest me to adjust the configuration to keep my process time same as…
