June 19, 2013

Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6

… in MySQL 5.6.6…. which I reported in Early 2006 (while still being with MySQL) and running MySQL 4…. values. Often it is just better to standardize on a few and not take decision in every … requests without throwing the error is not good idea in most cases, yet MySQL continues to be very …

Post: Paul McCullagh answers your questions about PBXT

…? If you read the white paper from 2006 (http://primebase.org/download/pbxt_white_paper.pdf… Instead, the application can hit a “optimistic lock error” if a record is updated by another user…major changes to MySQL itself).  What war stories can you report on in plugging into MySQL? Unfortunately the …

Comment: COUNT(*) vs COUNT(col)

… set (0.00 sec) mysql> btw, if there is a smaller secondary index on the table, innodb is … 1 row in set (0.23 sec) mysql> select count(*) from wp_comments; ERROR 2006 (HY000): MySQL server has gone away No connection…

Comment: MySQL Server Variables - SQL layer or Storage Engine specific.

mysql) % time seconds usecs/call calls errorsmysql I saw the following: show variables like ‘%large%’; +———————+———+ | Variable_name | Value | +———————+———+ | large_files_support | ON | | large_page_size | 2097152 | | large_pages | ON…37:15 CET 2006 x86_64 GNU…