Saturday, February 15
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).
You mean I can actually see the progress of a long-running operation? Inconceivble!
Comments are disabled.
Post is locked.
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 |
+----+------+-----------+------+---------+------+----------------------------+----------------------------------------------------------------------+----------+
Posted by: Pixy Misa at
10:13 PM
| No Comments
| Add Comment
| Trackbacks (Suck)
Post contains 140 words, total size 1 kb.
45kb generated in CPU 0.0357, elapsed 0.7079 seconds.
54 queries taking 0.6992 seconds, 342 records returned.
Powered by Minx 1.1.6c-pink.
54 queries taking 0.6992 seconds, 342 records returned.
Powered by Minx 1.1.6c-pink.
