by Peter Zaitsev | Feb 27, 2008 | Benchmarks, Percona Events
I got first Sun/MySQL Newsletter Today which among other things lead to the site publishing among other things links to various stuff related to Sun and MySQL and among other things – These Benchmarks This may be great piece of Benchmarks for Sales and Marketing...
by Peter Zaitsev | Feb 15, 2008 | Insight for Developers
I never liked how build in WordPress search works. it shows full documents rather than snippets it does not search comments and it does not have any query language so I always used Google search if I wanted to find something on MySQL Performance Blog. Today we have...
by Peter Zaitsev | Feb 14, 2008 | Percona Events
As some of you surely know already I’m moving back to USA, so does Vadim. From very beginning we had much more business from US than from rest of the world combined so this is a great step in company development having more comfortable time zones for our...
by Peter Zaitsev | Feb 12, 2008 | Insight for DBAs, MySQL
Probably most of MySQL users sometimes had a situation when they would do changes in MySQL config file without restarting the server (maybe matching SET GLOBAL command to do it in run time). This could be because it is misspelled or because the given version does not...
by Martin.FarachColton | Feb 11, 2008 | MySQL
Last time, I introduced the notion of strict and lenient updates. Now it’s time to see what the performance characteristics are of each. Just to rehash, 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 | Feb 7, 2008 | Insight for Developers
Preparing to move I’m selling stuff on GumTree which is UK based clone of Craigslist offering similar functionality but with Ads 🙂 Similarly to Craigslist GumTree is powered by MySQL but unlike craigslist it looks like they are shy in tuning their MySQL Full...
by Peter Zaitsev | Feb 6, 2008 | Insight for DBAs
Sergey Petrunia brought to my attention the work Optimizer Team has done in MySQL 6.0 related to SubQuery Optimization. I am excited to see this information published honestly outlining the things which are fixed now and things which are still not handled well....
by Martin.FarachColton | Feb 5, 2008 | MySQL
So far, I’ve analyzed point and range queries. Now it’s time to talk about insertions and deletions. We’ll call the combination updates. Updates come in two flavors, and today we’ll cover both. Depending on the exact settings of your database,...
by Peter Zaitsev | Feb 4, 2008 | Insight for DBAs
Finding the largest tables on a MySQL instance is a no brainer in MySQL 5.0+ thanks to Information Schema, but I still wanted to post a little query I use for the purpose so I can easily find it later. Plus it is quite handy in a way it presents information: SELECT...
by Peter Zaitsev | Feb 3, 2008 | Percona Events
Guess what ? I also will be speaking at MySQL Users Conference 2008, which is always excited. According to session schedule I’ll have one talk about Innodb Scalability Limits and another one together with Andrew Aksenoff about Sphinx. Looking back at Proposals...
by Peter Zaitsev | Feb 1, 2008 | Benchmarks, Insight for Developers
One performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which defaults to HASH index type by default, instead of BTREE which makes indexes unusable for prefix matches or range lookups. This is however not...
by Peter Zaitsev | Jan 29, 2008 | Insight for DBAs
As MySQL Manual Says Query Cache works with transactions with Innodb tables but it does not tell you how and with which restrictions. According to my tests it works but it is very restricted and one could expect it to work much better: The result set can be retrieved...
by Peter Zaitsev | Jan 29, 2008 | Percona Events
This weekend we’re hearing great news from Michael “Monty” Widenius – one of the Fathers of MySQL. Monty finally found a time to create his own blog with very descriptive name Monty Says. At the same time Monty finally announces Maria –...
by Peter Zaitsev | Jan 29, 2008 | Insight for DBAs
As you might know even if you’re only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is likely for relay logs to run out of sync (they are not synced to the disk) plus position on the...
by Alexey Kovyrin | Jan 24, 2008 | Benchmarks
Really often in customers’ application we can see a huge tables with varchar/char fields, with small sets of possible values. These are “state”, “gender”, “status”, “weapon_type”, etc, etc. Frequently we suggest to...
by Martin.FarachColton | Jan 21, 2008 | MySQL
Last time I talked about point queries. The conclusion was that big databases and point queries don’t mix. It’s ok to do them from time to time, but it’s not how you’re going to use your database, unless you have a lot of time. Today, I’d...
by Peter Zaitsev | Jan 21, 2008 | Percona Events
Kaj wrote me email yesterday asking if I was sleeping for a whole week or may be dead because I’m probably the only one of people blogging about MySQL who has not commented about announced Sun – MySQL Deal. In fact I was just on extremely busy travel...
by Tokutek | Jan 18, 2008 | MySQL
Insertion and Queries Databases are complicated beasts, but I’d like to focus on the storage engine, just the part that talks to the storage system, and doesn’t have to worry about SQL, etc.: just transactions, concurrency, compression, updates and...
by Peter Zaitsev | Jan 11, 2008 | Insight for DBAs
When you’re storing text of significant size in the table it often makes sense to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute for the BLOB/TEXT columns which would make...
by Andrew Aksyonoff | Jan 10, 2008 | Insight for Developers
Sometimes you need to work with big numbers in PHP (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use BIGINT 64-bit ids; e.g. if you are encoding additional information like the server ID into high bits of the ID. I had already...
