… a rate of approximately 1500 to 2000 per second, sustained, 24h per day. The mathematically-astute among you may … the id is equal to the auto-increment max value, which is the one that got updated. …easily what the problem turned out to be. 1500 queries per second all trying to lock and update the …
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…/mysqld.log pid-file=/var/run/mysqld/mysqld.pid max_connections=255 query_cache_size=8M table_cache=510 tmp_table_size…_concurrency=8 My Problem is that, day by day i see that the number of slow queries is increasing on. mysql> \s ————– mysql… days 19 hours 45 min 58 sec Threads: 1 Questions: 10163302 Slow queries: 149 Opens: 149457 Flush tables: 1 Open tables: 64 Queries per…
Comment: What to tune in MySQL Server after installation
June 29, 2009 By 118 Comments
… of my MYSQL server. Day by day the number of slow queries are increasing on!…. Threads: 1 Questions: 10163302 Slow queries: 149 Opens: 149457 Flush tables: 1 Open tables: 64 Queries per second avg: 1.615 max_connections=255 query_cache_size=8M…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… has exactly one table. MYISAM table with the following activity: Per day: 1. INSERTS: 1,000 2. UPDATES: 200 3. SELECTS: 1…] long_query_time=5 skip-bdb skip-innodb skip-locking query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=1500…=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
…size web sites which have millions of page views per day. Typically single Apache server in this configuration will …might not be best in such case (at least max and 95%) but in real world it is …network – Database Server, File Servers etc, if you’re querying external web services or do any kind of …
Comment: Choosing innodb_buffer_pool_size
March 30, 2010 By 39 Comments
… of the output: [!!] Highest connection usage: 100% (101/100) [!!] Query cache prunes per day: 26846 [!!] Temporary tables created on disk: 38% (1M on…) wait_timeout (< 28800) interactive_timeout ( 64M) tmp_table_size (> 128M) max_heap_table_size (> 128M) innodb_buffer_pool_size (>= 123G) The…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… request profiling stats logging is taking about 2GB per day for logs, which are written in MyISAM table…: 8048913 Avg_row_length: 252 Data_length: 2030206088 Max_data_length: 4294967295 Index_length: 1024 Data_free:… – in my case running simple full table scan query on the table changed from 5 min to…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON… days. query_cache_type and query_cache_size. The behavior is “no cache” by default still but it is achieved differently now. The query…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…every hour or every day. If its once every day then you can probably…when you are using innodb_file_per_table. Implementation Before going into showing… so while read queries can still access AHI, write queries would have to wait…-name=sbtest_20m –max-time=900 –num-threads=8 –max-requests=0 run Note…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…ft_boolean_syntaxblogpercona.commanual ft_max_word_lenblogpercona.commanual ft_min_word_lenblogpercona.commanual ft_query_expansion_limitblogpercona.commanual ….commanual innodb_file_format_maxblogpercona.commanual innodb_file_per_tableblogpercona.commanual innodb_flush_log_at_trx_commitblogpercona….
