…not always works – we’ve seen performance issues with large query_cache_size also sort_buffer_size and … was so great because all 100.000 tables data (first block of index) was placed close by … Interesting enough Innodb has a very similar task of managing its own cache of file descriptors (set by …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… do not really care about how these 4GB will be managed, to keep it the most efficient. Should I specify min… this Zero administration thing and I would like database to manage things for me but it should first prove it can… cluster data by Primary Key or any other key. This is good for some applications bad for others. There is large amount…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… is somewhat typical for Enterprise managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations… minimize recovery time significantly by switching to that backup – no data copy will be required which can be significant concern to…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… will not really change until MySQL Server implements Global Resource Management as otherwise you can’t really control how much resources… each of them using mysql_stmt_send_long_data call – Server buffers such data until you have executed prepared statement. Innodb Table… internal table cache (data dictionary) so by creating and accessing large amount of Innodb tables you can allocate large amount of memory on…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… application do not need absolutely up to date data, something which is couple of seconds or sometimes … I believe it can be done for rather large set of applications. Many applications in MySQL … doing or if delayed invalidation is enough. Improve Manageability What is in the MySQL Query Cache ? How …
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… to start because of an fsck on a large ext3 partition. Then, a startup script becomes a …the clustering and communication layer, Heartbeat and the resources manager, Pacemaker. A key new features that has been… only one of the physical host where the data nodes are located comes up, the cluster will …
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
… is likely to be expensive If the view accesses large quantities of data, then the computation is likely expensive. Views containing grouping… create the materialized views which Flexviews manages. *ELT – extract, load and transform, a variant of the data integration Extract-Transform-Load process…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…IO capacity or high in memory fit. For large number of applications optimizing IO performance will …have to consider a lot of topics – security, manageability, performance. I tend to advice different things … to last committed transaction in case your data RAID volume was trashed. Regarding SWAP – I …
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… not to mention understanding all ups and downs of database management system. This sounds nice in theory but there are not… expect solutions to be developed which operate on more flexible data structures, handle distributed semantics of web better and are expressive… many of data store applications, especially for specific needs when for example large amounts of data need to be analyzed which requires large amount…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… least increase memory consumptions as deallocating of these large buffers will not instantly return data to the OS. Plus I’m not… they are forced to deal with very large blocks. The second possibility is to use large pages. These already can be used… could be used for other large allocations. Finally this is yet another reasons internal resource allocation manager makes sense. If you would…
