…indexes) # du -sh * 203M ibdata1 128M ib_logfile0 128M ib_logfile1 988K mysql 2.1G ontime1 2.1G ontime10 2.1G ontime11 2.1G ontime12 2…selected in the list of columns to show (click show/hide to change the columns) That the “public dns” field is selected…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…mysql_ functions directly as…PHP application: > SELECT * FROM articles WHERE user_id IN(23,545,654,34) > instead of: > SELECT * FROM articles WHERE user_id IN (SELECT…index that has very low cardinality (1/2 a million rows with an index on a Boolean column…
Post: MySQL automatic data truncation can backfire
January 9, 2007 By 10 Comments
… for these tables such as: select data from cache0003 where `…PHP version it became signed. The system worked on 32bit platform initially so “key” column was defined as “int” As…MySQL truncating this value to 2^32-1, then performing index ref lookup (traversing about half of the rows in pages as…
