Hope you stopped the servers before doing that! It's really NOT something you want to do with a databse that's in use. Doing it automatically has some potential pitfalls too. http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043
| LinHES Forums http://forum.linhes.org/ |
|
| optimize sql database http://forum.linhes.org/viewtopic.php?f=6&t=6430 |
Page 1 of 1 |
| Author: | maaltan2 [ Thu Oct 13, 2005 7:51 pm ] |
| Post subject: | optimize sql database |
I know this is probably obvious, but I optimized the mythconverg database. This appears to have given me a big performance boost and a dramatic reduction is disk space. By optimizing i mean cleaning the indexes and getting rid of the deleted fields, not re-normalizing the tables. I did this using the command "myisamchk -r /path/to/mythconverg/*.MYI" Before the command it would take 1-2 seconds to change entries in "browse mode" It is back to being almost instantanious. Also the database has gone from about 80MB to 37MB. I performed a backup before issuing this command though. I was wondering if this command would be safe enough to script on a monthly or so basis? Also, how would one defragment the filesystems in linux. and script this to happen periodically. Thanks, |
|
| Author: | tjc [ Thu Oct 13, 2005 9:09 pm ] |
| Post subject: | |
| Hope you stopped the servers before doing that! It's really NOT something you want to do with a databse that's in use. Doing it automatically has some potential pitfalls too. http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043
|
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|