MySQL Users Conference 2008 has number of Storage Engines presented which … key lookups and MySQL Cluster promises good performance and scalability. But if at the same time you have queries with complex Joins which you…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… support any complex constructs like subqueries or views so you rarely would scratch your head thinking what is this query you peer…. Someone could be great MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have no idea how… area MySQL Cluster, which was always best isolated of MySQL source leads the pack – there are bunch of interfaces to talk to MySQL cluster as…
Comment: Announcement of Percona XtraDB Cluster (alpha release)
January 13, 2012 By 30 Comments
… flexibility as you can add MySQL Servers and data nodes independently but adds complexity 2) Data partitioning; MySQL Cluster partitions the data automatically between…’s great for scale-out (as Vadim mentioned) as write queries scale as well (with more than 2 data nodes). This…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… bit longer. This is common in MySQL servers I work with when …response time (which will usually be clustered tightly, given that this is an … could also classify queries together and analyze the classes of queries, rather than lumping… we can learn a lot of complex and useful things about a system….
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test;…from simple Innodb Table Corruption. In more complex cases you may need to use higher…if data dictionary or “root page” for clustered index is corrupted this method will not …
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…cluster of Turing computers as a specialized purpose SIMD computer with respect to your function. The SQL interface to Shard-Query…another and let’s solve all the complex problems in the world together in … run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…This can be a lot of difference. The complex situations which happen with databases such as … problems are self imposed. Developer added bad query to the application and the box is … availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and DRBD as …
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… ether. PEAR is slow as well as other complex conectors. I have not yet tested PDO but … data clustering so table becomes hot very quickly due to data locality once this user starts his queries. … error. On other hand in MySQL you might be better of using several queries than doing complicated ones. …
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… a very distinguished engineer who’s been building complex systems since before I was born. Two, this…about using MySQL to find the top N most important rows per group of rows, distributed across a cluster…tables and filesorts and multiple queries and all sorts of things in MySQL — and that’s just for…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…very significant cost in performance, operational and development complexity. Let me touch just on the few …such as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed …is not enough as MySQL allows you using multiple storage engines in the query you need to …
