…how it uses MySQL to identify potential causes. Is it working with large blobs ? Using…to see how many prepared statements are allocated on server and Com_stmt_send_long_data to see whenever sending long data feature is used…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…used then, after the selected rows are read from table1, the values of indexed columns that will be used to perform a lookup on table2 are…many point index lookups to one or more index range lookups. This means MySQL can employ many…to know is that, just increasing the join_buffer_size is not going to…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
…how MySQL‘s Transactions work with DDL, In particular ALTER TABLE. When ALTER TABLE is Performed in many…know the potential cause for it. What are potential solutions for this problem ? you can use…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… to measure the ad’s value? Is it enough to know how many …rows are stored in. That lets you choose which rows are stored close to each other, which is very beneficial in many…use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…How many “fragmented” pages do we have in the index with current compression settings. The same utility could be used to…know…are for MySQL 4.0 at this point but we hope to port some of them to MySQL 5.0+ Heikki also mentioned there are…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…to know right now is that there are two significant differences between the methods. A view which uses…rows which have changed since the view was either created, or last refeshed. The incremental method is somewhat conceptually similar to using mysql…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…with an overview of how to install and run FlexCDC…many commercial databases but until recently this type of software was not available for MySQL. Change Data Capture can be used to… file so you know what process to HUP. $ ./consumer_safe.sh …rows in set (0.00 sec) As you can see, there are three rows…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…MySQL has installations with many billions of rows…to database. Some people would also remember if indexes are helpful or not depends on index selectivity – how large proportion of rows matches to…are used to compose the complex object which was previously normalized to…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…how to make MySQL replication reliable, part of which is to …row-based replication in MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on MySQL…are you sure this isn’t safe?” They’ll propose all sorts of ways to mitigate the danger, and I’ve heard many…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…how to get it. Most distributed engines work with rows. They break the queries up into the lowest level sets possible (rows…are used to compute work. Computation is massively parallel. Shard-Query simply waits for all the queries to…MySQL storage nodes are supported. Amdahl’s law applies to…
