… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users … this is to avoid collisions when INSERTs are happening on not only a single node. However, this may …big ones. If you are consistently running overnight reporting jobs and getting them through the replication stream expect some…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods of high load on their database server… query per line, and it will do it’s aggregation job on that. Granted, this means there is no run time data… webinars on the subject, and the upcoming Percona Live conference’s tutorials and sessions will include a wealth on information on everything MySQL-related…
Post: Network at the Percona Live MySQL Conference and Expo
March 28, 2013 By Leave a Comment
… speaker lineup for the Percona Live MySQL Conference and Expo. We have outstanding MySQL experts speaking on a variety of topics during the… Talks for 5-minute snapshots of interesting MySQL topics. Cheer on the winners during the MySQL Community Awards presentations. Or just make the… some new friends. The Percona Live MySQL Conference and Expo will once again have a jobs board where sponsors can post open…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… on ThreadPool in Percona Server providing some great illustration on the topic. This time I want to target an opposite question: why MySQL… to happen — many batch jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some… performance at just high-concurrency values? This might mislead you on how your production will be impacted. Think about, for example…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB …, adjusting the dirty page threshold, flushing the cache on demand, or having a time-based cache flushing … that I thought vCache did a much better job with. If I absolutely must pick a winner …
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache…the vmstat output during the split process, the cron job started at 10am. Fri Mar 22 10:03:…the setting vm.dirty_ratio was set to 20 on a 48GB server, allowing nearly 10GB of “write cache…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
… with run away cron jobs is way to frequent. If slow down happens on the database server or job takes longer to run… using GET_LOCK function in MySQL. The second one is good if you want to serialize jobs from multiple servers (for example you specially put script in CRON job on 2 servers for High…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… blogs and write them, they may even hack on MySQL. So this fraction of MySQL Community looks a lot larger than it is… this – you might think most relevant players in MySQL community participated in MySQL Users Conference over the years. This is about 2000… has the job done, has quick learning curve is robust and easy to operate and has few surprises. As MySQL matures and…
Post: Schedule for MySQL Conference 2012 is Published
January 25, 2012 By 3 Comments
… MySQL In the Enterprise Environments. Some speakers have spent over decade pushing MySQL to its limits, others have in depth experience working on MySQL Code. We have many talks which are covering Oracle MySQL, and… great job getting the schedule together. I can’t thank them enough ! See you in April in Santa Clara for MySQL Conference…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… find out what the cause is some batch jobs, reports and other non response time critical activities … know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, … if you put too heavy of concurrent load on it the response times will increase and user …
