June 18, 2013

Post: Three ways to know when a MySQL slave is about to start lagging

October 8, 2008 By 8 Comments

…_STATISTICS WHERE USER=’#mysql_system#’\G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 2 CONNECTED_TIME: 46188 BUSY_TIME: 719 ROWS_FETCHED… BUSY_TIME to one-half the CONNECTED_TIME (because there are two replication threads on the slave) to see how much of the time…

Filed Under: Insight for DBAs Tagged With: ,

Post: How Can Percona MySQL Server Development Services Help ?

January 28, 2013 By 3 Comments

… custom MySQL server development can help your business be more successful with MySQL. Here are some ways: Bugs – There are Bugs in MySQL, Percona… us to implement the extra features from MySQL Enterprise Edition you need for your business rather than suffer from proprietary license lock… you’re using. Other times you need a custom build with special compile time settings. Using Percona MySQL Server Development Services to do…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: MySQL Connection Timeouts

April 19, 2011 By 4 Comments

Sometimes on very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed in your application you will see… case by running netstat -s and finding something like: 38409 times the listen queue of a socket overflowed 38409 SYNs to…

Filed Under: Insight for DBAs, MySQL

Post: MySQL extensions for hosting

April 24, 2008 By 11 Comments

… outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected_time: 20 Busy_time: 1… in MySQL usage Personally I would see a few more things implemented. A few examples to mention: per-user CPU time usage…

Filed Under: Percona Software Tagged With:

Post: Percona's "Developer Training for MySQL" is now available via Live Virtual Training

July 30, 2012 By Leave a Comment

… busy professionals. We set out to develop a training solution that balances the time to deliver the content with the amount of time… 5-days for the live virtual sessions. This is the time when the Percona instructor delivers the lecture, shows examples, and… in one of the LVT sessions for Developer Training for MySQL and save over 35%. The sessions we have scheduled are…

Filed Under: Developer Training, Events and Announcements, Insight for Developers, MySQL, Training

Post: MySQL Life Cycle. Your Feedback is needed.

November 18, 2011 By 6 Comments

… running MySQL from early beta (if not alpha) and update MySQL the same date as release would hit the web. Since that time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications now than…

Filed Under: MySQL, Percona Software

Post: Percona Live MySQL Conference & Expo Was A Great Event

April 17, 2012 By 2 Comments

… of vintage Legos and bean-bag chairs that stayed busy all the time. And I saw a lot of people winning radio… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…

Filed Under: Events and Announcements, MySQL

Post: Announcing Percona Live MySQL London

June 27, 2012 By 6 Comments

…great opportunity to share your MySQL knowledge with the MySQL community? Here is your chance. Percona … Utilizing Hardware New Features Best Practices for Businesses Replication High Availability Strategies Each session is … the type where attendees have a hard time deciding which room to be in, and …

Filed Under: Events and Announcements, MySQL

Post: Estimating Replication Capacity

July 20, 2010 By 4 Comments

… where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 446 BUSY_TIME: 74 CPU_TIME: 0 BYTES….00 sec) In this case CONNECTED_TIME is 446 second, out of this replication thread was busy (BUSY_TIME) 74 seconds which means replication…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…, MyISAM, with MySQL 5.5, on the SEO data set: mysql: SELECT id, title, MATCH(title, body) AGAINST (‘arizona business records’ IN NATURAL… against InnoDB on 5.6.10: mysql: SELECT id, title, MATCH(title, body) AGAINST (‘arizona business records’ IN NATURAL LANGUAGE MODE) AS… “James”, and the word “Peterson” is listed in there several times, but “Arizona” is not present at all, whereas the record…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts
Newer Posts »