…adding to a smaller index, and a smaller ‘chunk‘ od table. Depending on how often you …Mysql can fire off one thread per partition (at least I have seen this happen in a MyIsam environment on similar sized… than deleting a few hundred thousand rows… for example, if you need to delete. However, …
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… MySQL you might need to deal with RAID recovery every…log was backed up. I wanted for a chance to write instructions for recovery for long time and finally I …5 Failed Devices : 0 Spare Devices : 1 Layout : left-symmetric Chunk Size : 64K Name : 001F33EABA01:2 UUID : 01a26106:50b297a8:1d542f0a:…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… that we are allocating another chunk that is in proportion to the setting of innodb_buffer_pool_size for the blocks array. The exact proportions will probably vary from version to version, but roughly about 1 G for every 25 G of the buffer pool. This can become significant in the proper innodb_buffer_pool_size estimations…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… step forward in our plans to create excellent free tools for MySQL administrators. There is one really big thing to talk about…-table-checksum. You know how you have to choose a chunk size, and set up offsets and modulos and set sleep times… is growing quickly because then there will be a huge chunk of new rows at the end that will get put…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… more for MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL… allocated as single chunk at once others, for example tmp_table_size is rather maximum amount of memory MySQL will allocate for this operation. Note… are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL by various parties. I do…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…size (can be changed via innodb_ibuf_max_size option) which can be significant size for…mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | page_no | max_size | curr_size… such processes in chunks, updating/deleting …
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… controller for that same operation. In practice stripes by default are bigger in size – I would often see see 64KB (mdadm default chunk size) or 128KB stripe unit size so in these cases… use appropriate Volume Group Physical Extent Size for vgcreate – I think default 4MB should be good enough for most cases, when changing however…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to save work. Avoid operations that update huge chunks of aggregated data at once. Among other … will make the indexes less than half the size. In real life this technique often makes the…than MySQL is, especially for more complex queries. Percona is not tied to MySQL, although we’re most famous for…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
…sort by date). The reported index size on disk is including mysqls own columndefinitions etc. What would …was to split up the bitvectors into chunks and compress each chunk using LZF. Regarding the 150k …specially for the case when I want the result to be top 200 sorted by date. For mysql fulltext…
Comment: Full text search for all MySQL Storage Engines
June 27, 2006 By 37 Comments
… direct plugin for mysql (I assume this means that the sphinx index can be created directly from within mysql just as with mysql own…. Each vector is also splitted in 100kbit chunks in order to keep the sizes down to a minimum aswell as having the… Also, does the implementation of sphinx as plugin for mysql 5.1 mean that mysqls own fulltext engine will/might be replaced shortly…
