by Peter Zaitsev | Feb 11, 2014 | Insight for DBAs, MySQL, Percona Software
A couple of weeks ago, shortly after Vadim wrote about Percona Cloud Tools and using Slow Query Log to capture the data, Mark Leith asked why don’t we just use Performance Schema instead? This is an interesting question and I think it deserves its own blog post...
by Peter Zaitsev | Jan 27, 2014 | MySQL, Percona Services, Webinars
We are nearing the one-year anniversary since MySQL 5.6 went GA – which is typically a good time even for the most conservative users to start thinking about upgrading. At this point there is a fair amount of practical use and experience; many bugs have also...
by Peter Zaitsev | Dec 23, 2013 | MySQL
It is wonderful to see some of my original pet peeves fixed in MySQL 5.7.3! It has not even taken 10 years 🙂 I remember when starting my work at MySQL Support that I would recommend using UNION ALL instead of plain UNION because it would not require duplicate...
by Peter Zaitsev | Sep 24, 2013 | Insight for DBAs, MySQL, Webinars
This Wednesday in our next webinar I’ll share how to configure a better-performing MySQL 5.6 server. You’ll lean a practical approach to generating a sensible configuration file that sets what is needed and omits what is not. Why dedicate an entire webinar...
by Peter Zaitsev | Sep 9, 2013 | MySQL, Percona Events
Now with summer winding down and school back in session, we get into a very busy time with many great opportunities to discover more about MySQL with several excellent MySQL events. At first I wanted to cover all autumn events here but if I did that this post would be...
by Peter Zaitsev | May 22, 2013 | MySQL
Portland is a well-recognized hub for Open Source technologies in the Northwest, home to conferences such as OSCON and Open Source Bridge as well as hosts of OpenSQL Camp in 2009. As such it is a very natural place for our next Percona MySQL University event scheduled...
by Peter Zaitsev | May 13, 2013 | MySQL, Webinars
This Wednesday, May 15 at 10 a.m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features...
by Peter Zaitsev | Apr 30, 2013 | MySQL, Percona Events, Webinars
If you have not already done so, I encourage you to register for my “Best Practices for MySQL Scalability” Webinar which will take place on May 1st at 10 a.m. PST. This will be an overview presentation, led by me and providing a high-level look at the...
by Terry Erisman | Apr 29, 2013 | MySQL, Percona Events, Percona Live
The Percona Live MySQL Conference & Expo 2013 was April 22-25 in Santa Clara, California. This was Percona’s second year organizing the conference and we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the...
by Peter Zaitsev | Apr 11, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live
In preparing for this month’s Percona Live MySQL Conference and Expo, I’ve been reminiscing about the annual MySQL User Conference’s history – the 9 times it previously took place in its various reincarnations – and there are a lot of...
by Peter Zaitsev | Apr 4, 2013 | MySQL, Percona Live
This is my 10th year attending and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back in 2003), and for me it does not get tiring. So what is there in this conference for me as an attendee, speaker and...
by Peter Zaitsev | Mar 27, 2013 | Benchmarks, MySQL, Percona Live
A few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important, which was followed up by Vadim’s post on ThreadPool in Percona Server providing some great illustration on the topic. This time I want to target an...
by Peter Zaitsev | Mar 20, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live, Percona Software
Percona MySQL University, Toronto is taking place this Friday and I’m very excited about this event because it is a special opportunity to fit a phenomenal number of specific and focused MySQL technical talks all into one day, for free. Over the course of the...
by Peter Zaitsev | Mar 4, 2013 | MySQL, Percona Events
This Wednesday (March 6 at 10 a.m. PST) I’ll be presenting a webinar titled “MySQL 5.6: Advantages in a Nutshell.” In this presentation, I will provide a brief overview of the advantages MySQL 5.6 offers. My focus is a practical one – to...
by Peter Zaitsev | Mar 3, 2013 | Benchmarks, Insight for DBAs, MySQL, Percona Software
by Peter Zaitsev | Feb 26, 2013 | Insight for DBAs, MySQL
In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases reaching 4,000 or more concurrent threads which hammer databases as quickly as possible resulting in hundreds or even thousands concurrently active queries....
by Peter Zaitsev | Feb 21, 2013 | Insight for DBAs, MySQL
As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query: mysql...
by Peter Zaitsev | Feb 20, 2013 | Benchmarks, Insight for DBAs, MySQL
Based on a lot of surprising comments about my MySQL 5.5 vs 5.6 performance post I decided to perform deeper investigation to see where my results could go possibly wrong. I had set up everything to be as simple as possible to get maximally repeatable results. I did...
by Peter Zaitsev | Feb 18, 2013 | MySQL, Percona Events
Following our events in Raleigh, Montevideo, Buenos Aires, Percona MySQL University comes to Toronto on March 22nd. This is going to our most dense event yet, absolutely packed with information. Even though we have just 1 track we have 12 talks and 11 speakers. We had...
by Peter Zaitsev | Feb 18, 2013 | MySQL
There have been a number reports/benchmarks showing MySQL 5.6 to be slower than MySQL 5.5 on variety of workloads. There are many possible reasons and I believe we will learn about many of them in the next few weeks and months as MySQL 5.6 is starting to get...
