…’ve encounterd completely weird results with mysql on an 8cpu server – it performed 3!! 
times slower than on the same 4cpu server: FreeBSD-6.2/7.0… with apache benchmark on a web page that does some 20 selects (one is select count(*) as count from … where … – the slowest one), and…
Comment: PBXT benchmarks
November 29, 2007 By 14 Comments
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…special “database” interfaces which run on top of MySQL or other databases. Other …MySQL but why could not one develop smaller and lighter top part ? The same way as you can run PHP as part of Apache but you can hook it up to bunch of other web servers…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…the time, the API node, the mysqld process, sits on the same node as the application server (apache, tomcat, etc). Losing an API node is the same as losing an application server…
Post: Web Site Optimization: FrontEnd and BackEnd
June 26, 2008 By 12 Comments
…the problems in this are going beyond Apache, PHP, Memcache and MySQL. A lot of talks on this conference was focusing on what is called “FrontEnd”. The meaning of Frontend is not the frontend web server…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is …and use them same as single MySQL server with improved performance and high availability. Of course there is MySQL… same as with MySQL Replication – the reason it is fast and has low performance overhead on the master…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…the trouble establishing number of connections you need. The problem is there can be only so many connections active between Host “Apache” and Host “MySQL… on your MySQL server…MySQL should support command which resets connection and guarantees it will be the same as freshly created connection, so the…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark… to MySQL Server, by measuring just the time it takes cache to return the data. In the…MySQL 4.1 and PHP 5.0. For memcached access memcache extension from pecl was used. All applications were running on same…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
…to 120 load average, mysql master restart needed and apache servers as well. At first I did standard tuning and query tuning but it seemed…all the parameters I could think of, and mysql processes showed in issue periods multiple copies of the same query, sometimes with also same parameters, and on OS…
Comment: MySQL Sizing questions
February 9, 2012 By 4 Comments
…Apache Server. 2 Database server with the same configuration, but active-pasive controlled by load balancing using HT proxy. MySQL installed. 2 load balancing servers…
Comment: Why MySQL could be slow with large tables ?
August 20, 2006 By 141 Comments
… dealing with the same issue with a message system. At the moment I have one table (myisam/mysql4.1) for users inbox and one…) In near future I will have the Apache on a dedicated machine and the Mysql Server too (and the next step will be a Master/Slave server setup for the database).
