… query performance magic bullet, unfortunately, I haven’t. The problem with the…. Use what you need Both Memcached and the MySQL query cache are limited…it, then do so. This avoids the CPU usage on your web server to create … hard problem to solve. My latest post on using Flexviews addresses this …
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…web technologies. So how do the hosting providers manage to host hundreds of users on single server with single MySQL server… queries. In my test I got OOM though…do_page_fault+0x4cb/0×830 [] error_exit+0×0/0×84 Do I need any particular privileges for this to happen ? Not really – you do not even need…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…MySQL the same date as release would hit the web. Since that time I matured and so did MySQL ecosystem. MySQL…I would still estimate more people running on MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL…MySQL on now ? Do we have any RHEL4 still in production ? RHEL3 ? I need…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…I don’t like multi-lines output so I wrote a small filter script to on one line the parameters I need…MySQL version in the Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…I helped dealing with performance problems (part MySQL related and part related to LAMP in … 10 different image servers. Keep Alive In my previous post I wrote you often do not need keep alive …on web server side and which can be avoided. How far in the future you want expire to be… it depends on…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…need to design highly available MySQL powered system… how do you approach that ? Too often I see the question is approached by focusing on… need redundant power supplies. In my…do not share hardware but share the data center. You may have “spares” to provide extra on demand capacity for web servers…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… to do that now. So here is my list 1. Be Pluggable Unlike many OpenSource projects MySQL … as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but …. I‘m not sure if MySQL got back to spend significant resources on taking care of Web guys needs …
Post: How Web Services world affect LAMP Stack
May 22, 2006 By 1 Comment
… another web application: More workers required. In my post yesterday I mentioned you might need only few “workers” – actively working web server processes, if you do not… have limits on how frequently you can call Web Services. So you might want to cache data on Disk – in files or MySQL tables…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…MySQL appeared on the market many web applications were simple and often not using database at all. MySQL…servers. For others it becomes space and power constraint. It is also worth to mention Web vs Open Source component here. I…need is some kind of breed between Ruby on…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
…is happening you need more info. You my notice in …netstat command and filtering on the PID we …MySQL connections (to the same host, which if usually bad idea) and connection to some external web server. You can use strace -p to see what host is doing, it often gives a clue. In this case I…
