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.012, elapsed 0.1355 seconds.
54 queries taking 0.128 seconds, 336 records returned.
Powered by Minx 1.1.6c-pink.