… customer_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo',...calculated (for all time) from a monthly summary. The monthly summary is actually another MV. …use those aggregate functions. Now I delete some line items from orders: mysql> delete -> from order_…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… last months I’ve seen lots of customers trying to tune the thread concurrency inside MySQL with the …and removed on 5.6.1 http://bugs.mysql.com/bug.php?id=55001 2- It only works on …of thread_concurrency for Solaris is using thr_setconcurrency() function to give a hint to the operating system …
Comment: MySQL VIEW as performance troublemaker
February 9, 2008 By 57 Comments
… working with MySQL Views since release 5 was first made available. It took me and my team about 2 months of testing… to create an extra layer between PHP and MySQL (written in PHP). Hardcoding the complex queries in functions, with our own caching logic. This…
