May 22, 2012

Comment: Pitfalls of converting to InnoDB

PHP 5.1.6, MySQL 5.0.24a default installs from Ubuntu 6.10, so pretty recent + standard. I’m using the PHP… it just fails miserably when PHP dies unexpectantly. Having to restarting apache is a pretty drastic measure…m assuming that’s standard (I haven’t tuned anything). So your script could loop for …

Post: Cache Performance Comparison

…and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare … (2Ghz AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached access memcache …results and how we can use them for MySQL Performance tuning ? Not surpising associative array cache performs the…

Comment: eWeek tests OpenSource stacks and .NET

… it :) Tuning of LAMP stack on Windows and Linux is at 95% same – installing PHP accelerator, using proper modules, configuring apache, MySQL Server configuration…” which is reasonably optimized was used on Windows while stock Apache+MySQL were used on Linux it could explain the difference. Speaking…

Comment: Are PHP persistent connections evil ?

… production environment to pool connections between 12 Apache Web servers and a handful of Oracle databases… Oracle (or MySQL) connections and strives to maintain that number continually. Then, your PHP app connects … smoothly does take a fair bit of tuning and careful management of your SQL Relay …