… queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This… loader (loader.php) which can be used to either split a data into multiple files (for …splitting/loading process will be described in another post. Complex queries Shard-Query was tested with…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… algorithm computes changes in multiple transactions. After each transaction…customer_name, sale_when; $ php convert.php demo < sales.sql CALL ... discuss others in future blog posts. Enable the view … too high +——————+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… distribute splitting and/or loading among multiple nodes as well. Note that …from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘…(adjust to your number of nodes) php genconfig 20 > shards.ini Running …the numbers in my next blog post. I will compare performance of …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…old post but I just felt I had to speak my mind on this one… > 1. Using mysql_* … archiving great performance by doing so. > Using multiple tables gives some very important benefits – your data … however start > to crawl. > So developing you PHP applications use test database with reasonable > amount …
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… with performance problems (part MySQL related and part related to LAMP in…servers. Keep Alive In my previous post I wrote you often do not… Serving file by simply reading from PHP or any other heavy programming language…Thumbnail size In many cases you need multiple sizes of thumbnails, such as very…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… you need to. It may include cookie data, post data, logged in user information etc. But the… we could spend a lot of time optimizing PHP code but because it takes only 10% of… applications using mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in these cases you often can…
