… be located on the master During a master switch, connections are killed on the demoted master to avoid …10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/…that will be used for replication. This is a real IP address not a reader or writer VIP. …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use |… in the real world and …
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… while still keeping MySQL connection open, others will serve static content such as images which also does not need MySQL connection open. In optimal… though you could misuse persistent connections and get poor performance that was not the reason. The real reason is – you could get…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…because their skills in SQL are limited. The real life customers generate very uneven load – some … outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected_time:…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… sometimes which is obviously the problem – they take Apache Slot, MySQL Connection and other resources. I had discussion today who was thinking… do some cleanup work – for example you can open another MySQL connection to kill the query which was running (otherwise query may… with sleep() function is wrong and if I would use real MySQL queries this would be counted to max_execution_time and…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… a large wait_timeout for the MySQL connection, innobackupex will regularly poll the server, keeping the connection alive while the backup is taking… instead of the real password. Bug fixed#729843 (Alexey Kopytov and Valentine Gostev) innobackupex did not check that MySQL datadir was empty…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… unbuffered query because connection is still busy. Need more error checking If you use buffered query the only real call you can get errors is when you run mysql_query , mysql_fetch_row simply reads data…. Connection can timeout If you do not fetch data for long enough MySQL Server may think client is dead and close connection. This…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… offer great performance on distributed systems, especially if they are connected via not very fast network you need to come up… with group by over 10.000.000 of rows in real time is one painful thing to do requiring complex application… timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL got back to spend…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-…query returns different number or rows. For example: Connection 43 Rows Sent: 210 != expected 211 for query…can test our changes or updates using real data and real queries from our application. The tool …
Post: Introducing the “Version Check” Feature in Percona Toolkit
September 10, 2012 By Leave a Comment
…in MySQL/MariaDB sql/password.c MySQL 5.1.61 DSA-2429-1 mysql-5.1 — several vulnerabilities MySQL … Check feature will use https (secure channel) to connect with Percona’s Version Check database server. …. We believe the feature will provide a real benefit so we encourage Percona Toolkit users …
