…’s new with the MySQL query cache? You may know that it still has the same fundamental architecture that it’s always… the fact that the query cache was configured far too large. This might have taken a lot longer to discover otherwise… InnoDB Architecture and Performance Optimization. These detailed presentations will give you the hands-on experience you need to take your MySQL understanding…
Post: ClickAider - Track Adsense Clicks and much more
July 9, 2007 By 17 Comments
… rather than page views means it can work for reasonably large sites, and we’re working on technologies which should allow… for all stats. Compared to SpyLOG we also significantly simplified architecture based on experience gained during the years and simply because… LAMP application at this point. We use Scale-Out MySQL architecture based on MySQL 5.1 with some partitioning and mostly Innodb storage…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL… with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This presentation will talk about architecture…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… applications if implemented well. It is too bad MySQL Users Conference only allowed 45 minutes for Storage …IO situation can be rather different. Looking at PBXT architecture there is small row pointer file which is … which may require a lot of IO for large data sizes. But you of course should take …
Comment: How Does Semisynchronous MySQL Replication Work?
January 31, 2012 By 24 Comments
…, Currently analyzing different existing solutions to secure our web architecture using 3 mysql production servers and read your article which I found… know people who put semi sync replication in production on large mysql databases and so don’t hesitate to contact us to… circular replication and haproxy load balancing queries in front of mysql servers) and others open source solutions (tungsten / galera), i’m…
Post: Last chance for a discount on Percona Live DC!
January 3, 2012 By Leave a Comment
… over a week, we’ll be running a Percona Live MySQL conference in the nation’s capital, in a beautiful modern…. Here’s what you’ll see: Technical talks on core MySQL topics such as replication, high availability, and performance tuning. Speakers… built large systems in and out of the cloud. We’ll have Peter Zaitsev, Theo Schlossnagle (OmniTI; author of Scalable Internet Architectures…
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
… This is also filed in MySQL bug tracker, but not fixed in upstream MySQL at the time of this …buffer cannot be more than 4GB even on 64bit architectures. With this bug fix, both the server option –… over 4GB on 64bit systems. For users with large MyISAM tables, this could be a great improvement …
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… though multiple fixes have been implemented in Percona Server and MySQL 5.5, there are still workloads in which case mutex… done, which well may be normal – if your workload has large portion of it being “critical section” where only one thread… you’re upgrading to Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of competing threads (such as…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## …alignment, not different MySQL configurations, I didn’t try out different MySQL versions or … should have really interesting effects. Large stripe on the other hand …
Page: Presentations
May 3, 2006 By
…MySQL/Innodb Architecture and Performance Optimization OpenSource Database Conference 2006, Frankfurt, Germany, November 2006 Very condenced 1h 15min presentation about Innodb Architecture…
