by Tokutek | Mar 19, 2012 | MySQL
Tokutek and Percona are giving away free tickets to the Percona Live MySQL Conference and Expo (worth $995 each), and you can win them! We’re also giving away copies of High Performance MySQL, 3rd Edition (worth $55 each). This year’s event is the best ever,...
by Hrvoje Matijakovic | Mar 19, 2012 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server 5.5.21-25.0 on March 20th, 2012. Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.5.21, including all the bug fixes in it, Percona Server 5.5.21-25.0 is now the current...
by Vadim Tkachenko | Mar 16, 2012 | MySQL, Percona Events
Just a reminder that I will be giving a talk “Percona XtraDB Cluster” on coming San Francisco MySQL Meetup, next Wednesday, March-21, 2012. Along with talk I will give away one full ticket (tutorials + sessions + expo hall) to Percona Live MySQL User...
by Vadim Tkachenko | Mar 15, 2012 | Benchmarks, MySQL
As ext4 is a standard de facto filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or something else (i.e. xfs) should be used. Traditionally our recommendation is xfs, and it comes to known problem in ext3, where IO gets...
by Tokutek | Mar 13, 2012 | MySQL
Given all the focus and hype on Big Data, I was excited to have the chance at the recent O’Reilly Strata Show to sit down with Jeff Kelly, one of the top rated “Big Data” analysts, to give a MySQL perspective. Below is my interview with Jeff...
by Vadim Tkachenko | Mar 13, 2012 | Insight for DBAs, MySQL, Percona Events
Next Wednesday, March-21, 11:00am Pacific Time, Baron and me will be co-presenting with Virident webinar: “How to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe). Running MySQL on SSD in...
by Terry Erisman | Mar 12, 2012 | MySQL, Percona Events
Early Bird Pricing for the Percona Live MySQL Conference and Expo ends today, March 12th. Hotel room rates at the Hyatt Regency Santa Clara go up March 19th, if rooms are still available at that time. Save money on your conference pass and hotel room by registering...
by Ovais Tariq | Mar 12, 2012 | Benchmarks, Insight for DBAs, MySQL
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer...
by Tokutek | Mar 5, 2012 | MySQL
We had the privilege this past week to be invited to be part of the 2012 O’Reilly Strata “Making Data Work” Conference. Some of our photos from the event are here. At the event, we were excited to have Tokutek described in front of the approximately...
by Stewart Smith | Feb 27, 2012 | MySQL, Percona Software
Percona is glad to announce the second beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 as we are using the 1.9.x version numbers for betas of 2.0 to clearly differentiate beta releases from the final 2.0 release. We do not recommend using Beta...
by Tokutek | Feb 27, 2012 | MySQL
Ensuring sufficient disk I/O to catch copyright violations at network speed. Evidenzia GmbH & Co. KG Issues addressed: Storage growth, including maxed-out disk I/O utilization Performance issues and business impact due to slow selects Inability to revise data...
by Vadim Tkachenko | Feb 25, 2012 | Benchmarks, MySQL
Traditionally the most benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, sysbench and tpcc-mysql, the final result is also represents the throughput (transactions per second in sysbench; NewOrder transactions Per Minute in...
by Vadim Tkachenko | Feb 24, 2012 | MySQL, Percona Events, Percona Software
We are on our way to delivery a production ready release of Percona XtraDB Cluster by the end March-2012. We will do couple events to cover features and architecture of XtraDB Cluster. I will give a talk on San Francisco MySQL Meetup, on March-21: Percona’s new...
by Jervin Real | Feb 23, 2012 | Insight for DBAs
LVM snapshots is one powerful way of taking a consistent backup of your MySQL databases – but did you know that you can now restore directly from a snapshot (and binary logs for point in time recovery) in case of that ‘Oops’ moment? Let me show you...
by Vadim Tkachenko | Feb 23, 2012 | MySQL, Percona Software
I am happy to announce the availability of beta release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and the beta release is based on Percona Server 5.5.20 and the recently released...
by Baron Schwartz | Feb 23, 2012 | Insight for DBAs, MySQL
For about the past year I’ve been formulating a series of tools and practices that can provide deep insight into system performance simply by looking at TCP packet headers, and when they arrive and depart from a system. This works for MySQL as well as a lot of...
by Vadim Tkachenko | Feb 23, 2012 | Benchmarks, Hardware and Storage, MySQL
If you are terrified by the stability of the results in MySQL in my previous post, I am going to show what we can get with Percona Server. This is also to address the results presented there Benchmarking MariaDB-5.3.4 The initial benchmark is described in Benchmarks...
by Vadim Tkachenko | Feb 23, 2012 | Benchmarks, MySQL
My previous post I finished with the graph with unstable results. There I won’t analyze causes, but rather I want to show some different ways to present results. I enjoy working with R, and though I am not even close to be proficient in it, I want to share some...
by Vadim Tkachenko | Feb 22, 2012 | Benchmarks, Hardware and Storage, MySQL
I have a chance to test a system with Intel 320 SSD drives (NewRelic provided me with an access to the server), and compare performance with SAS hard drives. System specification Dell PowerEdge R610 Memory: 48GB CPU: Intel(R) Xeon(R) CPU X5650 RAID controller: Perc...
by Baron Schwartz | Feb 22, 2012 | Insight for DBAs, MySQL
In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended purpose. I want to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQL monitoring...
