RE: Backup question
Howdy, I tend to do both a dump to disk and then stop the DB and do a tape backup. I don't believe there is an Online backup capability as user transactions would need to be stored and played back against the DB after the backup as in most production ready DB's. Sid Young QML Pathology Database Administrator -Original Message- From: Kraa de Simon [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 5:47 PM To: '[EMAIL PROTECTED]' Subject: Backup question Hi, I'm running MySQL on a NT box and do a nightly backup of the complete file system to tape. I know I should use mysqldump and probably stop MySQL but will a file system copy do as well? The system is inactive at the time. Met vriendelijke groet / With kind regards, ICL Nederland B.V. Simon de Kraa e-Applications / Logistic Systems Systems Architect Het Kwadrant 1 Tel. +31 346 598865 Postbus 4000Fax +31 346 562703 3600 KA MAARSSEN The Netherlands mailto:[EMAIL PROTECTED] --- Progress 9.1b, Roundtable 9.1c, NuSphere Pro Advantage 2.2 @ MS Windows 2000 5.00.2195 SP 2 Progress 9.1b @ SCO UnixWare 7.1.1 - 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 - 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
Command line switchs (was RE: Debugging: Analysis)
You know what .. the problem with the command line switchs is they are so hard to remember... Take myisamchk -Ber ... for instance Now if it was myisamchk -Beer ... or myisamchk -JugOfBeer ... then people might do better maintenance! Sid -Original Message- From: Rodney Broom [mailto:[EMAIL PROTECTED]] Sent: Friday, 31 August 2001 11:32 AM To: [EMAIL PROTECTED] Subject: Re: Debugging: Analysis From: Bill Blowitz [EMAIL PROTECTED] Try fixing all tables/indexes. Actually, I started with % myisamchk -Ber ... on all tables that -e said needed to be fixed. --- Rodney Broom Programmer: Desert.Net - 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 - 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
RE: FreeBSD and multiple daemons
Jerry, Thats a reasonably serious hardware platform, you should not encounter 30 second delays, did you compile mysql yourself or use a pre-compiled binary... Sid -Original Message- From: PR [SMTP:[EMAIL PROTECTED]] Sent: Sunday, August 19, 2001 4:28 PM To: [EMAIL PROTECTED] Subject: FreeBSD and multiple daemons I'm having a problem with my server getting bogged down once in a while and I'm pretty sure it's due to the mysql daemon getting maxed out with what it can do... when this happens there might be anywhere from 100 to 150 processes in the processlist and it might take as much as 30 seconds to return a query via a web browser. When it happens mysql is usually using almost 100% cpu, but load stays around 1.3 to 1.5. I'm running FreeBSD 4.3-Release and mysql 3.23.40 We recently upgraded both because of some of the past comments about the sleeping threads on the list in slightly older versions. The server is dual P3-1G, 1g ram with SCSI drives on single channel raid card. Is there a very stable way to run multiple daemons on FreeBSD? A howto or some such thing that might describe setting it up. I can run the memory up to 4g on the machine if necessary to handle the extra memory requirements. Also, are there changes I'll have to make to my apps that use mysql to deal with this? I searched the list for multiple daemons and didn't find much there, maybe I'm using the wrong keywords to search for. Any pointers or help would be greatly appreciated. Jerry - 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 - 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