by Vadim Tkachenko | Jun 2, 2010 | MySQL, Percona Software
In Percona Server security fix releases I mentioned patches for MySQL 4.0 and 4.1. I am happy to announce that GoDaddy.com released patches for MySQL 4.0 and MySQL 4.1 under GPL license and you can get them from our Launchpad: for 4.0:...
by Vadim Tkachenko | Feb 9, 2010 | MySQL, Percona Software
Our patches for 5.0 have attracted significant interest. You can read about SecondLife’s experience here, as well as what Flickr had to say on their blog. The main improvements come in both performance gains and improvements to diagnostics (such as the...
by Yasufumi Kinoshita | Oct 14, 2009 | Benchmarks, Insight for DBAs, MySQL
For the my previous post, there was comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads. At first, <tuning...
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 29, 2009 | Insight for DBAs
As you see MySQL is doing great in InnoDB performance improvements, so we decided to concentrate more on additional InnoDB features, which will make difference. Beside ideas I put before https://www.percona.com/blog/2009/03/30/my-hot-list-for-next-innodb-features/...
by Vadim Tkachenko | May 13, 2009 | Percona Software
I do not know if you noticed it, but Google (Mark Callaghan, Justin Tolmer and their internal mysql-team) made a great contribution to MySQL. Patches global transaction IDs, binlog event checksums and crash-safe replication state are separated and published on...
by Morgan Tocker | Mar 10, 2009 | Percona Events
Percona presented two talks at PHP Quebec last week – one on A Tour of MySQL High Availability, and another on Performance Tuning MySQL. There was a great reaction to showcasing some of the quick-wins that can be found by using the Percona patches....
by Vadim Tkachenko | Mar 4, 2009 | Percona Software
Running MySQL slave is quite common and regular task which we do every day, taking backups from slave is often recommended solution. However the current state of MySQL replication makes restoring slave a bit tricky (if possible at all). The main problem is that InnoDB...
by Vadim Tkachenko | Feb 11, 2009 | Percona Software
One of InnoDB’s features is that memory allocated for internal tables definitions is not limited and may grow indefinitely. You may not notice it if you have an usual application with say 100-1000 tables. But for hosting providers and for user oriented...
by Vadim Tkachenko | Feb 2, 2009 | Percona Software
The problem with broken group commit was discusses many times, bug report was reported 3.5Â years ago and still not fixed in MySQLÂ 5.0/5.1 (and most likely will not be in MySQLÂ 5.1). Although the rough truth is this bug is very hard (if possible) to fix properly. In...
by Vadim Tkachenko | Jan 23, 2009 | Benchmarks, Percona Software
Recent scalability fixes in InnoDB and also Google’s and your SMP fixes almost made InnoDB results acceptable in primary key lookups queries, but secondary indexes were forgotten for some time. Now having Dell PowerEdge R900 on board (16CPU cores, 16GB RAM) I...
by Vadim Tkachenko | Jan 23, 2009 | Percona Software
After several important fixes to our patches we made binaries for build12. Fixes include: Control of InnoDB insert buffer to address problems Peter mentioned https://www.percona.com/blog/2009/01/13/some-little-known-facts-about-innodb-insert-buffer/, also check Bug...
by Baron Schwartz | Jan 9, 2009 | Percona Software
Percona has been building and contributing to open-source software since the company was founded, and individually we’ve been doing the same thing for many years. We think it’s a huge value for our customers and the community. We’re involved in a...
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 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 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 Vadim Tkachenko | Nov 19, 2008 | Percona Software
After some discussions on the OpenSQLCamp 2008 conference we decided to move our development to Launchpad, to be in stream with other MySQL related projects. We published our patches there https://code.launchpad.net/percona-patches, it is supposed to be main...
by Vadim Tkachenko | Nov 14, 2008 | Percona Software
We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes: | innodb_check_defrag.patch | Session status to check fragmentation of the last InnoDB scan | 1.0 | Percona <[email protected]> | GPL | The...
by Yasufumi Kinoshita | Nov 13, 2008 | Benchmarks, Percona Software
Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”. — limit of “amount” — As you know, buffer...
by Vadim Tkachenko | Nov 11, 2008 | Percona Software
After some pause we are going to announce bunch of patches we made and ported for last period. Ported patches (ported from Google V2 patch): – innodb_fsync_source.patch – Show information about callers of fsync, more info – innodb_io_tune.patch...
