… compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings… or similar “older” systems if you wouldn’t do anything with respect to IO alignment. 2. Misalignment on…_mb_s wr_mrg wr_cnc wr_rt busy in_prg {540} dm-0 447.1 34…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_…CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 800 BUSY_TIME: 775 CPU_TIME: 49 BYTES_RECEIVED: 21847267…, power etc). Such system will be able to do 2592000000 IOPS per month and (using our …
Post: MySQL and Sun - Oportunity for smaller companies ?
March 26, 2008 By 10 Comments
… while MySQL could have these done for thousands or tens of thousands in some cases. As MySQL merge with Sun progresses I do not… also be faster to fix your MySQL issues – at Percona we do a lot of work with performance analyzes and Scaling. Proven Scaling… fish in MySQL nets, it is also great news for us, smaller service companies, enjoying dealing with smaller customers and having business models…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…IO bound accessess we might be better of doing full table scan even if only few … with queries examining only few rows it is less of the problem. Data retrieval, search, DSS, business…working with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL …
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications now than 12 years… and Platform support do you think is adequate for MySQL ? Oracle seems to have extended support for MySQL versions rather significantly with Extended support… sense to support RHEL4 with MySQL 5.1 but support with MySQL 5.5 is not needed as people doing major MySQL upgrade usually would have…
Post: Living with backups
November 6, 2008 By 28 Comments
…-can-eat bar. With a busy database server it may turn out that running a simple copy operation from MySQL data directory will… for example rsync has the possibility to do that with –bwlimit=KBPS option. The problem with rsync is that it needs to build…, other MySQL data files do not comply with this requirement. The trick could be used here perhaps to read the file with O_DIRECT…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… pleased with momentum of this event seeing great discussions between attendees, attendees and sponsors as well as many of us doing business around MySQL… their solution to scale MySQL with automatic sharding, caching as well as get insights in application behavior and performance with real time analytics… MySQL 5.6 but as Robert Hodges puts it , “it works with MySQL 5.0″. Robert shared his vision for the place of MySQL…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… MySQL would not have multiple storage engine interface it would not allow people to do various very cool stuff. And I agree with… and doing other cool stuff. Some of this cool stuff can be buggy but their applications are often not very business critical… or Percona Server, they often do not attend MySQL Conference and may not even know Oracle owns MySQL these days. This group is…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…_CONNECTIONS: 25 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 464 BUSY_TIME: 96 CPU_TIME: 19 BYTES_RECEIVED: …many audit capabilities in MySQL Community so logging all events and then filter them with custom-made … information about what a particular user is doing. All options can be combined to meet …
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
… of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we got too busy with serving… remote position which is open for candidate worldwide. We also do not require perfect Spoken English for this position, though candidate…
