… SQL Queries with Percona Toolkit, Feb. 25-28, 9-11 a.m. PST[/caption] Next week I… logs on the server. I read the logging code in MySQL 5.6.10 source, in file sql… option,Fetch,Daemon,Error‘), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`;…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…_vtable_mode). mysql> show warnings; +——-+——+————————————————————+ | Level | Code | Message | +——-+——+————————————————————+ | Error | 9999 | …c1 from ontime group by Year; Time: 9.54 sec Ok, so there …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…requires some knowledge of source code – you only get file …next section is about deadlock errors: ———————— LATEST DETECTED DEADLOCK ———————— 060717 4:16:…InnoDB 442 mysql tables in use 1, locked 0 MySQL thread …57973114, created 251137, written 10761167 9.79 reads/s, 0….
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…YouTube, Yahoo, are not good for like 99.9% of the applications because they are not …me simple is best. Complex architectures are more error prone harder to maintain (upgrades etc) and troubleshoot… because of bad code or something unpredicted. Summary: So am I denying all MySQL industry practices (…
Comment: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
…), you know that this process is extremely tedious and error prone. It just isn’t worth it if you … 99.9% cache hit rate in production. In practice, that means that even if the queries through to MySQL are …. It stinks of a lack of understanding of how code actually gets written. It’s like DBAs aren’t…
