by Peter Zaitsev | Feb 11, 2007 | Insight for Developers
This week I helped dealing with performance problems (part MySQL related and part related to LAMP in general) of system which does quite a bit of content delivery, serving file downloads and images – something a lot of web sites need to do these days. There were...
by Peter Zaitsev | Feb 8, 2007 | Insight for DBAs, MySQL
Have you ever seen a connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea why this would happen? MySQL Sleep I see if frequently with web applications and it is often indication of trouble. Not only it...
by Peter Zaitsev | Feb 5, 2007 | Insight for Developers
I already wrote kind of about same topic a while ago and now interesting real life case makes me to write again 🙂 Most Web applications we’re working with have single tier web architecture, meaning there is just single set of apache servers server requests and...
by Peter Zaitsev | Jan 31, 2007 | Insight for DBAs
There is one bug, or “missing feature” in MySQL Optimizer which may give you hard time causing performance problems which may be hard to track down, it is using only part of the index when full index can be used or using shorter index while there is longer...
by Peter Zaitsev | Jan 30, 2007 | Hardware and Storage
Found a great article about Linux IO Schedulers today which is quite interesting. It goes in details about schedulers and explains in which of workloads which of schedulers is best. The interesting thing this article points out is – there are multiple versions...
by Peter Zaitsev | Jan 30, 2007 | Insight for DBAs
Kevin Burton writes about making MySQL Replication Parallel. Many of us have been beaten by the fact MySQL Replication is single threaded so in reality it is only able to use only single CPU and single disk effectively which is getting worse and worse as computers are...
by Peter Zaitsev | Jan 19, 2007 | Insight for DBAs
We all know disk based temporary tables are bad and you should try to have implicit temporary tables created in memory where possible, do to the fact that you should increase tmp_table_size to appropriate value and avoid using blob/text columns which force table...
by Peter Zaitsev | Jan 19, 2007 | Percona Events
It looks like it looks like there are going a lot of discussions about future of MySQL Community Binaries, see for example this post and Kaj’s clarifications. Obviously now it grew to a lot of speculations and many comments are far from real story. It is also...
by Peter Zaitsev | Jan 18, 2007 | Insight for Developers
Jonathan Haddad writes about REPLACE INTO and INSERT ON DUPLICATE KEY UPDATE. Really, Why MySQL has both of these, especially both are non ANSI SQL extensions ? The story here seems to be the following – REPLACE INTO existed forever, at least since MySQL 3.22...
by Peter Zaitsev | Jan 17, 2007 | Insight for Developers
What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which were taking milliseconds to stall for few seconds, especially in certain OS...
by Peter Zaitsev | Jan 16, 2007 | Percona Events
Just got email from Jay today about two of my talks being accepted to MySQL Users Conference 2007 “MySQL Server Settings Tuning” and “MySQL Performance Cookbook”. This is great as MySQL Conferences are always fun and great way to get to know...
by Peter Zaitsev | Jan 16, 2007 | Percona Events
A friend pointed out to me number of our our articles were translated and included in PHPInside.RU – electronic magazine about PHP and surrounding technologies which of course include MySQL. You can download PDF for free right here. We love our articles being...
by Vadim Tkachenko | Jan 12, 2007 | Percona Events
Update 3 June 2008: We have removed the builds below, since they are quite obsolete and no one has posted comments about them since more than a year ago. Great news are MySQL finally released new Community release – MySQL 5.0.33, which however as promised comes...
by Peter Zaitsev | Jan 12, 2007 | Insight for DBAs
Now as new MySQL Storage engine – Falcon is public I can write down my thought about its design, which I previously should have kept private as I partially got them while working for MySQL. These thought base on my understanding, reading docs, speaking to Jim,...
by Peter Zaitsev | Jan 11, 2007 | Percona Events
We’re looking to implement CJK Support in Open Source Full Text search engine Sphinx . Initially we’re thinking to base search ob bi-gram indexing to keep it simple, especially as according to research papers it offers decent quality for most cases. This...
by Peter Zaitsev | Jan 10, 2007 | Benchmarks, Insight for Developers
To check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query and see if there is any significant improvement. Leaving aside question of checking single query alone might not be...
by Peter Zaitsev | Jan 9, 2007 | Insight for Developers
I had a fun case today. There is set of cache tables which cache certain content in MyISAM tables and queries for these tables such as: select data from cache0003 where `key`=2342526263 and real_key='cp_140797_6460aad5d2e50d3e859e8649007686ac'; 1 select data from...
by Vadim Tkachenko | Jan 9, 2007 | Insight for DBAs
I just want to write few tips how to get MySQL from development BitKeeper tree, as there are several tricks. First of all you need a fresh free client – bk-client2.0 http://www.bitkeeper.com/Hosted.Downloading.html . Once you get it, you can clone latest tree:...
by Peter Zaitsev | Jan 8, 2007 | Percona Events
We’re happy to announce Andrew Aksyonoff, developer of popular OpenSource full text search software Sphinx joins our team. Andrew will now have more time to dedicate to Sphinx development so cool new features will come sooner. Having Andrew on board we’ll...
by Vadim Tkachenko | Jan 8, 2007 | Benchmarks
Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM...
