…of different properties – Top web sites like Google, Yahoo, FaceBook have to have to provide online service to tens and hundreds of millions of…MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL… presented Storage Engines targeting…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… – unlike MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL – it…. Also note the result set difference – Sphinx finds no rows and creates no groups while MySQL reports NULL group as a result…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… is based on XtraDB. That means Galera supports the XtraDB storage engine. Support for multi-threaded slaves. Using custom scripts for node… masters in different data centers. This provides a HA solution for MySQL setups in the Cloud. E.g. with current state of MySQL EC2… to join me in testing MySQL/Galera 0.8, binaries are available from Launchpad. The downside of MySQL/Galera is that it is…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
Part of the InnoDB duties, being an MVCC-implementing storage engine, is to get rid of–purge–the old versions of the records as they become obsolete. In MySQL 5.1… receive a lot of tuning in the future. In fact, as of the time of this writing, the code is already different in the…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
…that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple MySQL storage engines at various data scales. What…create two different dimensions, product and category, but performance tends to decrease as the number of dimensions increases. The difference …
Post: New Presentations published (Meetup and Highload)
November 7, 2008 By 1 Comment
…and New Features (Russian), Scaling MySQL-powered Web Sites by Sharding and Replication (Russian), Wonderful World of MySQL Storage Engines (Russian). Now some feedback …still do consulting as a business. For MySQL Users Conference I took the different approach this year having almost no general …
Post: Reality of Innodb Caching
April 21, 2011 By 8 Comments
… “sbtest” with 10mil rows with data file of 2247098368 which gives us 224 bytes of gross storage per row, including all overhead etc… fit only somewhere between 6400 and 12800 different rows which is about 1/50 of “projected size”. This number is very close… database than you need. I’m wondering if any over storage engine can show better results in such benchmark. Falcon with plans…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
…. There is no difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically…? Because providing quality server builds is a substantial engineering effort that requires a lot of expertise to do right, and Percona has…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… it can find evidence of problems in the server as well as the storage engine. For example, a pile-up of connections all trying…-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. Replicas have different…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… types of SELECTs can be done without locking. Morgan notes: Indexes not using MVCC is one of the main differences in the Falcon storage engine… a developer the most. MySQL supports a “pluggable storage engine API”, but it seems that not all the storage engine vendors are able to keep…
