progress – 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…

Done and done

Post author:mikal
Post published:March 30, 2007
Post category:Mythtv

Stewart finished off the last trailing chapter of the MythTV book a week or so ago, and I finished the last copy edit (the process where we learn US grammar) just now. That means we only need to have page layout done for a chapter or so and we're home. Hurrah!

Time for a status update?

Post author:mikal
Post published:February 5, 2007
Post category:Mythtv

It's been a while since I've commented on the MythTV book project, so it's worth a quick status update. We're basically into the home straight now -- we've decided what to cover in the book (which of course involves missing out on a few things which could be in there if we had infinite space and time), written the chapters (which are all now done), and are now working through technical review and copy edits. I'll keep you posted as we get closer to final production.

We’re 80% complete. If only we could get the code to compile we would be done!

Post author:mikal
Post published:November 25, 2006
Post category:Link

The progress reports on an old Microsoft project indicated near completion, if only they could get the code to compile.

Book status

Post author:mikal
Post published:November 25, 2006
Post category:Mythtv

I was thinking about the delivery status of the MythTV book as I was going off to sleep last night, and it occurred to me that the book is pretty much done. It's a good feeling. Stewart needs to finish poking a chapter on cut lists and so forth, with should be minimal effort, then he needs to work on chapters on MythWeb and VoIP (the VoIP one is half done). I need to write an updated introduction (the contents of the book have deviated from plan, although that always happens) as well as a short conclusion chapter, and help Stewart write a chapter about running the latest and greatest version of the code (and how to interact with the development community). Then we're done for the writing. That description can be summarised as "Stewart and I appear to both be about one and a half chapters away from finishing authoring". We of course still need to get through technical review, editorial review, replying to things those reviewers need changed, copy editing, page layout, and standing on one leg. We're getting towards the end of the project though. When I think about it that way, I guess I read the…

We’re getting there

Post author:mikal
Post published:September 13, 2005
Post category:Mirror

So, we're still pulling stuff, although a bit of that has been deciding what to pull... [icbm: home]