Warning: Table './oots/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:164:\"Table './oots/comments' is marked as crashed and last (automatic?) repair failed\nquery: SELECT COUNT(*) FROM comments c WHERE c.nid = 124 AND c.status = 0\";s:5:\"%file\";s:44:\"/var/www/oots/modules/comment/comment.module\";s:5:\"%line\";i:991;}', 3, '', 'http://outoftheslipstream.com/node/124', '', '54.196.72.162', 1508370949) in /var/www/oots/includes/database.mysql.inc on line 135

Warning: Table './oots/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:432:\"Table './oots/comments' is marked as crashed and last (automatic?) repair failed\nquery: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 124 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 50\";s:5:\"%file\";s:44:\"/var/www/oots/modules/comment/comment.module\";s:5:\"%line\";i:991;}', 3, '', 'http://outoftheslipstrea in /var/www/oots/includes/database.mysql.inc on line 135
Internet Scale Databases | Out of the Slipstream
  • user warning: Table './oots/comments' is marked as crashed and last (automatic?) repair failed query: SELECT COUNT(*) FROM comments c WHERE c.nid = 124 AND c.status = 0 in /var/www/oots/modules/comment/comment.module on line 991.
  • user warning: Table './oots/comments' is marked as crashed and last (automatic?) repair failed query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 124 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 50 in /var/www/oots/modules/comment/comment.module on line 991.

Internet Scale Databases

Rob and I have just published a presentation on slideshare titled Mumps the Internet Scale Database.

It looks at the fit between the plain old Mumps database and the needs of Internet scale applications (think Google search, Twitter, Facebook, eBay, etc).

Many of the largest scale Internet plays have found conventional relational databases to be inadequate for their needs. In most cases they've had to innovate and cobble together something useable from scratch. The traditional SQL solutions were neither scaleable enough or affordable. Some of their solutions, such as Amazon's SimpleDB and Google's BigTable, are now starting to appear as commercial products that others with Internet-scale needs can also use.

I've written previously about Drizzle, a fork of MySQL, which tries to be an Internet-scale solution, by throwing out a lot of SQL clutter. In most cases, when trying to create a database that will scale sufficiently, the first casualty is SQL. This is certainly the case for BigTable and SimpleDB. Neither have full implementations of SQL and we get back to schemaless, hierarchical databases. Why? Because they are fast and flexible. The overheads of SQL add nothing in the context of large scale Internet databases and simply slow down the speed of development and, more importantly, the performance of the application.

Our presentation shows how plain old Mumps is a well proven database solution with a track record of success that meets all of the needs of Internet scale applications. It explains what the issues are and how the new kids, Amazon and Google, have had to innovate to scale. It goes on to show how Mumps has already solved these problems and is a freely available alternative to Amazon's and Google's pay-per-use propositions.

Enjoy...