by Baron Schwartz | Apr 24, 2010 | Insight for Developers, MySQL
A week or so ago at the MySQL conference, I visited one of the backup vendors in the Expo Hall. I started to chat with them about their MySQL backup product. One of the representatives told me that their backup product uses FLUSH TABLES WITH READ LOCK, which he...
by Vadim Tkachenko | Apr 21, 2010 | Benchmarks, MySQL
MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in tpcc-like workload. The full details are on Wiki page https://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start I took MySQL-5.5.4 with InnoDB-1.1,...
by Zardosht.Kasheff | Apr 15, 2010 | MySQL
Another plug for Bradley’s talk Thursday morning at the MySQL User’s conference. Spending the day talking to DBA’s and other potential users of TokuDB, I (Zardosht) noticed the same question/theme come up numerous times in conversation. “Oh, so...
by Baron Schwartz | Apr 14, 2010 | MySQL
I’ve heard this question a lot, but never thought to blog about the answer. “Is there a performance difference between putting the JOIN conditions in the ON clause or the WHERE clause in MySQL?” No, there’s no difference. The following queries...
by kuszmaul | Apr 14, 2010 | MySQL
I forgot to include the titles for my talks. The ignite talk Wednesday at 7pm is “What Is a Performance Model for SSDs?” The ignite talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian Aker. I’ll present some performance...
by Maciej Dobrzanski | Apr 14, 2010 | MySQL, Percona Events
While the majority of Percona gang travelled to California for the MySQL event of the year, I headed in the opposite direction to Moscow for RIT++ 2010 conference where I presented a talk on Sphinx. You can get the PDF file here – Improving MySQL-based...
by kuszmaul | Apr 14, 2010 | MySQL
I (Bradley C. Kuszmaul) am presenting two talks at the MySQL User Conference. The first talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian Aker. I’ll present some performance measurements on the Intel X25E SSD. The bottom line is...
by Aleksandr Kuzminsky | Apr 13, 2010 | MySQL, Percona Software
Dear Community, Today we are pleased to announce the release 10 of Percona Server with XtraDB storage engine. Since the previous release 9.1 there are following changes MySQL 5.1.45 as a basis for the release I_S SYS_TABLES New patch page_size_and_expand_log. It...
by Aleksandr Kuzminsky | Apr 13, 2010 | MySQL, Percona Software
Dear Community, The notice is hereby given that next version 1.2 of XtraBackup software is released. The list of changes in this version includes: Changelog: XtraBackup supports now XtraDB 10 tar4ibd supports variable page size and fast_checksum of XtraDB Supported...
by Peter Zaitsev | Apr 11, 2010 | Insight for DBAs, MySQL
When replication runs out of sync first question you often ask is if someone could be writing to the slave. Of course there is read_only setting which is good to set in the slave but it is not set always and also users with SUPER privilege bypass it. Looking into...
by John.Partridge | Apr 8, 2010 | MySQL
Fast insertion – what Tokutek excels at – isn’t only important for handling high data rates. It also enables a new way to extract value from an existing database called ad hoc indexing. KAYAK has a billion rows stored in TokuDB and adding an index...
by Peter Zaitsev | Apr 8, 2010 | Insight for DBAs, MySQL
Every so often I am working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ? MySQL distribution has a great script...
by Morgan Tocker | Apr 8, 2010 | MySQL, Percona Events
We’ve just launched training for London, Seattle, San Francisco, Atlanta, Orlando, Columbus, Dallas, San Diego, Denver, Minneapolis, New York City, Chicago & Washington DC. This is in addition to Los Angeles, Raleigh & Toronto – which had...
by Vadim Tkachenko | Apr 8, 2010 | Hardware and Storage, MySQL
While a scale-out solution has traditionally been popular for MySQL, it’s interesting to see what room we now have to scale up – cheap memory, fast storage, better power efficiency. There certainly are a lot of options now – I’ve been meeting...
by John.Partridge | Apr 7, 2010 | MySQL
At this year’s O’Reilly MySQL Conference we will be showing the latest version of our MySQL storage engine, TokuDB v3.1. Come visit us at Table T1 in the OEM section of the Exhibit Hall. We will be talking about how TokuDB can dramatically improve...
by Vadim Tkachenko | Apr 2, 2010 | Hardware and Storage, MySQL
I often hear suggestion to use fadvise 1 fadvise system call to avoid caching in OS cache. We recently made patch for tar 1 tar , which supposes to create archive without polluting OS cache, as like in case with backup, you do not really expect any benefits from...
by Peter Zaitsev | Mar 30, 2010 | Insight for Developers, MySQL
Andrew from Sphinx continues to work on improving SQL (or SphinxQL) support and now he published benchmarks comparing arithmetic expression handling in Sphinx to one in MySQL. The result ? Sphinx scored 3x to 20x faster. Andrew goes to explain results are not 100%...
by Peter Zaitsev | Mar 26, 2010 | MySQL, Percona Software
In XtraDB we have the table INNODB_BUFFER_POOL_PAGES_INDEX which shows which pages belong to which indexes in which tables. Using thing information and standard TABLES table we can see how well different tables fit in buffer pool. SELECT d.*, ROUND(100 * cnt * 16384 /...
by John.Partridge | Mar 25, 2010 | MySQL
Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 3.1. It is designed for continuous querying and analysis of large volumes of rapidly arriving and changing data, while maintaining full ACID properties. TokuDB v3.1’s new...
by Vadim Tkachenko | Mar 24, 2010 | Benchmarks, MySQL
Along with maximal possible fsync/sec it is interesting how different software RAID modes affects throughput on FusionIO cards. In short conclusion, RAID10 modes really disappoint me, the detailed numbers to follow. To get numbers I run sysbench fileio 1 sysbench...
