… the compression ratio will not be good if it is too low …see some stats about compressed tables, such as what is the average size pages … handling Yet another known Innodb problem is table locks which are taken for statement …there is patch out where already which may come in MySQL 5.2 or even MySQL…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… for a /dev/null email filter. Avoid ratios and thresholds as much as possible, because …a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any …all trying to open or close tables can indicate LOCK_open contention. Replication is delayed or stopped. Our …
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…is however one extremely helpful metric which you can use – ratio…table only. What is about queries which query more than one table…tables but because the access type to the tables is “const” MySQL does not count it as access to two tables…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…is table locks and global mutex on the KeyCache. Table Locks…TABLES table: mysql> select table_schema,table_name,index_length from information_schema.tables where table_schema=’test’ and table_name in (‘a’,'b’); +————–+————+————–+ | table_schema | table…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is…locks, etc. The ratio between Wait Time and CPU time is very helpful to see how “wait free your system is“. If it system is…table on 1% yes, 98% no In this case I can see there is average time per query is 5ms; it is… what…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…locking table for write would not invalidate query cache so you can get results even if table is locked and is…is hard to tell what is good or bad as a lot depends on statement complexity as well as how much work is…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… need to keep the ratio higher or allow a bit longer queries. What should you do …”%cheap rolex%”; This query will perform full table scan in MySQL 5.0 (even if there are …locking, long query time, waste of execution on slave). Piping data through application is the best solution in many cases and is…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… microseconds. mysql tables in use 1, locked 0 is number of tables used by transaction in question (meaning it was accessed) and number of tables locked by… ratio which measures buffer pool efficiency. 1000/1000 corresponds to 100% hit rate. It is hard to tell what buffer pool hit rate is…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… writes to about 6 tables, what version of Innodb/MySQL would you recommend?…syslog, etc). But the ratio of RAM used for these non-mysql processes drops…online reorganize which locks and reorganizes small portions of table online. Q38:…through the adaptive hash index! What is your database like? Do you…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…what airline offered those flights and the flight number of the flight. Some data hand updated.’; — – Table structure for table `ontime_fact` — CREATE TABLE… mysql> use ontime1; Database changed mysql> show table …ratio(compared to Innodb, 8:1 compared to raw input data), which is…-need-lock=0 …
