…the virtual machines. Baseline: The MySQL command line client was used to execute… the following configuration file, which lists only one server. A single schema… before loading. The splitting/loading process will be described in another …LIMIT 10; The next queries show how performance is improved when…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…SHOW INNODB STATUS is command which prints out a lot of internal Innodb performance counters, statistics, information about transaction processing…LIST OF TRANSACTIONS FOR EACH SESSION: —TRANSACTION 0 0, not started, process no 3396, OS thread id 1152440672 MySQL…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… it must wait for FlexCDC to process changes from that transaction. In practice…as the first argument on the command line: $ cat sales.sql create table …list of tables used by the above view, as stored in the data dictionary: mysql… together. The complete method examples show how to create a complete …
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…MySQL command-line client that wasn’t started with -A, and it’s trying to get a list…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… and good tools. The process is straightforward: Determine what …you can observe (such as SHOW STATUS snapshots) and establish …Find and change the following lines: # This is the max number … ‘?’ key for a list of the keystroke commands you can use. …can cause a stall in MySQL, and they usually begin …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…commands. For example, ‘top -n 1′ and ‘uptime’. That shows me what processes are running, but it also shows…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…showing them. Then, I go through it line by line, like… mailing list. We …
