*please* don't use reply-all on mailing-lists the list by definition distributes your message
Am 30.06.2014 13:14, schrieb Antonio Fernández Pérez: > Thanks for your reply. Theorically the fragmented tables not offer the best > performance to the InnoDB engine, > that's correct or not? practically it don't matter because the hot data should anways be in innodb_buffer_pool and so in memory and the fragmentation don't really matter as long it is not extremely you just can't have always unfragmented data because that would mean the must be space reserved left and right to fill growing data there how much space will you reserve and how will the holes impact performance if it comes to read data at startup anyways: a state of "no single fragmentation" is not possible and seeking for a solution because some tool displays data without any emotion is "a fool with a tool still is a fool"
signature.asc
Description: OpenPGP digital signature
