by Peter Zaitsev | Apr 17, 2008 | Insight for DBAs
MySQL Users Conference 2008 has number of Storage Engines presented which claim to Kick Ass. Walking in exhibition hall you could see KickFire, Infobright, Tokutek, ScaleDB. I have not seen NitroDB in the exhibition call this year but they are also worth to mention....
by Peter Zaitsev | Apr 17, 2008 | Percona Events
On Monday I had a chance to have a chat with Paul Vallee from Pythian. This was quite an enlightening talk, and I was very impressed by Paul openness and willing to share with me a lot of internal operations details. I wish there would be more people out where as open...
by Vadim Tkachenko | Apr 15, 2008 | Insight for DBAs
Looking into InnoDB docs I found list of names of future InnoDB file formats: Antelope, Barracuda, Cheetah, Dragon, Elk, Fox, Gazelle, Hornet, Impala, Jaguar, Kangaroo, Leopard, Moose, Nautilus, Ocelot, Porpoise, Quail, Rabbit, Shark, Tiger, Urchin, Viper, Whale, X, Y...
by Peter Zaitsev | Apr 15, 2008 | Uncategorized
As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see Heikki and the Team were not just doing only bug fixes for last two years, but rather kept very quite. We had access to this code for few weeks and should say we...
by Vadim Tkachenko | Apr 15, 2008 | Percona Events
Reading evening news and rss feeds I found interesting next sequence: Jeremy’s post “MySQL to launch new features only in MySQL Enterprise” basically about some new features of MySQL will be available only for paid customers Then Kaj’s post...
by Peter Zaitsev | Apr 14, 2008 | Uncategorized
Yesterday I had a chance to speak to Igor – head of MySQL optimizer team and Timur – both of them expressed concern with TPC-H run results I posted and notes about little gains in MySQL 6.0. Do not get this post wrong. I’m not saying MySQL 6.0...
by Peter Zaitsev | Apr 14, 2008 | Percona Events
Yesterday we started the conference early with MySQL Community Dinner which was quite a success with about 30-50 people showing up (hard to count as people come and go) even though it was conflicting with Silicon Valley MySQL Meetup and which at least prevented Jeremy...
by Peter Zaitsev | Apr 14, 2008 | Percona Events
Percona, the company maintaining MySQL Performance Blog has a good presence on the conference this year. We have me (Peter), Vadim, Aurimas, Baron and Andrew attending the show. Alexey had to stay because he could not get Visa in time and Maciek is staying to be able...
by Peter Zaitsev | Apr 10, 2008 | Benchmarks
We were doing MySQL Performance evaluation on TPC-H queries for the client and they kindly allowed us to publish results which are very interesting. This is obviously not audited TPC-H run, and it can’t be because we used MyISAM tables which are not ACID...
by Peter Zaitsev | Apr 9, 2008 | Insight for DBAs
There are interesting posts these day about future of MySQL Replication by Brian Frank and Arjen. I think it very interesting to take a look at a bit bigger picture using framework from Innovators Dilemma and Innovators Solution. I’m not going to speak about...
by Peter Zaitsev | Apr 9, 2008 | Benchmarks
Reading Barons post about Kickfire Appliance and of course talking to them directly I learned a lot in their product is about beating data processing limitations of current systems. This raises valid question how fast can MySQL process (filter) data using it current...
by Peter Zaitsev | Apr 8, 2008 | Insight for DBAs
If you’re using Innodb tables MySQL has innodb_flush_log_at_trx_commit variable which defines how durable your transactions are. If you have high durability requirements you set it to 1 and log records are pushed directly to the disk on transaction commit. If...
by Peter Zaitsev | Apr 6, 2008 | Insight for DBAs
So you’re running dedicated MySQL Linux box with plenty of memory, so the good question arises if you should have swap file enabled or disable it ? I’ve seen production successfully running on boxes both with and without swap file so it is not the question...
by Peter Zaitsev | Apr 4, 2008 | Percona Events
So it looks like these days Kickfire welcomed everyone to tell they’ve been working with Kickfire – Baron Keith Frank is writing about KickFire. Good Job Kickfire PR team you really energized community. We also were working with Kickfire for quite a while...
by Peter Zaitsev | Apr 4, 2008 | Insight for Developers
We have an application which stores massive amount of urls. To save on indexes instead of using URL we index CRC32 of the URL which allows to find matching urls quickly. There is a bit of chance there would be some false positives but these are filtered out after...
by Martin.FarachColton | Apr 4, 2008 | MySQL
Recall that I’ve claimed that it takes 28 years to fill a disk with random insertions, given a set of reasonable assumptions. Recall what they are: We are focusing on the storage engine (a la MySQL) level, and we are looking at a database on a single disk...
by Peter Zaitsev | Apr 3, 2008 | Percona Events
On his way to MySQL Users Conference Andrew will stop by in Moscow, Russia and give a talk about Sphinx current features, development plans, and deployment use cases. Interesting enough the meeting will take place at Moscow State University, Computer Science Faculty...
by Peter Zaitsev | Apr 2, 2008 | Insight for Developers
Today a customer asked me to help them to convert their sequence generation process to the stored procedure and even though I have already seen it somewhere I did not find it with two minutes of googling so I wrote a simple one myself and posting it here for public...
by Peter Zaitsev | Mar 31, 2008 | Benchmarks
Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had a...
by Aurimas Mikalauskas | Mar 27, 2008 | Insight for DBAs
Few months ago, I wrote about a faster way to do certain table modifications online. It works well when all you want is to remove auto_increment or change ENUM values. When it comes to changes that really require table to be rebuilt – adding/dropping columns or...
