… not expect it to beat MySQLi in speed. It is however bad idea to use mysql_ functions directly as well – I would… by people with traditional database background. Things are different with MySQL. There are many successful applications, using tens of thousands of… growth it will however start to crawl. So developing you PHP applications use test database with reasonable amount of data in…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1… for this server configuration. Going to 10000 tables however insert speed dropped 20 times. This could be because ext3 does not… 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… home test box (2Ghz AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached access memcache extension from pecl… baselines for comparison. First is speed of PHP Associative array. This is to show kind of peak speed possible at all. Furthermore this… used, but if Unix Socket is used to connect to MySQL MySQL Query Cache will be faster. The explanation for this is…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…helped dealing with performance problems (part MySQL related and part related to LAMP in general… enforced. Serving file by simply reading from PHP or any other heavy programming language and… bit of difference especially on slower connection speeds. Forgetting to set expire Static content rarely …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… lot of time optimizing PHP code but because it takes only 10% of response time in average even speeding it up 10… not the biggest part yet but if we’d speed up Sphinx and MySQL dramatically we would have to go and look… for complex applications using mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in these cases you often can’t…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id… is simple test, I do crash mysql during in-memory tpcc-mysql benchmark with 16 running threads. MySQL params are: innodb_buffer_pool… it: http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/revision/86 So your comments about patch is welcome…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… not > expect it to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly as well – I would… by people with traditional database background. > Things are different with MySQL. Good design will help dictate how many tables are required… growth it will however start > to crawl. > So developing you PHP applications use test database with reasonable > amount of data in…
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
…. The release includes following new features: MySQL 5.1.37 as a base release speed hack for buf_flush_insert_sorted_into_flush_list controlled by the new variable innodb_fast_recovery Fixed bugs: MySQL…€ This fixes also http://bugs.mysql.com/bug.php?id=45749 and http://bugs.mysql.com/bug.php?id=42101 The builds for RedHat4…
Post: Web Site Optimization: FrontEnd and BackEnd
June 26, 2008 By 12 Comments
… see the problems in this are going beyond Apache, PHP, Memcache and MySQL. A lot of talks on this conference was focusing…% time running PHP code and only 10% fetching data from MySQL database it does not make sense to focus on MySQL optimization. If… which he kindly signed for me to get up to speed with front end optimization.
Page: Presentations
May 3, 2006 By
…speed up various things in MySQL as well as solve other performance related problems. Download Innodb Performance Optimization MySQL…
