…I wrote about math of automatic failover today I‘ll share my thoughts about what makes MySQL failover … (SQL nodes for MySQL Cluster) in the same way as you work with web servers – any of …do a lot of dirty job internally does not mean the testing described in the previous article is not needed. On…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 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…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
…MySQL and the full application stack, and familiarity with your application and your data. I…on my.cnf. It is not the be-all and end-all of performance. Tuning your server settings has far less impact on…
Post: A piece of Sun/MySQL Marketing
February 27, 2008 By 7 Comments
…Server, Web Server are all different. This pretty much means you have no clue on what is the best on…MySQL and Web instances looks highly dubious to me…. at least this is not what you normally do for high performance Web apps which I…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
…MySQL can do” or “how many servers I need to handle 100.000 users” or “which hardware would be enough to handle my… what hardware you need for ecommerce web site with 100.000 visitors per day I still would … such as live advicing of items based on your previous purchase history etc. To illustrate it …
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…my experience, and you are likely to need…on the server during these times, and the disks keep responding in less than 2ms. I…I wrote on my own blog about the reasons for this and the wrench it throws into capacity planning). If we zoom in on…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…MySQL 3.23 and MySQL 4.0 team the small tight knit team was working on the server… in the Web world would be as happy with MySQL 4.1… density features I would mention MySQL 5.1 features. During my talks I often…do not need general “quality” or “being free from bugs” to run MySQL in production. MySQL…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…mysql vars and restart server, my configs are not applied, defautl mysql applied, and my.cnf are not modified. Why? Where are written this configs? – do i…i need to insert manually in my.cnf for best performance & low disk usage? – may i remove old_passwords=1 & big-tables? — Web Server…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I…mysql connection is used during execution of a request. If you are seeking to reduce the load on the database server… on, the session I needed to focus on was right at the top. And what do …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…- mysql, memcache, sphinx, web services etc. For web applications doing…on optimizing them. There are multiple ways to optimize something, my…a side note I should mention …needs attention. Though even for less complicated single MySQL server application there is often the question if it is MySQL server…
