Saturday, February 15

Geek

I Love Technology!

On the new server, I'm using MariaDB with TokuDB instead of the fairly old vanilla MySQL we've been running on for years (which has actually served us pretty well, except for the limitations of MyISAM).

It's little things like this that make you notice that things have really improved:

MariaDB [(none)]> show processlist;
+----+------+-----------+------+---------+------+----------------------------+----------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+------+-----------+------+---------+------+----------------------------+----------------------------------------------------------------------+----------+
| 18 | root | localhost | minx | Query | 73 | Inserted about 577000 rows | load data infile '/data/load/dx_post_09.d' ignore into table dx_post | 29.534 |
| 19 | root | localhost | NULL | Query | 0 | NULL | show processlist | 0.000 |
+----+------+-----------+------+---------+------+----------------------------+----------------------------------------------------------------------+----------+

You mean I can actually see the progress of a long-running operation?  Inconceivble!

Posted by: Pixy Misa at 10:13 PM | No Comments | Add Comment | Trackbacks (Suck)
Post contains 140 words, total size 1 kb.

Comments are disabled. Post is locked.
45kb generated in CPU 0.0255, elapsed 0.1541 seconds.
54 queries taking 0.1367 seconds, 344 records returned.
Powered by Minx 1.1.6c-pink.