… come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the… I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log… ran 5 instances of iiBench simultaneously to simulate 5 concurrent connections writing to the table, with each instance of iiBench writing…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… OS as two devices (1.2TB each), which can be connected together via software RAID. So I tested in two modes…. I mention this, as it may be challenge for some servers: some models may not have connector for external power, and… results. For this test I also use Cisco UCS C250 server, and on the graph I show the results for both…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… of problems in the server as well as the storage engine. For example, a pile-up of connections all trying to open… to alert when the server‘s Uptime variable is too small. The server is approaching max_connections. Overflowing the max_connections setting is a…-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can give the system administrator time…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… will see these tables going away if you close connection. In Percona Server you can do better as you can query temporary… gone when connection is closed, other correspond to global memory allocation and will result in increased memory allocation until server is restarted. I would suspect memory leak when you see memory usage growing which can’t be connected to…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout = 60 interactive_timeout=1800 skip-name-resolve… of connections and so remains for a few minutes, but then so sopresiva connections to the database increases reaching the maximum of connections and I have to re-restart the server. I’ve…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 1, 2012 By 16 Comments
…] WSREP: 1 (ubuntu-server-129): State transfer from 0 (ubuntu-server-128) complete. Apr 1 14:14:27 ubuntu-server-129 mysqld: 120401… ubuntu-server-129 mysqld: 120401 14:14:27 [Note] WSREP: Synchronized with group, ready for connections Apr 1 14:14:27 ubuntu-server…] WSREP: 0 (ubuntu-server-128): State transfer to 1 (ubuntu-server-129) complete. Apr 1 14:14:27 ubuntu-server-129 mysqld: 120401…
Comment: Version 1.0 of Percona Monitoring Plugins Released
April 19, 2012 By 7 Comments
… introducing of the cacti. It helps a lot of monitoring server load and performances. But I got a question, is it… cacti template, having Curr connections average 400. Is the value being measure hourly? (i.e. 400 connections per hour) or how is…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By Leave a Comment
… variable is too small, indicating the server has been restarted Check whether Threads_connected is approaching max_connections, which can be inconvenient to…
Comment: Percona Server 5.5.21-25.1 released!
March 31, 2012 By 8 Comments
… in Percona Server 5.5 that our customers would find valuable in a Percona Server based on MySQL 5.6. So, connecting the… able to say the exact timetable for a GA Percona Server 5.6 after a MySQL 5.6… but we plan…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… statement started execution all writes will be blocked to the server, which in the end causes “field list” operation to be… client, so you might get a feel you can’t connect to the database at all (use mysql -A in this… running SELECT queries to let backup to proceed, but resolving server gridlock one way or another. If you’re just using…
