show – Made by Mikal

Estimating the progress of queries on MySQL

Post author:mikal
Post published:May 8, 2008
Post category:Mysql

I've been doing a lot of batch updates on one of my databases at home recently. show processlist says something like this: mysql> show processlist; +-------+------+---------------+--------------+---------+-------+----------+------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+------+---------------+--------------+---------+-------+----------+------------------------------------------| | 18354 | root | maui:37403 | smtp_servers | Query | 57234 | Updating | update ips_218 set reverse_lookup = null | | 22286 | root | maui:37348 | smtp_servers | Query | 38103 | Updating | update ips_80 set reverse_lookup = null, | | 22851 | root | maui:54982 | smtp_servers | Query | 34091 | Updating | update ips_19 set reverse_lookup = null, | | 23351 | root | molokai:58232 | smtp_servers | Sleep | 57 | | NULL | | 23496 | root | maui:40923 | smtp_servers | Query | 29973 | Updating | update ips_62 set reverse_lookup = null, | | 23906 | root | maui:38068 | smtp_servers | Query | 26794 | Updating | update ips_83 set reverse_lookup = null, | | 25675 | root | maui:56438 | smtp_servers | Query | 12505 | Updating | update ips_82 set reverse_lookup = null, | | 25846 | root | maui:41334 | smtp_servers…

US Hi 5

Post author:mikal
Post published:February 21, 2006
Post category:Travel

So, we're in America and one of the kid's favourite shows comes on. Hi 5. Except it's not the Australian version -- it's full of five US people. It's strange because the opening sequence is the same as the Australian version (which implies to me that the Australian show might have been licensed over here) and the format seems to be the same, just the actors all have American accents.

End of content

No more pages to load