… Service Companies. Let me give you an example This shows how MySQL Support Prices looked back in the end of 1999. As… things have changed both from pricing standpoint and quality standpoint – MySQL Support is still very good compared to many larger vendors… millions while MySQL could have these done for thousands or tens of thousands in some cases. As MySQL merge with Sun progresses I…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… of SSDs really a big advantage in practice? I will show the performance of two real customer systems running web applications… device was busy, and the average number of requests in progress at the time the samples were taken. [baron@ginger logstats… 6 and write concurrency reached 3. One of the samples shows the performance during a period of pretty high utilization. (Note…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… in our plans to create excellent free tools for MySQL administrators. There is one really big thing to talk … to learn how to run the tool again in “show me the differences” mode, and if you want to …’s clear, and then continues to Just Work. With progress reports, of course. And if you want to stop …
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…” state. Vanilla MySQL does not provide much diagnostic there, but there couple numbers to look into. If you take “SHOW ENGINE INNODB… spinning disks (as in this case), Percona Server may not show significant improvement. I am going to followup with results on… a lot of memory. I hope there is work in progress for MySQL 5.6. Scripts and raw results you can find…
Post: Percona Server and XtraBackup weekly news, March 12th
March 13, 2011 By Leave a Comment
Welcome to the weekly roundup and progress report. What’s new this week in Percona Server: As …, and read. This can be useful for understanding how much progress a query has made, and potentially how long until it… organize our thoughts more and have some real results to show. News this week for Percona XtraBackup: It’s now possible…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
… memory. It was long spoken about global resource management for MySQL, ie so I could restrict global temporary space for temporary… kernel for example. I would see it implemented similary to SHOW STATUS – threads could account statistics for their own memory usage… MySQL is progressing the problem of memory allocation transparency is becoming more and more serious. There are much more objects which MySQL can…
Post: Top 5 MySQL wishes - what is next ?
July 4, 2007 By 1 Comment
… – Developers have some wishes to ease development process, MySQL DBAs would like stuff related to operations like…is also a good overlap among people wishes which shows there are some things which are really needed … followup on the matter, to tell us what progress was achieved. It is easy to ask for…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… XtraDB-6. Now I am going to show how to use it (the video will … now some magic happens and you can see progress of import in error.log InnoDB: import: …98 99 100 done. When finished quick check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | 32093604 | +———-+ …
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… 00:06:16 mysqld restarted InnoDB: Log scan progressed past the checkpoint lsn 16 3276587130 080626 0… 9b 10b -> where 10b is master of 1a mysql> show master status; +————+———-+——————————————-+——————+ | File | Position | Binlog_Do_DB | Binlog…
Post: The feature I love in TokuDB
June 11, 2009 By 4 Comments
Playing with TokuDB updates I noticed in SHOW PROCESSLIST unsual for MySQL State. mysql> show processlist; +—-+——+———–+——–+———+——+—————————+—————————–+ | Id | User | Host | db | Command | Time | State | Info… looking in SHOW PROCESSLIST you can see progress of query execution. I would want to see it in standard MySQL and InnoDB more…
