by Baron Schwartz | Sep 28, 2009 | Insight for DBAs, MySQL
This is a very old draft, from early 2007 in fact. At that time I started to look into something interesting with the index cardinality statistics reported by InnoDB tables. The cardinality varies because it’s derived from estimates, and I know a decent amount...
by Yasufumi Kinoshita | Sep 15, 2009 | Benchmarks, Percona Software
As you may know, InnoDB has 2 limits for unflushed modified blocks in the buffer pool. The one is from physical size of the buffer pool. And the another one is oldness of the block which is from the capacity of transaction log files. In the case of heavy updating...
by Peter Zaitsev | Sep 14, 2009 | Insight for DBAs
What is wrong here (the part of SHOW INNODB STATUS): ————– ROW OPERATIONS ————– 8 queries inside InnoDB, 9 queries in queue 100 read views open inside InnoDB It is relationship between queries active –...
by Vadim Tkachenko | Sep 14, 2009 | Percona Software
If you ever wondered how big is that or another index in InnoDB … you had to calculate it yourself by multiplying size of row (which I should add is harder in the case of a VARCHAR – since you need to estimate average length) on count of records. And it...
by Peter Zaitsev | Sep 10, 2009 | Insight for Developers
It is rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason of the move could be just desire for better data consistency guaranty or being bitten repairing multiple GB MyISAM table few times, though Table Locks is probably...
by Morgan Tocker | Sep 10, 2009 | Percona Events
Today’s the day I fly to Los Angeles to teach a private training class, en route to Santa Clara/San Francisco for our public training workshops next week. Our Montreal practice teach at Station-C went great – it was an opportunity to do a road test and...
by Peter Zaitsev | Aug 28, 2009 | Insight for Developers
Couple of days ago I was looking for a way to improve update performance for the application and I was replacing single value UPDATE with multiple value REPLACE (though I also saw the same problem with INSERT ON DUPLICATE KEY UPDATE) As I went from 1 value to 3 or 10...
by Morgan Tocker | Aug 13, 2009 | Percona Software
Note: This post is part 2 of 4 on building our training workshop. Last week I talked about why you don’t want to shard. This week I’m following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. ...
by Peter Zaitsev | Aug 11, 2009 | Insight for DBAs
As you might have seen Innodb Plugin 1.0.4 was released today. I am very excited to see this release which is released exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released by MySQL Conference and Expo in...
by Morgan Tocker | Aug 4, 2009 | Percona Events
Today, we are announcing that we’re ready to offer training for InnoDB and XtraDB in Santa Clara and San Francisco. The course was developed by Morgan Tocker with input from all our team – and covers a lot of the performance problems we run through in...
by Vadim Tkachenko | Aug 3, 2009 | Percona Software
If you do not follow MariaDB development, I want to head up XtraDB has been commited to MariaDB server and will be included in binary releases of MariaDB (scheduled on end of August – September) as replacement of InnoDB storage engine. MariaDB will also include...
by Vadim Tkachenko | Jul 31, 2009 | Percona Software
The feature I announced some time ago https://www.percona.com/blog/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going to show how to use it (the video will be...
by Vadim Tkachenko | Jul 14, 2009 | Benchmarks
There was small delay in our releases, part of this time we worked on features I mentioned before: – Moving InnoDB tables between servers – Improve InnoDB recovery time and rest time we played with performance trying to align XtraDB performance with MySQL...
by Vadim Tkachenko | Jun 8, 2009 | Percona Software
This is probably the feature I missed most from early days when I started to use InnoDB instead of MyISAM. Since that I figured out how to survive without it, but this is first question I hear from customers who migrated from MyISAM to InnoDB – can I just copy...
by Vadim Tkachenko | May 15, 2009 | Insight for DBAs
I want to make this Friday a bit more interesting – how do you feel to train a bit in InnoDB data recovery techniques. I have .ibd datafile which was created by query CREATE TABLE tryme ( email mediumblob, content mediumblob ) ENGINE=InnoDB … (SOME...
by Vadim Tkachenko | May 1, 2009 | Benchmarks
In benchmarks passion (see my two previous posts) I managed to setup all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint controller, FusionIO card) on our working horse Dell PowerEdge R900 (btw, to do that I had to switch from CentOS 5.2 to...
by Peter Zaitsev | Apr 29, 2009 | Percona Events
MySQL 5.4 comes with Innodb engine which seems to have much better performance than MySQL 5.0 – this is due to locking and IO patches from Google integrated in this release (which are similar to appropriate Percona patches) as well as some unique fixes such as...
by Baron Schwartz | Apr 15, 2009 | Insight for DBAs
Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages from the buffer pool. These are pages that have been modified in memory, but not on disk. If you kill the server before it finishes this process, it will...
by Evgeniy Stepchenko | Apr 8, 2009 | Percona Software
Today we glad to announce release 1.0.3-4 of our XtraDB storage engine. Here is a list of enhancements in this release: Move to MySQL 5.1.33 Move to InnoDB plugin 1.0.3 more reliable replication, innodb_overwrite_relay_log_info patch now included in the release fix...
by Vadim Tkachenko | Mar 30, 2009 | Insight for DBAs
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores boxes for many workloads. And now it is time to look on systems with 32GB+ of RAM which are not rare nowadays. Working with real customer systems...
