April Sims ([EMAIL PROTECTED]) writes:
> Is there anything I need to be doing maintenance wise on a mysql database?
> I have inherited one that was installed as follows....
>
> As far as database stuff that we do, we basically
> installed the server, set up databases and tables, and use them.
> Indices have been created on many of the tables to speed up access
> times.
>
> It is being replicated to another server continuously.
> In particular mysqldump, mysqladmin, optimize, mysqlcheck, etc.....
We don't do anything here. Every now and then the server gets rebooted for one reason
or another (every 45-60 days), and either "isamchk -r -e -s -o -f" or "myisamchk -r"
gets run, followed by "optimize table" commands on some of the most updated tables.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php