Indexing the database

[Dennis Skinner]

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