…schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance_schema_table_handles_lostblogpercona.commanual Performance_schema_table_instances_lostblogpercona.commanual Performance_schema…
Comment: Learning about MySQL Table Fragmentation
May 11, 2008 By 20 Comments
…? The culprit is that also SHOW TABLE STATUS can be very slow. Same for queries to Information_Schema fetching the same information. But it…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** …_BYTES_WRITTEN: 0 ROWS_FETCHED: 0 ROWS_UPDATED: 127576 TABLE_ROWS_READ: 4085689 SELECT_…simple – the Slave thread has different status in Show Processlist depending on …
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…: 20 Busy_time: 1 Rows_fetched: 7861 Rows_updated: 240 Select_…wp_terms.PRIMARY | 67 | | hosting2.wp_posts.type_status_date | 459 | | hosting2.wp_term_…tables, etc.) limiting command availability to SUPER users only or restricting regular users to see their own statistics only information_schema…
