…settings Here is mysql configuration (We are having only 1 mysql server, no replication setup) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql…_size = 192M max_heap_table_size = 192M max_allowed_packet = 64M #max_connect_errors = 10000 read_rnd_buffer_size = 8M bulk_insert_buffer_size = …
Comment: What to tune in MySQL Server after installation
October 6, 2006 By 118 Comments
…settings: [mysqld] max_connections = 300 max_user_connections = 300 key_buffer = 16M myisam_sort_buffer_size = 16M read_rnd_buffer_size = 1M join_buffer_size = 2M read_buffer_size = 1M sort_buffer_size…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…READS | 191581 | | INNODB_PAGES_READ | 191570 | | INNODB_ROWS_READ | 910844 | +—————————————+—————-+ 10 rows in set (0.01 sec) mysql> select sq.*, pages / ((@@innodb_buffer_pool_size…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size…
