… if a) all the data were in InnoDB, and b) InnoDB’s data didn’t have to be synchronized with the .frm files (and Drizzle has gotten rid of the .frm files, hooray), and c) privileges and other changes to the… could be used for read queries. This can be done, of course. It’s just a matter of how hard it is. It…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…is lying on this test system as default sync_frm option is used. With default table_cache=…sec which is a great speed. We can note significant writes to the disk during this read-only benchmark. Why…of file descriptors (set by innodb_open_files) As the time allows I should test if Heikki knows how to…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… must be set correctly. I’ve seen a lot of clients which came through extreme … this in. The next step would be to decide How Much Memory do you need for other…frm file, binary logs, or relay logs, Innodb Transactional Logs also like to be cached otherwise OS will need to do reads to serve writes to…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
…approach: When you execute a query, it is …to go on all nodes. You have several duplicates of data. For 3 nodes – 3 duplicates This basically defines how…to another (SST applies FLUSH TABLES WITH READ LOCK command). Xtrabackup SST does not require READ LOCK for full time, only for syncing .frm files…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…to go and check size of on disk file…_061111.frm Can…a bit better than myisampack. I also checked how much table would take if compressed with bzip2 – it took a while to…to know which buffer size Archive storage engine using for reads – I could not find it as difference could be due to larger read…
