12 Jun
2007
12 Jun
'07
6:17 p.m.
Irina wrote:
Did I have to do anything special?
You will want to consult the MySQL docs on their site for how to handle indexing. IIRC the default .sql file had some indexes in it. I would, however, recommend switching the table type to InnoDB for the radacct db at least. MyISAM will lock the entire table during inserts. InnoDB does row locking. With InnoDB, you can also pass --single-transaction to mysqldump and it shouldn't interrupt normal operations during nightly dumps for backup purposes. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com