…MySQL world, technical or not. Lighthearted, fun or otherwise entertaining submissions are highly…findings into his presentation on the state of the MySQL ecosystem. Be sure to visit the Percona Live MySQL…
Post: Deadline Near for BOFs and Lightning Talk Submissions for Percona Live MySQL Conference
February 7, 2013 By Leave a Comment
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
…again) or using GET_LOCK function in MySQL. The second one is good if … CRON job on 2 servers for High Availability Purposes). It is also helpful … running which is not expected in your system. In large systems you may … but information about cron errors should find you. Store Historical Run Times In …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…you want us to analyze and present recommendations for your consideration, and take a look-don’t-touch …there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first … the database. The first step is to find out what MySQL instances are on the machine. It doesn…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… common questions we hear is how to build high-performance systems to do this work. Let’s …Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might be … the blue_clicks column record only blue clicks; to find out non-blue clicks you subtract one from …
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…’ping’ or ‘statistics’ command at the MySQL protocol level, which will increment …getting query times down, and some highly tuned apps are worried when … running 20k queries per second against your database server, an extra 20k … of the offending libraries can find and solve these issues, because …
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… (0.00 sec) The index on query 3 had high cardinality but should not be used since too many … very easy to lead yourself into a trap where your index can not filter out enough rows to be … In this case, MySQL flipped from tablescan to index at about 34%. How am I supposed to find unused indexes then? …
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…MySQL Related work – it is very hard to find people with good enough MySQL knowledge. MySQL…days in your calendar …MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL…
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
….cnf, I have it set to 3 seconds and only find that just around 100-200 queries a day are slower… not know is that if you set your buffers and settings too high and restart your mysql server, mysql wont instantly complain. What I think… which is slow. This can seriously impair your performance! My only wishes for mysql would be that they would allow you to…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
…MySQL experts: Domas Mituzas, Database Engineer Harrison Fisk, MySQL Performance Engineer Yoshinori Matsunobu, Database Engineer Their breakout session is entitled “MySQL…High Performance Replication” will cover his field experiences of having high…schedule to find the breakout …so get your pass now,…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
…program with three threads executing highly concurrent DML statements (where …your program to crash.. Or you just ran your latest and greatest RQG grammar and found this nifty crashing bug, only to find…mysql_execute_command frame. By simply examining “surrounding” variables we’ve been able to find…
