…two triggers on that table. select trigger_name, event_object_table, Event_Manipulation from…Field_Id: 3 As you can see from the above, the updates were performed in a different…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… to have your queries do something like SELECT * FROM TBL WHERE hash=crc32(‘string’) AND string=’…have an index on the field that is used to join the two tables? A: The question …differing cardinality on a primary key. After running an analyze on a table with 11M rows I’ve seen cardinality range from…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…to examine the differences in size. …field is selected in the list of columns to show (click show/hide to change the columns) That the “public dns” field is selected… or two nodes. You should start two workers…”select count(*) from ontime_fact;” | ./run_query Array ( [count(*)] => 135125787 ) 1 rows …
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…my mind. Row Cache Yes, a row cache is … structures to speed up field access – all …Few configuration options There are two main reasons for configuration…from a normal select. The non-standard “FOR UPDATE†clause does cause a select…storage segment. The huge different from other storage engines …
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…rows you may want to store them as efficient way as possible. For MyISAM tables you could use BIT(1) fields…different query based on parameter (IS ” would not work) or you can use Null-Aware comparison operator: mysql> select count(*) from…
Post: Is it query which needs to be optimized ?
March 6, 2007 By 9 Comments
…field sort by another and then use LIMIT to output first few rows…rows to perform group by so for large number of rows you’ve simply got to use different…SELECT COUNT(*) FROM profiles where STATE_ID=12 and CITY_ID=234 and GENDER=’M’. If number of rows…_ROWS but it can often make query slower than two …
