… RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 … Let’s take a look at the graphs have a better view of the whole picture. Note, in the above … “INSERTs Per Second” on the y-axis. The reason why I have chosen to show “millions of rows” on …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… 50ms. Low values, such as 3,4 provided a bit better performance but I decided against using this as I did… wondering if 0 is automatic selection why do we have value of 62 being default in MySQL 5.5 which can produce… more important than backward compatibility. In MySQL 5.6 things are likely to get even better handling joins of many tables as…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… second edition! This year’s MySQL Conference and Expo will be the best ever, with a better lineup of talks and speakers…’re at all interested in MySQL. We really want you to be there — and that’s why we’re giving away free… retweet us when we mention this contest Tweet “My favorite #MySQL conference session” with a link to your favorite “Like” your…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… its write performance – I wrote about it before, that’s why I am looking for comparable alternatives. Samsung 830 256GB looked… drive periodically cleans an internal cache or something. To understand better what kind of response time we should expect, I ran… provides much better throughput than Intel 320 (some results for Intel 320). If you are interested more in SSD and MySQL questions…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… regular community MySQL 5.5.23 or does it only work (or work better) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what…; shortly after Oracle took it over. Can you comment on why this is happenign, and if it is happening across the…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
March 15, 2012 By 37 Comments
… one Linux distribution is better or another. I would say let the people use what they like. But why the package maintainers don’t just write sane install and init scripts for MySQL? The most annoying… the ‘check_for_crashed_tables’ function (found in /usr/share/mysql/debian-start.inc.sh) which, among other things, does nasty…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… easy to add support for Percona XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve… three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance… response time and throughput will be affected (and not towards better side). But this is price to pay for synchronous not…
Post: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
… why MySQL Enterprise would be more “stable” than community if it is more bleeding edge, it is used by less people and MySQL… as Enterprise class why would not you use something MySQL considers Enterprise Quality ? What is really better for distribution users ? Does MySQL actively “recommends…
Post: Why Index could refuse to work ?
September 8, 2006 By 13 Comments
… (0.00 sec) Why on the earth index would not be used you would think, even if MySQL is mentioning it in… row in set (0.00 sec) Looks much better does not it ? So why you would define something as VARCHAR and when… a sting in your application by using “”. You may ask why MySQL can’t use index in this case, simply by converting…
Post: More on MySQL Error Messages
April 6, 2011 By 9 Comments
… why this could happen, the answer is you may get some extra files, which do not belong to MySQL in database directory. MySQL… file would be much more appropriate here and error code (better with description) would be great. What is the problem in… process a lot more complicated, so it is a lot better if it is fixed in upstream.
