EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server: Improve Scalability with Percona Thread Pool

 | January 23, 2014 |  Posted In: Benchmarks, MySQL, Percona Server

By default, for every client connection the MySQL server spawns a separate thread which will process all statements for this connection. This is the ‘one-thread-per-connection’ model. It’s simple and efficient until some number of connections N is reached. After this point performance of the MySQL server will degrade, mostly due to various contentions caused by […]

Read More

January 28 Webinar: Get More Out of MySQL with TokuDB

 | January 21, 2014 |  Posted In: Tokutek, TokuView

You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications? Register Now! SPEAKER: Tim Callaghan, VP of Engineering at Tokutek DATE: Tuesday, January 28th TIME: 1pm ET Join this interactive […]

Read More

Percona Replication Manager (PRM) now supporting 5.6 GTID

 | January 20, 2014 |  Posted In: High-availability, MySQL, Percona replication manager

Over the last few days, I integrated the MySQL 5.6 GTID version of the Percona Replication Manager (PRM) work of Frédéric Descamps, a colleague at Percona. The agent supports the GTID replication mode of MySQL 5.6 and if the master suffers a hard crash, it picks the slave having applied the highest transaction ID from […]

Read More

FOSDEM 2014: MySQL And Friends Community Dinner

 | January 16, 2014 |  Posted In: Fosdem, MySQL

FOSDEM is coming to town again here in Brussels this February 1-2, and as usual, there is a MySQL Devroom. Traditionally, a MySQL and Friends community dinner is also held during the event and this year is no different – we’ve organized one for Saturday, February 1 from 8:30 p.m. to 11:30 p.m. (CET). If you […]

Read More

Analyzing WordPress MySQL queries with Query Analytics

 | January 16, 2014 |  Posted In: MySQL, MySQL Webinars, Percona Cloud Tools, Percona Software

This blog, MySQLPerformanceBlog.com, is powered by WordPress, but we never really looked into what kind of queries to MySQL are used by WordPress. So for couple months we ran a Query Analytics (part of Percona Cloud Tools) agent there, and now it is interesting to take a look on queries. Query Analytics uses reports produced […]

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.