by Percona | Sep 29, 2011 | MySQL
. Baron Schwartz This guest post is from our friends at Percona. They’re hosting Percona Live London from October 24-25, 2011. Percona Live is a two day summit with 100% technical sessions led by some of the most established speakers in the MySQL field. In the London...
by Vadim Tkachenko | Sep 28, 2011 | Benchmarks, Hardware and Storage, MySQL
I wrote about Intel 320 SSD write performance before, but I was not satisfied with these results. Somewhat each time on Intel 320 SSD I was getting different write performance, so it made me looking into this with details. So let’s run experiment as in previous...
by Tokutek | Sep 26, 2011 | MySQL
Review of the O’Reilly Strata Making Data Work Conference (reprinted from my guest blog for the Cloud Council of 7) Monica Rogati of LinkedIn told a story of the early days at the firm, when the reporting system consisted of a single server under someone’s...
by Rodrigo Gadea | Sep 23, 2011 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 1.6.3 on 22 September, 2011 (Downloads are available here and from the Percona Software Repositories). This release is purely composed of bug fixes and is the current stable release of Percona Xtrabackup....
by Yves Trudeau | Sep 23, 2011 | MySQL, Percona Events
In a month, the 24th of October, Johan Andersson (severalnines.com) and I will be giving a full day tutorial on NDB cluster which will include both presentations and hands-on. Be ready for a fast ramp-up on NDB! Among items covered: – Achitecture –...
by Leif.Walsh | Sep 22, 2011 | MySQL
Some indexing structures are write optimized in that they are better than B-trees at ingesting data. Other indexing structures are read optimized in that they are better than B-trees at query time. Even within B-trees, there is a tradeoff between write performance and...
by Tokutek | Sep 22, 2011 | MySQL
The TokuDB engine is truly impressive and I cannot contain my anticipation on what might be the next great breakthrough for my application.
by Kortney Runyan | Sep 19, 2011 | MySQL
Percona is happy to announce that our conference schedule is up online! We are thrilled to be able to offer such a wide variety of talks from so many MySQL experts. Come see Devananda van der Veen a Percona Consultant speak on Replication. “Replication is one of...
by Baron Schwartz | Sep 19, 2011 | Benchmarks, Hardware and Storage, MySQL
Our latest MySQL white paper is Improving Percona Server performance with Flashcache on the Virident tachIOn Drive. (Virident funded the research, but as always, we wrote the report ourselves.) The conclusion is that Flashcache can be good for read-heavy workloads,...
by Vadim Tkachenko | Sep 18, 2011 | Benchmarks, Hardware and Storage, MySQL
We raised topic of problems with flushing in InnoDB several times, some links: InnoDB Flushing theory and solutions MySQL 5.5.8 in search of stability This was not often recurring problem so far, however in my recent experiments, I observe it in very simple sysbench...
by Tim.Callaghan | Sep 15, 2011 | MySQL
I’m creating a library of benchmarks and test suites that will run as part of a Continuous Integration (CI) process here at Tokutek. My goal is to regularly measure several aspects of our storage engine over time: performance, correctness, memory/CPU/disk utilization,...
by Kortney Runyan | Sep 15, 2011 | MySQL
Call for Papers for the Percona Live MySQL Conference and Expo is finally open! We had a little delay while we set up the software so thank you for your patience. Taking into consideration the short delay we are going to extend the close date to December 5th, 2011....
by Baron Schwartz | Sep 15, 2011 | MySQL, Percona Events
This week’s TGIF give-away contest is a day early, and it’s a guest post over on the Engine Yard blog: 5 subtle ways you’re using MySQL as a queue, and why it’ll bite you. Go there to read the full post, and watch @engineyard’s Twitter...
by Jervin Real | Sep 14, 2011 | Insight for Developers, MySQL
Here’s a quick tip I know some of us has overlooked at some point. When doing SELECT … UNION SELECT, where do you put the the INTO OUTFILE clause? On the first SELECT, on the last or somewhere else? The manual has the answer here, to quote: Only the last...
by Kortney Runyan | Sep 9, 2011 | MySQL
The much-anticipated ability to access MySQL data via a NoSQL solution has been realized. Using HandlerSocket, significant performance gains can be realized for certain workloads. Sound like something you are interested in? Join us for Percona Live London to hear Ryan...
by Tokutek | Sep 8, 2011 | MySQL
Intent Media Issue addressed: Ad hoc analytics on clickstream data arriving too fast for InnoDB or NoSQL to handle. TokuDB powers an online advertising application The Company: Headquartered in New York, Intent Media is a fast-growing online advertising startup. The...
by Tokutek | Sep 7, 2011 | MySQL
Managing terabytes of data now is as easy as managing 50 gigabytes was at the beginning.
by Tokutek | Sep 7, 2011 | MySQL
I measured an 80x improvement on our crawler’s insertion rate.
by Baron Schwartz | Sep 7, 2011 | MySQL, Percona Software
Daniel and I and the Percona release engineering team are proud to announce version 1.0.1 of Percona Toolkit. This toolkit is Percona’s suite of DBA and sysadmin productivity tools for MySQL. It is the successor to the popular Maatkit and Aspersa toolkits....
by Laurynas Biveinis | Sep 6, 2011 | MySQL, Percona Software
The latest Percona Server release has one new feature: now MEMORY tables can have BLOB and TEXT columns, and VARCHAR columns will not waste space due to implicit extension to CHAR. The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL...
