…in the database. Instead, pre-aggregate. Suppose your data is coming from some Apache log …t waste resources. Another benefit of this is the chance to parallelize. As you know, MySQL doesn’… Easy On Replication Building aggregated tables is hard work for the database server. If you do it on …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…Apache and network config, etc, and I don’t see anything wrong there. So at this point, it looks like MySQL… on the server as a whole, and now I’m ready to see what’s up with the database. … performance profile and workload of a server, so it’s often worth another iteration, and sometimes even more …
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…MySQL replaced in its space any time soon ? I do not think so. I do not think we need yet another SQL database…Apache but you can hook it up to bunch of other web servers as well, such as lighttpd. In fact in this area MySQL Cluster, which was always best isolated of MySQL…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
…way to measure response times on a server such as a database, memcached, Apache, and so on. You can use … For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a … future, packages in the Percona repositories will provide another means for rapid installation via yum and apt…
Comment: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… in this post or perhaps in another) about a question I get quite… for MySQL) and my answer has been the following (based on my understanding of Apache):…MySQL is relatively low compared to other databases, I usually recommend not using persistent connections with Apache web servers so that database…
