…actually result in performance that’s worse than a single NIC.] The other two NIC ports should be … of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL … and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…peak traffic. The standby server does not process query traffic except for replication. The …| percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name…shows chunk 4’s workload warmed up with chunk 3. The result is similar for every single…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-…higher QPI speed (and thus, faster inter-process/node communication). Results: First of all, …with taskset. The following chart shows a results comparison on a single-node (on the left)…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks SHOW… this. The pmp-check-unix-memory plugin checks for a single process consuming too much memory and/or for too little free…-check-mysql-status is also very flexible and can be used to trigger an alert on almost anything from SHOW VARIABLES and SHOW…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL… localhost | test | Query | 0 | NULL | show processlist | …single-threaded so it cannot really apply any other event. This was never an issue when the application was using MySQL…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…: http://dev.mysql.com/doc… now, the process is the …# mysqldump –all-databases –single-transaction –triggers –routines…_name | Value | +—————+——-+ | gtid_executed | | +—————+——-+ slave1 > show global variables like ‘gtid_purged’; +—————+——-+ | Variable…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… analysis of what I’ve coined “distributed set processing”. Please also read this post’s “sister post” …the following chart you will see performance at a single node as the tall blue line, and the… nodes (inclusive) are shown as lines. This chart shows the same data in another way: Concurrency testing…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… approach and good tools. The process is straightforward: Determine what conditions …things you can observe (such as SHOW STATUS snapshots) and establish both …angles on the same data. No single tool, no matter how powerful, …that can cause a stall in MySQL, and they usually begin microscopically …
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
…the website. We are in the process of finalizing the plans for …sponsors and attendees. I believe every single exhibitor agreed that their target …credit for putting on a great show, with fun activities for everyone. Akiban,…development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… data for us and speed the process, when possible, but the core commands I’ll show are what we can always fall…, ‘top -n 1′ and ‘uptime’. That shows me what processes are running, but it also shows me load average, memory sizes, and a… what MySQL instances are on the machine. It doesn’t do to just assume there’s a single instance in /var/lib/mysql…
