…_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M log_queries_not_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow-queries.log innodb_data_home_dir = /var/lib/mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…_lm bogomips : 3990.03 clflush size : 64 cache_alignment : 64 address sizes : 38 bits physical, 48 bits … /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with …most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… server to avoid to do useless queries to the database, but the thing is that the cache is not up to date… the buffer pool size innodb_log_group_home_dir = /mnt/log_mysql innodb_log_file_size=1G innodb_log_buffer_size=64M innodb_flush_log_at_trx_commit=2 [mysql.server] user=mysql basedir=/var/lib…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…on FusionIO: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables …io_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by Fred …
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 116 Comments
…=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid max_connections=255 query_cache_size=8M table_cache=510 tmp_table_size=13M thread_cache_size=12 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
…_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache_size = 80 query_cache_size = 32M thread_concurrency = 8 query_cache_type = 1 query_cache_limit = 32M thread_stack=256K myisam_data_pointer_size=6 net_buffer_length = 8K log-slow-queries=/var/lib/mysql/astdb01…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…’–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql.sock’ ‘–… sql/sql_cache.cc patching …protector –param=ssp-buffer-size=4 -m64 -mtune=generic’ …query_time=# Log all queries that have taken more than long_query_time microseconds to execute to file. This option is standard MySQL…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file…=500 innodb_max_dirty_pages_pct=90 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000
Comment: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8 log-bin=mysql…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
…5.1.53-12.4 is based on MySQL 5.1.53. Â New Features Added: …lrt is added to LIBS. (Alexey Kopytov) Bug #673929 – Query cache misses were being reported for some queries when hits …to test. (Oleg Tsarev) Bug #676158 – Setting the query cache size to 512M caused test failure on low memory systems…
