mySQL/InnoDB defragging
- Started
- Last post
- 5 Responses
- fitsum
how often do you have to defrag your tables?whether you work on small or enterprise scale projects.
THis is one of topics I've overlooked and trying to dot i's and cross t's
- nospacebar0
It's the index that needs updating after you modify the db a lot.
It should update the index after modification, so I only optimize + analyze if I know there's been a lot of transactions that heavily modified the data.
- ldww0
on a large scale project i did a while ago, it did optimize, analyze nightly
- fitsum0
tell what you mean by 'large scale'. Many records in all? or many tables...?
thanks
- ldww0
large scale, meaning not just small websites.
ala ecommerce.
it would check out the users table, cart table and items table (each cart has multiple items).
- fitsum0
and also high volume of transaction etc.right on
thanks for the feedback