by Peter Zaitsev | Jul 27, 2008 | Percona Events
So I’m back from OSCON 2008. As usually it is fun conference to attend. Though I could only come for couple of days (Wed/Thu) as things are too busy here. Same as previous year I would note the conference is not as much backend and high performance focused as...
by Baron Schwartz | Jul 25, 2008 | Insight for DBAs
This article is not meant to malign hosting providers, but I want to point out something you should be aware of if you’re getting someone else to build and host your servers for you. Most hosting providers — even the big names — continue to install...
by Baron Schwartz | Jul 25, 2008 | Percona Events
Daniel Nichter, the author of several very useful MySQL tools, has joined with Percona to continue to improve Maatkit — the “other” toolkit we rely on daily. Daniel is a skilled Perl programmer who understands MySQL. He is in a perfect position to...
by Vadim Tkachenko | Jul 24, 2008 | Percona Software
As there were many requests for Debian binary packages in our announcement of Percona builds with custom patchsets, we decided to play with it and built .deb, which you can find there: Debian You can also add the following repositories into your sources.list: deb...
by Peter Zaitsev | Jul 20, 2008 | Insight for Developers
As you probably already seen in a post by Baron, Sphinx Release 0.9.8 is finally out, just in time for OSCON 2008. Even though it is “minor release” if you look at the number, it is major release in practice (and you can view snapshots as minor releases)....
by Peter Zaitsev | Jul 20, 2008 | Insight for Developers
As Baron writes it is not the number of rows returned by the query but number of rows accessed by the query will most likely be defining query performance. Of course not all row accessed are created equal (such as full table scan row accesses may be much faster than...
by Peter Zaitsev | Jul 19, 2008 | Percona Events
MySQL 5.1 was in RC stage for around 10 months now finally planned to be released as GA soon. As Monty Says MySQL 5.1.26 will be renamed as GA if no serious bugs are discovered. Lets help MySQL to ensure GA release will be indeed GA quality and support Monty in his...
by Vadim Tkachenko | Jul 16, 2008 | Percona Software
Percona has a strong team of MySQL developers and consultants on board, so we decided to prepare builds with our patches and third-party patches which we think are very useful. We actually use these internally and for our customers. Current releases include: microslow...
by Baron Schwartz | Jul 13, 2008 | Percona Events
I just posted slides from a talk I gave at a Facebook application developer conference in Las Vegas this weekend. The talk is titled Outrun the Lions. Our customers run several of the top 10 applications on Facebook right now (as measured by the number of active...
by Peter Zaitsev | Jul 9, 2008 | Hardware and Storage
One of our customers was setting up box for MySQL LVM backups. The box had 2 RAID volumes (internal drives and enclosure) with database being stored on enclosure drives and internal drives used pretty much for OS and logs (database grew too large and so was moved to...
by Peter Zaitsev | Jul 8, 2008 | Insight for DBAs
Baron recently wrote about very helpful but often forgotten about “Pager” feature of command line client. There is another one which falls into the same list – the –tee option. Specifying –tee=/path/to/file.log you can get all session...
by Peter Zaitsev | Jul 8, 2008 | Percona Events
I’ve now published slides from my talk at Velocity conference on Percona web site. Enjoy.
by Peter Zaitsev | Jul 7, 2008 | Insight for DBAs
As you probably know MySQL Replication (statement based) works by fetching statements from MASTERs binary log and executing them on the SLAVE. Since MySQL 4.0 this process is a bit more involved having events passing via relay logs on the Slave which also means there...
by Peter Zaitsev | Jul 6, 2008 | Percona Events
It looks like I never blogged about it but I’m going to be speaking on OSCON 2008. Similar to the last year presentation I’ll do overview of MySQL Open Source storage engines. I’ll do brief overview of different storage engines available out there as...
by Peter Zaitsev | Jul 4, 2008 | Insight for DBAs
Assume you’re running MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and some pages in Innodb tablespace got corrupted. In such cases Innodb will typically print something like...
by Baron Schwartz | Jul 3, 2008 | Benchmarks, Insight for Developers
Recently I had a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal was to load this data on many servers without putting it into the binary log. While this is generally a fast way to load data (especially if you disable unique...
by Peter Zaitsev | Jul 1, 2008 | Percona Events
We were chatting with Jeremy Cole today and he brought to my attention last version of MySQL Community Eddition (5.0.51) was released in November 2007 – over 7 months ago. MySQL 5.0.51a and MySQL 5.0.51b security fixes were released but these can’t be...
by Peter Zaitsev | Jun 30, 2008 | Insight for DBAs
I have been helping customer today to resolve his lockups in production by downgrading from MySQL 5.1.25 to 5.0 We have other customers (and our own projects as well) which run on MySQL 5.1 successfully but I can’t it is on par with MySQL 5.0 stability yet. This...
by Peter Zaitsev | Jun 29, 2008 | Insight for DBAs
Sometimes MySQL Replication may run out of sync – because of its own buts or operational limitations or because of application mistake, such as writing to the slave when you should be only writing to the master. In any case you need slave to be synced with...
by Peter Zaitsev | Jun 26, 2008 | Insight for Developers
I spent Monday and Tuesday this week on Velocity Conference It was quite interesting event worth attending and it was very good to see the problems in this are going beyond Apache, PHP, Memcache and MySQL. A lot of talks on this conference was focusing on what is...
