…_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query…. It is interesting though slow query log remained enabled – probably it caused so little overhead because there were no slow queries it just was left…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
…-10) Extended slow.log is now even more extended, there is additional information for each query: # Bytes_sent: 4973 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 7808 That is you can see how many bytes was returned by query, was temporary table…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…size = 4096M innodb_lock_wait_timeout = 120 innodb_use_sys_malloc = 0 long_query_time = 8 #log-slow-queries = /var/log/mysql-slow-query.log…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… execute queries or make operation to swap seriously slowing down…size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size…size, tmp_table_size of memory might be allocated. But they are only allocated upon the need and freed once given stage of query…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…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… 58 sec Threads: 1 Questions: 10163302 Slow queries: 149 Opens: 149457 Flush tables: 1 Open tables: 64 Queries per second avg: 1.615 ————– …
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” max_connections=10000 query_cache_size=128M table_cache=256 tmp_table_size=103M thread_cache_size=15 log-slow-queries = “D:/work/MySQL Datafiles/wrl-server-knp-slow.log” long_query_time = 2…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…execute read/write queries against a 20M rows table: sysbench –test=oltp –oltp-table-size=20000000 –mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524…. queries were captured in the slow log by setting long_query_time to 0. Then for analysis purposes the queries in the slow log were …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table …Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_table_size…memory leaks like valgrind are too slow to run in production. So the…
