… MySQL slave transaction_isolation=READ-COMMITTED You can get … svn checkout http://flexviews.googlecode.com/svn/trunk/ flexviews … php ./setup_flexcdc.php –ini consumer.ini $ php setup_flexcdc.php … table is `test`.`demo`. mysql> select * from flexviews.test_demo\G *************************** 1. …
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
… contained placeholders for parameters, for example “select name from user where id=?” and … a lot of problems with PHP prepared statements. It is getting better but still it …MySQL Server turned out to be prepare statements or cursors which were forgotten to be closed. Watch Com_stmt_prepare and Com…
Post: When EXPLAIN estimates can go wrong!
October 13, 2011 By 7 Comments
… a SIMPLE SELECT to see the actual count of rows: mysql [localhost] {msandbox} (foo2) > select count(*) from…MySQL 5.1 and how it calculates the row estimates. This bug was tracked down to http://bugs.mysql.com/bug.php…a few (10) of the intermediate pages to get a better estimate of the average number…
Post: GROUP_CONCAT useful GROUP BY extension
September 4, 2006 By 43 Comments
…? For example to get PHP array without looping inside PHP: Table: CREATE TABLE … | client_id | +—-+———–+ | 3 | 5 | | 3 | 6 | | 3 | 7 | +—-+———–+ SELECT id,GROUP_CONCAT(client_id) FROM…PHP: old way: with group_concat: This should work faster, as we remove loop from PHP to MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s … switching roles is a good way to get large data manageable. MySQL Master Master Manager can help you … not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: …
