by Peter Zaitsev | Jul 6, 2011 | MySQL
I’m speaking at the great multi-speaker MySQL Meetup event taking place in London, 18th of July. I’ll talk about approaches to application scalability which is one of my favorite topics and would be a good fit both for MySQL DBAs and Developers. Make sure...
by Stewart Smith | Jul 1, 2011 | MySQL
Percona is glad to announce the release of Percona Server 5.5.13-20.4 on July 1st, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona Server 5.5.13-20.4 is now the current stable...
by Martin.FarachColton | Jun 29, 2011 | MySQL
Indexes can reduce the amount of data your query touches by orders of magnitude. This results in a proportional query speedup. So what happens when you define a nice set of indexes and you don’t get the performance pop you were expecting? Consider the following...
by Vadim Tkachenko | Jun 23, 2011 | MySQL
I was advised that new drivers and new firmware for FusionIO cards improve performance and stability and it is recommended to review results I’ve got about year ago. Using the same methodology and the same box as for Intel 320 SSD, I run random writes benchmarks for...
by Vadim Tkachenko | Jun 23, 2011 | MySQL
While I like performance provided by PCI-E cards like FusionIO or Virident tachIOn, I am often asked about SATA drives alternatives, as price of PCI-E cards often is barrier, especially for startups. There is wide range of SATA drives on market, and it is hard to pick...
by Tokutek | Jun 22, 2011 | MySQL
The company has developed an index engine for MySQL based on Fractal Tree technology that allows MySQL performance to scale from gigabytes to terabytes.
by Tokutek | Jun 22, 2011 | MySQL
The growth of data, especially in real-time Web 2.0 environments, can be a burden or an opportunity for new products and new revenue. MySQL users should consider TokuDB to increase agility, speed and scalability.
by Zardosht.Kasheff | Jun 21, 2011 | MySQL
At this week’s SF MySQL Meetup, I will give a talk: “Understanding Indexing: Three rules on making indexes around queries to provide good performance.” The meetup is 7 pm tomorrow (Wednesday, 6/22), and will be held at CBS Interactive (235 2nd St., San Francisco)....
by Rich.Prohaska | Jun 17, 2011 | MySQL
Percona’s TPCC for MySQL toolset allows one to measure the query performance for an OLTP workload on various MySQL storage engines. The toolset includes a program to load the database tables, and a program to run queries and measure performance. We have found...
by Tokutek | Jun 15, 2011 | MySQL
/products/tokumx-for-mongodb/
by Tokutek | Jun 15, 2011 | MySQL
/products/
by Vadim Tkachenko | Jun 13, 2011 | MySQL
I wrote about Galera about 1.5 years ago: State of the art: Galera – synchronous replication for InnoDB. It was about the 0.7 release, which was more like a proof-of-concept release (though Galera’s developers may not agree with that ) with some serious...
by Rodrigo Gadea | Jun 9, 2011 | MySQL
Percona is glad to announce the release of Percona Server 5.5.12-20.3 on June 9, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.12, Percona Server 5.5.12-20.3 is now the current stable release in...
by Yves Trudeau | Jun 9, 2011 | MySQL
NDB cluster is a very interesting solution in term of high availability since there are no single point of failure. In an environment like EC2, where a node can disappear almost without notice, one would think that it is a good fit. It is indeed a good fit but reality...
by Aurimas Mikalauskas | Jun 9, 2011 | MySQL
In the first part of this article I have showed how I align IO, now I want to share results of the benchmark that I have been running to see how much benefit can we get from a proper IO alignment on a 4-disk RAID1+0 with 64k stripe element. I haven’t been...
by Aurimas Mikalauskas | Jun 9, 2011 | MySQL
Now that flash storage is becoming more popular, IO alignment question keeps popping up more often than it used to when all we had were rotating hard disk drives. I think the reason is very simple – when systems only had one bearing hard disk drive (HDD) as in...
by Rodrigo Gadea | Jun 8, 2011 | MySQL, Percona Software
Released on June 8, 2011 (Downloads are available here and from the Percona Software Repositories. Percona Server 5.1.57-12.8 is now the current stable release in the 5.1 series. It is is based on MySQL 5.1.57. Bug Fixes Fixed InnoDB I/O code so that the interrupted...
by Yves Trudeau | Jun 3, 2011 | MySQL
A few day ago, a customer came to Percona needing to recover data. Basically, while doing a transfer from one SAN to another, something went wrong and they lost the ibdata1 file, where all the table meta-data is stored. Fortunately, they were running with...
by Tokutek | Jun 2, 2011 | MySQL
Yesterday, Tokutek was invited (thanks to David Hughson, Vice-Consul of the British Consulate) to the Massachusetts State House for a forum on international business, hosted by Governor Deval Patrick. I felt pretty good about our Commonwealth – apparently we are...
by Peter Zaitsev | Jun 2, 2011 | MySQL
One of item I always look at SHOW ENGINE INNODB STATUS to see if there are any transactions spending very long time in ACTIVE state. In the perfect world if you’re running online system you should not see transactions spending more than couple of seconds in...
