… we faced is that IPs are dynamic in EC2 so when an instance…NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB…55.55. The first thing to do is to update all the /etc/hosts files… file before the change to get the IP from which to expect the connection, you…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…from storage and only de-compress it on the client. Delayed Updates Delayed Updates is complement to delayed invalidation. In many applications you have updates…to Query Cache to make it cool again. The question is whenever anyone from “MySQL…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…have to match byte by byte for cache hit to happen. This means if you would place dynamic … – Queries are constantly being invalidated from query cache by table updates, this means number of queries …good idea to use query cache ? Third party application – You can’t change how it works with MySQL to …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…FlexCDC to update the snapshot to …following SQL is dynamically generated by …to read from the dictionary directly to determine the contents of the view. mysql…how you can combine both types of views together. The complete method examples show how to create a complete refresh view which reads from…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
…of query execution, sometimes being dynamic based on data. With EXPLAIN MySQL kind of simulates execution but … as MySQL has triggers which can make updates very different. Also there is no way to tell you how … to take number of rows estimated from each row in a join and multiply them to see how …
Post: MySQL should have dynamic durability settings
April 8, 2008 By 4 Comments
…updated in different transactions) have different durability requirements. For some of updates you really would hate to…how to commit transaction can be decided for each transaction separately in session context. What MySQL Could do to take it further is to…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…is also rather interesting how is sort file structured for building the indexes – does it uses dynamic or static… and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible to fix this problem… lot of “Gotches” while many of them come from MySQL limits at the time when Innodb was first …
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… problems (part MySQL related and part related to LAMP in general…to use but to point out serving dynamic content, serving in-memory static content and serving static content from… It is especially worth to note updating access time needs io … avoided. How far in the future you want expire to be…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…InfiniDB Version: 10 Row_format: Dynamic Rows: 2000 Avg_row_…: NULL Create_time: NULL Update_time: NULL Check_time:…how to get real size, and also explains what takes so much space. Queries First count start query SELECT count(*) FROM… sec Query Q4: mysql> SELECT Carrier, count(*) FROM ontime WHERE …
Post: Trying Archive Storage Engine
November 12, 2006 By 6 Comments
… it is great to try how much archive storage engine… Engine: MyISAM Version: 9 Row_format: Dynamic Rows: 8048913 Avg_row_length…to go and check size of on disk file: -rw-rw—- 1 mysql mysql… the table changed from 5 min to about 4 minutes,… something which needs no updates and no indexes, however …
