… not focusing on when to use the serialized data in tables and when not to use them. If you are of… combination. One big advantage is if you add or remove a setting, you don’t have to add/remove a column from your database… separate database table with one other column indexed to map to another table. For example, have a table of accounts, make another table called account…
Post: Small things are better
October 8, 2006 By 15 Comments
… you need to add extra column to 500GB Innodb table. It will probably take long hours or even days for ALTER TABLE to complete… for such small tables. Not to mention splitting 500 tables to several servers will likely be easy than splitting one big one. There… at 256 groups of tables. Current data size is small enough so even single table would not be big problem but it is…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… sized boxes to 5% of memory size on the big boxes, though it can be even less than that…. amount of tables). I could tell you some numbers, for example sum up all your global buffers plus add 1MB … swapping is not happening ie your VMSTAT “si/so” columns are zero on Linux. Couple of swaps per minute …
Comment: How fast can you sort data with MySQL ?
September 24, 2007 By 26 Comments
… INNODB, which is going to be faster? a) Add an index on column to be sorted and select by that index b… sort using unix sort then re-import c) Select using table-scan and sort as per your example d) alter to… doing (a) but I’m wondering if this is a big waste of time.
