May 25, 2013

Using MySQL Sandbox with Percona Server

February 16, 2013 By 3 Comments

One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use MySQL Sandbox in its most basic way and it will work:

However [...]

Filed Under: MySQL Tagged With: , ,

Percona Server wins ‘Top Innovator in SQL Technologies’ award!

January 18, 2013 By Leave a Comment

Percona Server has won a 2013 DeveloperWeek Best of Tech award, being named Top Innovator in the SQL Technologies category! We’re proud to accept this award, which is determined by a combination of peer voting and review from an independent panel of judges. Thank you to everyone who voted for Percona Server! From our press [...]

Filed Under: MySQL, Percona Software Tagged With: , ,

Announcing Percona Server 5.5.28-29.3

January 8, 2013 By 2 Comments

Percona is glad to announce the release of Percona Server 5.5.28-29.3 on January 8th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.3 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can [...]

Filed Under: MySQL Tagged With: , , ,

Vote for Percona Server in the 2013 DeveloperWeek Awards

January 3, 2013 By Leave a Comment

Are you a fan of Percona Server? You can show your support by casting a vote for Percona Server in the SQL Technologies Top Innovator 2013 category of the DeveloperWeek Awards. You can vote through January 7, and voting is easy. Just login, select Percona from the alphabetical list, and cast your vote Why bother [...]

Filed Under: Percona Software Tagged With: , , , , ,

Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be cached — system files, binary log, FRM files, MySQL [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Optimizing slow web pages with mk-query-digest

April 7, 2011 By 14 Comments

I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I’ve been using mk-query-digest for almost as long as it exists but it continues to surprise me in ways I couldn’t imagine it would. This time I’d like to share [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , , , ,

Maatkit’s mk-query-digest filters

March 28, 2011 By Leave a Comment

Have you ever seen BIG weird numbers in mk-query-digest report that just seem wrong? I have! Here’s one report I got today:

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Percona Server 5.5.8 Beta Release

February 16, 2011 By 16 Comments

It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights: Performance and scalability improvements throughout the server and storage engine Optimizations for flash storage such as SSD, Virident, and FusionIO Optimizations for cloud computing The [...]

Filed Under: MySQL, Percona Software Tagged With: , , , ,

Different flavors of InnoDB flushing

January 13, 2011 By 9 Comments

In my recent benchmarks, such as this one about the Virident TachIon card, I used different values for innodb_buffer_pool_size, like 13GB, 52GB, and 144GB, for testing the tpcc-mysql database with size 100G. This was needed in order to test different memory/dataset size ratios. But why is it important, and how does it affect how InnoDB works [...]

Filed Under: Benchmarks, MySQL Tagged With: ,

Percona Server 5.1.54-12.5

January 11, 2011 By 9 Comments

Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version. Functionality Added or Changed Percona Server 5.1.54-12.5 is based on MySQL 5.1.54. New Features Added: None Other Changes: Added system variable innodb_log_block_size and new value “keep_average” to system variable adaptive_checkpoint in Improved InnoDB I/O Scalability. (Yasufumi Kinoshita) Added new value [...]

Filed Under: MySQL, Percona Software Tagged With: , , , ,
« Older Posts
Newer Posts »