One thing I noticed during the observation was that there were roughly 2,000 new connections to MySQL per second during peak times. This is a high number by any account. When a new connection to MySQL is made, it can go into the back_log, which effectively serves as a queue for new connections on operating [...]
About Ryan Lowe
Ryan is a Principal Consultant and team manager at Percona. He has experience with many database technologies in industries such as health care, telecommunications, and social networking.
Percona Training In Sydney
August 30, 2011 By Leave a Comment
For those that missed it – we added training in Sydney to our website. We’ve booked a training venue near the Museum of Contemporary Art (200 George Street). Some minor logistical changes: The start time will now be 9am to 5pm We look forward to seeing you there!
What’s up with HandlerSocket?
March 28, 2011 By 43 Comments
I’ve presented at two different venues about HandlerSocket recently and the number one question that always arises is: Why hasn’t HandlerSocket become more popular than it is? Considering how fast and awesome HandlerSocket is, it’s not seeing as rapid adoption as some might expect. I theorize that there are five reasons for this:
Where does HandlerSocket really save you time?
March 16, 2011 By Leave a Comment
HandlerSocket has really generated a lot of interest because of the dual promises of ease-of-use and blazing-fast performance. The performance comes from eliminating CPU consumption. Akira Higuchi’s HandlerSocket presentation from a couple of months back had some really good profile results for libmysql versus libhsclient (starting at slide 15). Somebody in the audience at Percona [...]
Upcoming Webinar on HandlerSocket
March 14, 2011 By Leave a Comment
On March 29th, I’ll be giving a webinar whose title is “Understanding HandlerSocket – A NoSQL PlugIn For MySQLâ€. This is a continuation and extension of the talk I gave during the Percona Live Event in San Francisco back in February. We’ll ask, and answer, the following questions: What is HandlerSocket? Where does HandlerSocket fit [...]
Percona Welcomes Sasha Pachev
December 30, 2010 By Leave a Comment
Percona is pleased to officially (and belatedly) welcome Sasha Pachev to our team of consultants. Before joining Percona, Sasha worked as an independent MySQL consultant. Sasha was the original implementer and maintainer of MySQL replication from 3.23 to 4.02. He is also the author of MySQL Enterprise Solutions and Understanding MySQL Internals. Sasha, a big [...]
Percona Welcomes Justin Swanhart
May 26, 2010 By 2 Comments
Percona is pleased to officially welcome Justin Swanhart to our team of consultants. Before joining Percona, Justin worked as a MySQL DBA at Gazillion, Yahoo, and Kickfire. Justin has become a regular contributor here on the MySQL Performance Blog as well as being an active blogger at http://swanhart.livejournal.com/. He is very active in the community, [...]
Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a queue when it tries to enter InnoDB if the number of threads has already reached the concurrency limit. When a thread [...]
Redis Benchmarks on FusionIO (Round 1)
December 10, 2009 By 7 Comments
Peter took a look at Redis some time ago; and now, with the impending 1.2 release and a slew of new features, I thought it time to look again.
Videos from the 2009 Percona Performance Conference now available on PerconaTV
October 12, 2009 By Leave a Comment
Videos from the 2009 Percona Performance Conference are now available on www.percona.tv. Let us know which you like best so we can have some ideas for the 2010 conference!
