by Zardosht.Kasheff | Aug 11, 2010 | MySQL
In posts on June 30 and July 6, I explained how implementing the commands “replace into” and “insert ignore” with TokuDB’s fractal trees data structures can be two orders of magnitude faster than implementing them with B-trees. Towards the end of each post, I hinted...
by Morgan Tocker | Aug 10, 2010 | Insight for Developers, MySQL
If you read Percona’s whitepaper on Goal-Driven Performance Optimization, you will notice that we define performance using the combination of three separate terms. You really want to read the paper, but let me summarize it here: Response Time – This is the...
by Rich.Prohaska | Aug 3, 2010 | MySQL
In posts on June 30 and July 6, we explained how implementing the commands “replace into” and “insert ignore” with TokuDB’s fractal trees data structures can be two orders of magnitude faster than implementing them with B-trees. Towards...
by Baron Schwartz | Jul 31, 2010 | Insight for DBAs, MySQL
A couple of weeks ago one of my colleagues and I worked on a data corruption case that reminded me that sometimes people make unsafe assumptions without knowing it. This one involved SAN snapshotting that was unsafe. In a nutshell, the client used SAN block-level...
by Peter Zaitsev | Jul 30, 2010 | Benchmarks, Insight for DBAs, MySQL
There is a lot of discussions whenever running MySQL storing data on NFS is a good idea. There is a lot of things for and against this and this post is not about them. The fact is number of people run their databases on NetApp and other forms of NFS storage and this...
by Rich.Prohaska | Jul 26, 2010 | MySQL
Tokutek tests its TokuDB Fractal Tree storage engine with multiple MySQL distributions. We make extensive use of the MySQL Sandbox in our test automation. We tweaked the regular expressions that match binary tarball names in the MySQL Sandbox so that MariaDB releases...
by Morgan Tocker | Jul 24, 2010 | Insight for Developers, MySQL
I recently had a run-in with a very popular PHP ecommerce package which makes me want to voice a recurring mistake I see in how many web applications are architected. What is that mistake? The ecommerce package I was working with depended on caching. Out of the box...
by Zardosht.Kasheff | Jul 21, 2010 | MySQL
In posts on June 30 and July 6, I explained how implementing the commands “replace into” and “insert ignore” with TokuDB’s fractal trees data structures can be two orders of magnitude faster than implementing them with B-trees. Towards...
by Peter Zaitsev | Jul 20, 2010 | Insight for DBAs, MySQL
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded and the more cores and hard drives the get the larger the difference becomes, as long as replication remains single thread process. At the same time it is a lot easier to...
by Vadim Tkachenko | Jul 17, 2010 | Benchmarks
( cross posting from SSD Performance Blog ) In previous post On Benchmarks on SSD, commenter touched another interesting point. Available free space affects write performance on SSD card significantly. The reason is still garbage collector, which operates more...
by Baron Schwartz | Jul 16, 2010 | MySQL, Percona Software
I recently did a quick analysis of the distribution of writes to InnoDB’s log files. On a high-traffic commodity MySQL server running Percona XtraDB for a gaming workload (mostly inserts to the “moves” table), I used strace to gather statistics about...
by Justin Swanhart | Jul 15, 2010 | Insight for Developers, MySQL
This is part two in my six part series on business intelligence, with a focus on OLAP analysis. Part 1 – Intro to OLAP Identifying the differences between a data warehouse and a data mart. (this post) Introduction to MDX and the kind of SQL which a ROLAP tool...
by Vadim Tkachenko | Jul 14, 2010 | Benchmarks, Hardware and Storage
(cross post from SSD Performance Blog ) To get meaningful performance results on SSD storage is not easy task, let’s see why. There is graph from sysbench fileio random write benchmark with 4 threads. The results were taken on PCI-E SSD card ( I do not want to...
by Zardosht.Kasheff | Jul 14, 2010 | MySQL
In my post on June 18th, I explained why the semantics of normal ad-hoc insertions with a primary key are expensive because they require disk seeks on large data sets. I previously explained why it would be better to use “replace into” or to use...
by Vadim Tkachenko | Jul 14, 2010 | Hardware and Storage
(cross posting from SSDPeformanceBlog.com ) All modern solid state drives use NAND memory based on SLC (single level cell) or MLC (multi level cell) technologies. Not going into physical details – SLC basically stores 1 bit of information, while MLC can do more....
by Peter Zaitsev | Jul 13, 2010 | Insight for Developers, MySQL
So lets imagine you have the server handling 100.000 user accounts. You can see the CPU,IO and Network usage is below 10% of capacity – does it mean you can count on server being able to handle 1.000.000 of accounts ? Not really, and there are few reasons why,...
by Peter Zaitsev | Jul 13, 2010 | MySQL, Percona Events
This year we’re participating in OSCON as a Sponsor and organizing some BOFs. I will be on the conference 21 and 22 if you’re interested to chat. Here is the list of currently scheduled BOFs which I’ll be hosting: Running Databases on Flash Storage...
by Justin Swanhart | Jul 12, 2010 | Insight for Developers, MySQL
This is the first of a series of posts about business intelligence tools, particularly OLAP (or online analytical processing) tools using MySQL and other free open source software. OLAP tools are a part of the larger topic of business intelligence, a topic that has...
by Yves Trudeau | Jul 12, 2010 | Insight for DBAs, MySQL
This post is the third of a series that started here. From the previous of this series, we now have two working EC2 instances that are EBS based. The first instance is the monitor, usually an m1.small type instance and the second instance is hamysql, a large instance...
by Vadim Tkachenko | Jul 11, 2010 | MySQL, Percona Software
Recently we had couple posts dedicated to performance monitoring, i.e. Color code your performance numbers, Performance Optimization and Six Sigma, so you may understand we consider stability of performance numbers as one of important area for database management....
