… it is a good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand it better. If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load… work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load… Intel 320). If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9… will be the same as my talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… not totally as ignorant as my “archetype” above. It is interesting to note that before I pointed out that Percona Server…. This is an observation that interests me, since it is completely different from what the core MySQL community focuses on – in fact… cherry pick patches on top of that might be worth questioning.
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. When you can divide it per number of “Questions” or “Com_select” to get amount of IO … can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (…. The query time distribution histogram is also very interesting here we can see this query which analyzes …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, …, thus a potential deadlock. The locks in question are LOCK_global_system_variables and LOCK… I have reported it as bug 63203. Interestingly Valeriy Kravchuk has confirmed it by finding another…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…as queries. The key here is that the question “can anything be improved” requires a process for…query executed for, which has been available in MySQL for years. This is necessary for determining whether… kinds of sub-second performance stalls we are interested in. Without data, you can only guess; and…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
One common theme in the questions our MySQL Support customers ask is Replication Lag. The story is typically … as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… there are any suspicious events in the replication traffic. An interesting thing to note – scripts can hurt replication traffic well after…
Post: More on MySQL Error Messages
April 6, 2011 By 9 Comments
… of days. mysql> drop database test; ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./test/’, errno: 17) First question you should… some extra files, which do not belong to MySQL in database directory. MySQL will only remove files it knows about such as…=0 ouid=0 name=”/usr/share/mysql/english/errmsg.sys” The bad error reporting has an interesting property – you do not care…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… question is how cool you want your database operation to be ? Visiting customers I see 2 very distinct groups of MySQL Users… was not done before, they are interested in all kinds of plugins, replicating from MySQL to Cassandra and doing other cool stuff… this – you might think most relevant players in MySQL community participated in MySQL Users Conference over the years. This is about 2000…
