… not willing to let the conference die. Others talked about doing something, but Percona took the concrete steps of securing space… is MySQL-focused. The event is inclusive, with all vendors and competitors welcomed on an equal footing. The event balances community, business, and… integral part of Percona’s business, but it goes beyond pure business. We see an ongoing need for MySQL-focused, inclusive, balanced, technical…
Post: Announcing Percona Live MySQL Conference and Expo 2012
August 9, 2011 By 11 Comments
… O’Reilly MySQL conference has occupied the crossroads of open-source, MySQL, community, and business. Emphasis on business. We … not an option. This is a MySQL-focused conference with Percona’s name in the title, … speaker committee, are things we’ll be doing too. I was on that committee three times…
Post: Speaking at HighLoad conference, Moscow, Russia, Training and Hiring
September 30, 2011 By 2 Comments
… cool things happening in MySQL space recently and I would love to share those with you. I’m also doing a training session 5th of October, which will be in depth training session based on Percona’s Training for MySQL… On experience. If you would like to do business with Percona I will be available for business development and consulting meetings on Thursday and…
Post: Can having information public hurt consulting business ?
April 30, 2008 By 9 Comments
… new business publishing this information brings to us but think it also have significant negative effect because people find information on MySQL…’re doing insert in table with auto increment which uses table level auto increment locks unless you’re running MySQL 5.1 with…” To…. In this case surely having such instructions public can hurt business badly. In other cases value could be access to the…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… these scale, for single MySQL Server ? Please comment if you do. I believe we see more of applications busy from IOPs numbers, especially… external storage. 500MB/sec would be exceptional for traditional MySQL as MySQL optimizer with its nested loops joins does not favor sequential scans…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… expensive to solve. Start with the granularity of your data. What data do you need to make your business run? If… ways to do general-purpose work without aggregating (see the section below on technologies), but if you’re doing this with vanilla MySQL, you will need to aggregate your data. What you want to do is aggregate in ways…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… 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: 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…
