EmergencyEMERGENCY? Get 24/7 Help Now!

Webinar: SQL Query Patterns, Optimized

 | May 20, 2013 |  Posted In: MySQL, Technical Webinars

Next Friday, May 31 at 10 a.m. Pacific, I’ll present Percona’s next webinar, “SQL Query Patterns, Optimized.” Based on my experiences solving tough SQL problems for Percona training and consulting, I’ll classify several common types of queries with which developers struggle. I’ll test several SQL solutions for each type of query objective, and show how […]

Read More

Analyzing Slow Query Table in MySQL 5.6

 | February 18, 2013 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Toolkit

Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit.  This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we saw the GA release of MySQL 5.6, and I wanted to check if any […]

Read More

Read/Write Splitting with PHP Webinar Questions Followup

 | January 23, 2013 |  Posted In: Events and Announcements, Insight for Developers, MySQL

Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars.  If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as I could during the session, but here are […]

Read More

Webinar on Read/Write Splitting with PHP

 | January 17, 2013 |  Posted In: Events and Announcements, Insight for Developers, MySQL

I’ll be presenting a webinar next Wednesday, January 23 at 10 a.m. (Pacific Time), about issues application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair. Specifically, about the care we have to take because replication is asynchronous.  This means the slave  may not have current data […]

Read More

Get Me Some Query Logs!

 | November 22, 2012 |  Posted In: Events and Announcements, Insight for DBAs, MySQL

One of my favorite tools in the Percona Toolkit is pt-query-digest.  This tool is indispensable for identifying your top SQL queries, and analyzing which queries are accounting for your database load. But the report you get from pt-query-digest is only as good as the log of queries you give it as input.  You need a large […]

Read More

Upcoming Webinar on Index Design

 | October 1, 2012 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers

The proper tools and techniques for designing indexes in MySQL is a broad subject, which causes grief for many developers and database administrators. I’ll present a webinar Tools and Techniques for Index Design on October 3, 2012 at 10:00am Pacific time to give an overview of the best practices and procedures for you to build index […]

Read More

Webinar for Full Text Search Throwdown

 | August 21, 2012 |  Posted In: Events and Announcements, Insight for Developers, MySQL

Tomorrow, August 22 at 10:00am PDT, I’ll present a webinar called Full Text Search Throwdown.  This is a no-nonsense performance comparison of solutions for full text indexing for MySQL applications, including: LIKE predicates and regular expressions MyISAM FULLTEXT indexes InnoDB FULLTEXT indexes Apache Solr Sphinx Search Trigraphs I’ll compare the performance for building indexes and querying […]

Read More

SQL Injection Questions Followup

 | July 26, 2012 |  Posted In: Insight for Developers, MySQL

I presented a webinar today about SQL Injection, to try to clear up some of the misconceptions that many other blogs and articles have about this security risk.  You can register for the webinar even now that I’ve presented it, and you’ll be emailed a link to the recording, which will be available soon. During […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.