by Vadim Tkachenko | Apr 25, 2011 | Benchmarks, Hardware and Storage, Insight for DBAs, MySQL
As continuation of my CPU benchmarks it is interesting to see what is scalability limitation in MySQL 5.6.2, and I am going to check that using PERFORMANCE SCHEMA, but before that let’s estimate what is potential overhead of using PERFORMANCE SCHEMA. So I am...
by Baron Schwartz | Apr 25, 2011 | Insight for DBAs, Insight for Developers, MySQL, Percona Events
Harrison Fisk, from the Facebook database team, will be in New York City delivering the closing keynote at Percona Live next month. He’ll be talking about the present status and future plans for MySQL inside Facebook’s environment. As you probably know,...
by Baron Schwartz | Apr 25, 2011 | MySQL, Percona Software
Time for our weekly review of the news! The big news this week is that Percona XtraBackup is ready to try out on Windows. Otherwise, there’s just more steady progress. One quick note, sort of a “to whom it may concern,” is that the proper trademarked...
by Vadim Tkachenko | Apr 25, 2011 | Benchmarks, Hardware and Storage, MySQL
Having two big boxes in our lab, one based Intel Nehalem (Cisco UCS C250) and second on AMD Opteron (Dell PowerEdge R815), I decided to run some simple sysbench benchmark to compare how both CPUs perform and what kind of scalability we can expect. It is hard to make...
by Baron Schwartz | Apr 22, 2011 | MySQL, Percona Events
The first Percona Live conference in San Francisco in February was a huge success, and we’re planning to run several each year. The next one is May 26th in New York City. We’ve just confirmed a number of sought-after speakers and posted the schedule...
by Vadim Tkachenko | Apr 21, 2011 | Hardware and Storage, Insight for DBAs, Percona Software
It is well known fact that InnoDB standard page size is 16K or 16384 bytes. Sometime ago we added feature to Percona Server to change that to 4K or 8K (innodb_page_size). That maybe useful for SSD that operates with 4K blocks and you can get really much better...
by Peter Zaitsev | Apr 21, 2011 | Insight for DBAs, MySQL
I have mentioned few times Innodb caches data in pages and even if you have working set consisting of relatively few rows your working set in terms of pages can be rather large. Now I came to do a little benchmark to show it in practice. I’m using standard...
by Vadim Tkachenko | Apr 20, 2011 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL, Percona Software
There have been recent discussions about DROP TABLE performance in InnoDB. (You can refer to Peter’s post https://www.percona.com/blog/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these bug reports: http://bugs.mysql.com/bug.php?id=51325 and...
by Tokutek | Apr 19, 2011 | MySQL
What a busy week – between O’Reilly and Collaborate we gave a number of talks, sponsored a booth, and took some long flights in between the shows. But what an interesting week. The MySQL conference is a great time to catch up with customers and, as always,...
by Peter Zaitsev | Apr 19, 2011 | Insight for DBAs, MySQL
Sometimes on very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed in your application you will see some successful connections taking well over the second....
by Baron Schwartz | Apr 18, 2011 | MySQL, Percona Events
Percona, and Yasufumi Kinoshita who works for Percona, received two awards from the O’Reilly MySQL Conference co-chairs on behalf of the committee that voted on the nominees. The awards were: to Yasufumi as O’Reilly MySQL Community Contributor of the Year...
by Devananda van der Veen | Apr 18, 2011 | Insight for DBAs, MySQL
Tcpdump Packet Loss on Busy Servers Often I run into problems when trying to use mk-query-digest with tcpdump on “very” busy hosts. You might be thinking, “very busy is a relative and unquantifiable term,” and you’d be right, so...
by Baron Schwartz | Apr 18, 2011 | MySQL, Percona Software
Last week wasn’t so active in terms of new development, because many of us were at the MySQL conference, of course. However, we did push out the XtraBackup 1.6 release, and began work on backporting some features from MySQL 5.6 to 5.1 for a certain large...
by Fred Linhoss | Apr 18, 2011 | MySQL, Percona Software
Percona Server version 5.1.56-12.7 is now available for download. It is based on MySQL 5.1.56 and is the current stable release in the 5.1 series. New Features Expanded the applicability of InnoDB fast index creation to mysqldump, ALTER TABLE and, OPTIMIZE TABLE....
by Aurimas Mikalauskas | Apr 17, 2011 | Insight for DBAs, MySQL
I use Aspersa tools a lot and I find myself going to the website just to download one of the tools all the time. I love I can download maatkit with a simple wget maatkit.org/get/tool command so I made bit.ly shortcuts for all of the current aspersa tools. Here’s...
by Baron Schwartz | Apr 15, 2011 | Percona Events
As you might have heard, at the MySQL Conference this earlier this week we announced our launch of Drizzle support services. We added Drizzle to the list of database servers that is covered under our MySQL support contracts. This includes MySQL, Percona Server, Amazon...
by Fred Linhoss | Apr 12, 2011 | MySQL, Percona Software
Percona XtraBackup 1.6 is now available for download and is the current stable release version of XtraBackup. Options Added Added option –extra-lsndir to innobackupex. When specified for the backup phase, the option is passed to xtrabackup, and lsn information...
by Baron Schwartz | Apr 11, 2011 | MySQL, Percona Software
Last week was rather less newsworthy in Percona Server land, as we spent a lot of time preparing for the MySQL Conference and Collaborate, and Vadim was on vacation. One interesting tidbit: I wrote some scripts analyze our log files and found that we were massively...
by Tokutek | Apr 11, 2011 | MySQL
Jawa Issue addressed: Process over 10 million log entries per day without partitions or other workarounds. MySQL + TokuDB Tames Huge Logfile Processing Workload The Company: Founded in 2005, Jawa develops software and media solutions enabling people to stay connected...
by Peter Zaitsev | Apr 10, 2011 | Insight for DBAs, MySQL
Over last few years I’ve been suggesting more people to disable Query Cache than to enable it. It can cause contention problems as well as stalls and due to coarse invalidation is not as efficient as it could be. These are however mostly due to neglect Query...
