… that a slave was disconnected from the master, under certain conditions, upon reconnect, it would report that it received a packet…). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… that a slave was disconnected from the master, under certain conditions, upon reconnect, it would report that it received a packet…). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… going down. Then we did some R&D on Percona MYSQL server and found that Percona need some configuration setting regarding… slow again. MySQL load is not going very high. We have also noticed that many process stay in sleeping condition for long… GB HDD = 1 TB IP Addresses = 2 Please help me if there is something we missed.
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… is straightforward: Determine what conditions are observably abnormal when the problem occurs. Gather diagnostic data when the conditions occur. Analyze the diagnostic…. A safe trigger might be 15, if your server never reaches 15 under normal conditions. The more carefully you determine normal versus… need. Finally, make sure that the script can log into MySQL (if necessary, put a password into .my.cnf, or in the…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…. If you have 100M records, it can make a huge difference! And when you write queries, you can still write conditions such as status = ‘payed’. The downside of ENUMs is that if you need to add a… nature. Q: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I made are valid for…
Post: MySQL and IBM
April 6, 2009 By 17 Comments
…, this is not about Sun and IBM 
This is about MySQL. If you download latest 5.1.33 source code you may… disclaimer following this list of conditions. (b) Redistributions in binary form must reproduce this list of conditions, the copyright notice in section…, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */ I think this is outcome of 2-year old press release “MySQL AB…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… problems until a later date. For example, if a database isn’t owned by MySQL, you won’t have any problems until… tool, if you choose), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication… plugins already cover some of the most common and severe conditions that we’ve observed to cause actual production downtime. Please…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…. innodb_concurrency_tickets has been increased from 500 to 5000. If you’re using innodb_thread_concurrency this will reduce overhead…=on,index_merge_intersection=on,engine_condition_pushdown=on 1 row in set (0.00 sec) mysql [localhost] {msandbox} (test) > select * from…_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…? A: The question in this case is how MySQL will execute the join. If it will fist lookup Table2 using some other… use index (A,B) for sorting optimization, for more complicated conditions you will need to use something like Trick “Unionizing Order… more details. Q: how mysql use index for group by? A: If you have Index on the column MySQL can avoid temporary table…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed in your application you… for many conditions. Now lets look more into the problem and do some Math. First lets look into how MySQL accepts connection… in. Under such conditions the default back_log of 50 is enough just for 17 milliseconds, and if main thread stalls somewhere…
