Estimating the progress of queries on MySQL

  • Post author:
  • 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…

Continue ReadingEstimating the progress of queries on MySQL

Done and done

  • Post author:
  • 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!

Continue ReadingDone and done

Time for a status update?

  • Post author:
  • 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.

Continue ReadingTime for a status update?

Book status

  • Post author:
  • 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…

Continue ReadingBook status

End of content

No more pages to load