… to connect to your MySQL servers, one…mysql> pager grep sequence PAGER set to ‘grep sequence’ mysql> show engine innodb status\Gselect sleep(60);show… edit: mysql> edit and it will open …Database changed mysql> select count(*) from sakila; ERROR 1146 (42S02): Table ‘sakila.sakila’ doesn’t exist mysql…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…database. The first step is to find out what MySQL… | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk… mysql> show global variables like ‘%table_size%’; …openings in chess — the great chess players study openings…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… the database we will see the following MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | …:11 [ERROR] Cannot find or open table test/test_innodb …MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.1.30-community-log MySQL…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…showed MySQL 5.6.10 to be much slower than MySQL 5.5.30 even with only a single connection…DATABASE_PAGES: 7163 * DATABASE_PAGES: 7162 OLD_DATABASE_PAGES: 2624 * OLD_DATABASE_PAGES: 2623 MODIFIED_DATABASE_PAGES: 0 * MODIFIED_DATABASE… | 0 | 0 | 90 | 90 | | 5 | Opening tables | 0.270664 | 0.295955 …
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…what are usually global counters in SHOW GLOBAL STATUS and calculates the… that this tool only currently connections to a single node (by default,… minority and will not allow database operations. cnf This is wserep_cluster…are applying writesets rolling back locally open transactions. In fact, this is…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in very long execution times for even simplest queries, or a huge deadlock. In such rare cases SHOW… no longer open by any process). First be sure to run SHOW ENGINE InnoDB STATUS at least once. Then see what MySQL process…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… to come to Percona Live straight from MySQL Connect or cutting their stay short on one of…in his inspiring Keynote. Clustrix have been showing their scalable MySQL compatible database solution built from the ground up… Santa Clara – the call for papers is open until October 13 so do not delay your …
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
… Today I am going to show you how to take almost… honesty, and integrity, truth and openness. I believe in all of …as run by the native database interface (MySQL): mysql> select word, md5(word), md5…connected to my bus, and because I chose to create six hash “buckets” in the table. This allows MySQL…
Post: Living with backups
November 6, 2008 By 28 Comments
…database server it may turn out that running a simple copy operation from MySQL…specifying O_DIRECT flag when opening a file, an application … … my $sth= $dbh->prepare(‘SHOW GLOBAL STATUS LIKE “Threads_connected“‘); … if ($$row[1] < 10... MySQL status every second and in case the number of connected…
