… if you can connect and run a simple query and receive a response back in a … MySQL is up and running. That said, there are plenty of other MySQL and OS-level status …MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…query: session10 > show profile for query 11; +——————————–+———-+ | Status | Duration | +——————————–+———-+ | starting | 0.000018 | | Waiting for query cache lock | 0.000003 | | checking query cache for query…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…status…query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… simple – SHOW INNODB STATUS does not know anything about MySQL level locks, so table locked on MySQL level with LOCK TABLES will not …locked explicitly Innodb “converts” table lock to “no lock” hence eliminating conflicts on MySQL level table locks for most queries. Summary: MySQL Table level locks…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
… Live London ticket! But first, what’s new with the MySQL query cache? You may know that it still has the same…, that changes the thread’s status in SHOW PROCESSLIST to “Waiting on query cache mutex” when the query cache mutex is taken. This… a screen full of threads in Locked status, now you get a screen full of query cache locks. It makes it impossible to miss…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G ***************************…from the ./run_query command, called pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw … innodb-stats-update-need-lock=0 innodb-status-file innodb-strict-mode …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query…Query Cache Query Cache Status Query Cache Configuration I would just mention couple of points – as protection from one query wiping your all query cache option query…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
… sec) The query consumed 0.18 seconds. Where did the time go? mysql> SHOW PROFILE FOR QUERY 1; +———————-+———-+ | Status | Duration | +———————-+———-+ | …01 | 2 | 0.0000070000 | | System lock | 0.000010 | 0.01 | 1 | 0.0000100000 | | query end | 0.000003 | 0.00 | …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… query in the right way. But vanilla MySQL …query accessed, the length of time query waited for row locks…Query_time distribution # 1us # 10us # 100us ################### # 1ms ################################################################ # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS…
