… working set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to minimize … really can keep it always busy. As drive gets busy requests have to wait to be scheduled. You … server, for example it is old data purge activity you may at least chop it, meaning do …
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… and gets two responses, with a response time of R for each request, and a wait time of W between the requests. If… the first request. Back to the question of, “what is a very busy host?” In my experience, if you are getting even… (around 30% when filtering only 4 out of hundreds of active clients). While this is lower than without the filter, it…
Post: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
… resulting in hundreds or even thousands concurrently active queries. The question is how common is …do not really run MySQL with high concurrency does it really matter how MySQL performs with high …might be unable to serve the inflow of requests getting higher and higher under water. Some systems …
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…about what features to include, or how they should get built; and we don’t encourage community contributions … send us email, and so forth. We notice these requests, and if they come up often enough and we…sum of the parts. When it comes to Sun/MySQL, we actively and openly talk to them about it, and…
Post: SimCity outages, traffic control and Thread Pool for MySQL
March 16, 2013 By 16 Comments
… throughput. Basically the more users who are coming, the less requests/sec the system is able to handle. The reason is…/12FUiYf , Activated on 7th around noon” While a similar plugin is available from Oracle by MySQL Enterprise subscription, you can get it and try it with Percona Server for MySQL right now for free…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
…the given command because you have active locked tables or an active transaction) – this is also I …MySQL runs out of connections or Apache out of children allowed to process request; So you can do following instead: mysql… data loaded to “rep” table you will get the copy of old table in “rep_old” …
Post: mysql-proxy, urgh performance and scalability ?
June 9, 2009 By 44 Comments
…, see lp:sysbench, and Percona is going to be active developer of this project and scripting benchmarks). I took …). MySQL per-request statistics: min: 1.31ms avg: 1.51ms max: 5.30ms approx. 95 percentile: 1.56ms Proxy+MySQL per-request … under sysbench load, so I was not able to get any results yet.
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…how much data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc – …50 drives you would need at least 50 outstanding requests all the time to fully utilize them. So … – you do not want your database box to swap actively – if it does your’re in trouble anyway …
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… systems are getting wider more than CPU cores get faster, though even single node does not take you that far. MySQL concept of… intensive activity. If result is not served from cache you will have many CPU seconds if not minutes used processing your request, but you get reply fast because hundreds and thousands of CPUs were…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… but does not get rid of it completely. In the new releases of MySQL (versions >= 5.5…mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table-name=sbtest_20m –max-time=900 –num-threads=8 –max-requests…that the server represents one that is in active use. The buffer pool was filled up …
