… MySQL manual, especially the option and…max_seeks_for_keyblogpercona.commanual max_sort_lengthblogpercona.commanual max_sp_recursion_depthblogpercona.commanual max_tmp_tablesblogpercona.commanual Max_used_connectionsblogpercona.commanual max_user_connectionsblogpercona.commanual max_write_lock…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… disk tables and HEAP for in memory tables. So first MySQL versions did not bother naming variables with storage engines prefix… with table locks or if LOCK TABLES are used. So in practice this option is used for MyISAM and MEMORY tables. max_write_lock_count Variable which may save you from read starvation if there are constant writes to the table. Works with table locks so…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… that don’t have enough copy-on-write space can fail before the backup … open or close tables can indicate LOCK_open contention. Replication is delayed or …mysql-status plugin to alert when the server’s Uptime variable is too small. The server is approaching max_connections. Overflowing the max…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for … # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 8338s 1us 284s 5ms 13ms 298ms 185us # Lock time 71s 0 …
Comment: What to tune in MySQL Server after installation
October 7, 2009 By 116 Comments
http://blog.taragana.com/index.php/archive/one-mysql-configuration-tip-that-can-dramatically-improve-mysql-performance/ try this max_write_lock_count = 1
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… well as for read-write locks. For these information both for exclusive locks and for shared locks is displayed. …index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 320 MySQL thread id… these values will also grow and innodb_max_purge_lag will become your friend. “undo n…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… them is fully correct. Here’s why: you can’t write an equation for it. The most popular equation, of course… than max_allowed_packet). And keys for user locks! I set my max_allowed_packet bigger and ran the following on my laptop: mysql> set @a := repeat(‘a’, 1024 * 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…should be also tuning procedure for general heavy writing workloads. At first,
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…, and write something …mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’… 6697533 Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data_free…innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-…
