by Evgeniy Stepchenko | Dec 29, 2008 | Percona Software
Today we announce release 1.0.2-2 of our XtraDB storage engine. Here is a list of enhancements: split-buffer_pool_mutex The patch splits global InnoDB buffer_pool mutex into several and eliminates waitings on flush IO and mutex when there is no enough free buffers. It...
by Vadim Tkachenko | Dec 29, 2008 | Benchmarks
One of our customers gave me a chance to run some benchmarks on 24-core (intel cpu based) server, and I could not miss it and ran few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU...
by Vadim Tkachenko | Dec 23, 2008 | Percona Software
As you may know Sun / MySQL made release of community 5.0.75 only as source code release. We made binaries with our patchset. Patches are mostly equal to build 10 https://www.percona.com/blog/2008/12/11/mysql-binaries-percona-build10/, only change: it includes bugfix...
by Baron Schwartz | Dec 22, 2008 | Insight for Developers
We have a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types of work. The first thing these have in common is that they’re generally some kind of loggable event....
by Peter Zaitsev | Dec 22, 2008 | Insight for Developers
When your goal is to optimize application performance it is very important to understand what goal do you really have. If you do not have a good understanding of the goal your performance optimization effort may well still bring its results but you may waste a lot of...
by Vadim Tkachenko | Dec 18, 2008 | Benchmarks
Peter said me that previous results https://www.percona.com/blog/2008/12/18/xtradb-benchmarks-15x-gain/ are too marketing, and we should show other results also. Here is the run for CPU Bound,or it would be more correctly to say in-cache benchmark, because there is a...
by Vadim Tkachenko | Dec 18, 2008 | Benchmarks
I guess it is first reaction on new storage engine – show me benefits. So there is benchmark I made on one our servers. It is Dell 2950 with 8CPU cores and RAID10 on 6 disks with BBU, and 32GB RAM on board with CentOS 5.2 as OS. This is quite typical server we...
by Peter Zaitsev | Dec 17, 2008 | Insight for DBAs
So lets say you have .frm file for the table and you need to recover CREATE TABLE statement for this table. In particular when we do Innodb Recovery we often get .frm files and some mess in the Innodb tablespace from which we have to get data from. Of course we could...
by Peter Zaitsev | Dec 16, 2008 | Insight for DBAs
How much space would empty MyISAM table take ? Probably 8K for .frm file, 1KB for .MYI file and 0 for MYD file. .MYI file can be larger if you have many indexes. How much space will Innodb take: mysql> create table test_innodb(a int, b int) engine=innodb; Query OK,...
by Vadim Tkachenko | Dec 16, 2008 | Percona Software
Today we officially announce our new storage engine, “Percona XtraDB”, which is based on the InnoDB storage engine. It’s 100% backwards-compatible with standard InnoDB, so you can use it as a drop-in replacement in your current environment. It is...
by Peter Zaitsev | Dec 14, 2008 | Insight for DBAs
One command, which few people realize exists is SHOW OPEN TABLES – it allows you to examine what tables do you have open right now: mysql> show open tables from test; +----------+-------+--------+-------------+ | Database | Table | In_use | Name_locked |...
by Peter Zaitsev | Dec 14, 2008 | Percona Events
As Giuseppe just reminded MySQL 4.0 is reaching its end of life in about 2 weeks from now. When it becomes unsupported by MySQL via normal support agreements together with 3.23 version. At Percona we do not have such restriction and we will continue to support your...
by Peter Zaitsev | Dec 13, 2008 | Benchmarks
As you might have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30. It is interesting to compare with results I posted previously The quote from the results mentioned above: “Maybe you’ve seen some claims by others in the MySQL...
by Vadim Tkachenko | Dec 11, 2008 | Percona Software
We made new binaries for MySQL 5.0.67 build 10 which include next fixes: We addressed concerns about potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime. Next variables were...
by Peter Zaitsev | Dec 10, 2008 | Percona Events
I had a call with Monty the other day and I told him why I think MySQL Server Quality will never be the same again. I’ve been thinking a bit more about it and here is the extended list. In particular I think MySQL Server will never be able to reach its original...
by Peter Zaitsev | Dec 10, 2008 | Percona Events
MySQL 5.1 release as “GA” seems to be the most controversial to date. It had very negative response from Monty, original MySQL Founder and controversial responses in community including another beating by Kevin Burton. There is also very interesting...
by Vadim Tkachenko | Dec 9, 2008 | Percona Events
Well, actually it is not reading future, but just mysql-5.1.30.rhel4.spec file from MySQL RedHat 4 SRPM. I found there few MySQL Enterprise Editions, namely: MySQL Enterprise Server – Advanced Edition MySQL Enterprise Server – Pro Edition MySQL Enterprise...
by Peter Zaitsev | Dec 8, 2008 | Percona Events
Being completely distributed team, meetings are very important for us and this time we went to the Turkey in the end of October (yes, yes I could be faster with sharing photos) This went we went to Turkey, Antalya region, which is a destination which is very easy to...
by Peter Zaitsev | Dec 5, 2008 | Hardware and Storage
One typical question which frequently pops up is whenever it is better to use hardware upgrade or optimize software more. I already wrote about it, for example here. Today I’ll look at the same topic from the consultants view. When consultant should suggest...
by kuszmaul | Dec 5, 2008 | MySQL
A tip of the hat to Mark Callaghan, who suggested I post our my.cnf settings for iiBench. Instead of fiddling around with the configuration file, we adjusted everything on the command line. Here’s the relevant script from iiBench/scripts/start_mysql.sh: # #...
