June 19, 2013

Post: Speedup your LAMP stack with LigHTTPD

… to stick to at least for dynamic content served by PHP or ModPerl. With “client per process” you end up having… does not eliminate all problems. Use FastCGI instead of mod_php etc. Apache itself without any programming language modules is light… one – I simply did not test too much of other alternatives as it already worked well. There are few features which…

Comment: Edge-case behavior of INSERT...ODKU

… the client. It’s much easier to scale a [perl|php|ruby|bash] script and run it on N different machines… to-do list] Not sure how I feel about your alternative implementation of I-ODKU. Have to think about that one…

Comment: Be careful rotating MySQL logs

… becomes available later it may help suggest there’s an alternative plan we can use as well. http://blesseddlo.wordpress.com…/mysql-logs-filling-up-var/ ( –> http://dev.gigigo.tw/index.php?option=com_content&view=article&id=341&Itemid=330) – bish

Comment: Apache PHP MySQL and Runaway Scripts

Thanks Rasmus, But what is about using this approach for PHP-FastCGI, Which is exactly environment which I found it working… if we stick to apache what do you propose as alternative ? To have some watchdog script checking running scripts and killing…

Post: Using MMM to ALTER huge tables

… course one can just enter commands from cli, execute some php/python/ruby script or anything else. Most importantly – this must…, this could be a better way to achieve the same: Alternative 6. Clone db1 from db2 On db1 execute: $ mmm_clone…

Comment: Where to get recent MySQL version ?

… install MySQL for free as they can with Apache and PHP, therefore will not be able to develop with and gain… will of course switch to PostgreSQL as the only viable alternative. The software which they develop will therefore be PosgreSQL-only…

Comment: ORDER BY ... LIMIT Performance Optimization

… rows you could try this for a faster alternative to RAND() (example in PHP): $var = row(“SELECT COUNT(id) FROM mytable”); $var…

Page: Consulting for MySQL

… of MySQL. We’re ready to work with you on PHP code optimization, Server Side caching, load balancing and other issues… Text Search indexing or help you with selecting and customizing alternative Open Source full text source solution which will match your…

Page: Presentations

…Sphinx Full Text Search solution and comparing it to the alternatives. Slides by Andrew Aksenoff, Russian Language. Download MySQL Performance Optimization…have too much meat about MySQL Performance. Download MySQL and PHP for Web Applications Open Source Revolution 2002, Stockholm, Sweden …