…/ib_logfile* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls -l… far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… available for viewing over at percona.com. My apologies if we weren’t … if you use the BLACKHOLE storage engine) in between the actual master and … plenty of other MySQL and OS-level status variables that you might want to …-running queries in the output of SHOW PROCESSLIST that might be a sign …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Com_show_databasesblogpercona.commanual Com_show_engine_logsblogpercona.commanual Com_show_engine_mutexblogpercona.commanual Com_show_engine_statusblogpercona.commanual Com_show_errorsblogpercona.commanual Com_show_eventsblogpercona.commanual Com_show_fieldsblogpercona.commanual Com_show…_status_…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Com_show_ndb_status‘, ’0′ ‘Com_show_new_master’, ’0′ ‘Com_show_open_tables’, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave_status‘, ’13834′ ‘Com_show_status‘, ’194766′ ‘Com_show_storage_engines‘, ’0′ ‘Com_show_tables’, ’2842′ ‘Com_show_variables’, ’176825′ ‘Com_show_warnings…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…, so you can always learn what your engine can do. documentation Improvements to SHOW INNODB STATUS. We’ve added more memory information and… buffer_pool pages. documentation Documentation is on http://www.percona.com/docs/wiki/percona-xtradb:start. Percona XtraDB available : * in source…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
…written about the new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last…INFORMATION_SCHEMA tables that show some status information about InnoDB. Here are the tables: mysql> SHOW TABLES FROM … manual is being maintained on www.innodb.com, not as part of the regular …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…:19 Percona XtraDB (http://www.percona.com) 1.1.8-rel25.3 started; … have a 3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | …–test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to…. I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability … or not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… there couple numbers to look into. If you take “SHOW ENGINE INNODB STATUS“, look into following sections: Log flushed up to 135550126707 Last… spinning disks (as in this case), Percona Server may not show significant improvement. I am going to followup with results on… you may hear in this case from the Oracle/MySQL engineers is to decrease “innodb_max_dirty_pages_pct”, this way…
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… about backup and you can execute SHOW SLAVE STATUS command you can get reliable information about…was taken from TransactionalReplication http://code.google.com/p/google-mysql-tools/wiki/TransactionalReplication … exclusively to InnoDB storage engine, case with mix of storage engines is much more …
