…smm.so datadir=/var/lib/mysql wsrep_slave_threads=2 wsrep_cluster_name=pxctest …-33-92) requested state transfer from ‘*any*’. Selected 1 (ip-10-112-39-98)(SYNCED)…you have a 3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | …
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…. If you’re looking at SHOW INNODB STATUS this is how you can see … the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id |…it can be both – either master or slave can have it main tablespace growing…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… reorganizing that table on a separate computer, maybe a replication slave. Can you make the reorganization run in a tolerable time… key lookups or not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987… pool? PZ: I guess it may be bug in the status or bug in implementation. I’ll check with Alexander or…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…behavior with the new parameter –log-slow-slave-statements. THE DETAILED INFORMATION ABOUT QUERY …many per-session statistics for operations with SHOW SESSION STATUS, but that does not include those … # InnoDB_pages_distinct: 20 SET timestamp=1193841780; SELECT DISTINCT c from sbtest where id between…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables | 0 | +—————+——-+ 2 rows in set (0.00 sec) session10 > select…customer case where there is a reporting slave that daily runs a long running …
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…+——————-+ 1 row in set (0.36 sec) mysql> select count(distinct i) from antest; +——————-+ | count(distinct i)… | analyze | status | OK | +——————–+———+———-+———-+ 1 row in set (0.00 sec) mysql> show…different plans on different slaves with same data….
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… ROWS_FETCHED: 0 ROWS_UPDATED: 127576 TABLE_ROWS_READ: 4085689 SELECT_COMMANDS: 0 UPDATE_COMMANDS: 119127 OTHER_COMMANDS: 89557 COMMIT_TRANSACTIONS…. 3) Processlist Polling This method is simple – the Slave thread has different status in Show Processlist depending on if it processes query or…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…SELECT queries are cached SHOW commands or stored procedure calls are not, even if stored procedure would simply preform select…pretty good on this: Query Cache Query Cache Status Query Cache Configuration I would just mention …It is not distributed If you have 10 slaves and use query cache on all of …
