…id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo', 'dashboard_customer_sales', 'INCREMENTAL'); SET @mvid := LAST_INSERT_ID…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… waits only at the last stages when its making changes…a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking …get piled up waiting for table metadata lock bringing down the MySQL server or causing all the connections to get… affected (0.09 sec) session1 > insert into t1 values(null); Query …
Post: GROUP_CONCAT useful GROUP BY extension
September 4, 2006 By 49 Comments
… to get PHP array without looping inside PHP: Table: CREATE TABLE services ( id INT UNSIGNED NOT NULL, client_id INT UNSIGNED NOT NULL, KEY (id)); INSERT INTO… from PHP to MySQL server side. Also it can be handy to use result concatenated string as part of IN statement: Sure, last…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…last‘ serious bug in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id…been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, … is a good way to get large data manageable. MySQL Master Master Manager can…
