Table Crashes Constantly on prod server!!

on the server is holding about 85% of standard memory but 0.2% of swap used. Could this have anything to do with the settings for the server? Thanks for any help Michael Blood +--+---+ | Variable_name| Value

long running queries

Occasionally I have to add an index on a table with almost 2M rows and it takes a long time. This is expected but when adding the index it seems to block all other queries from other users from executing. Is there a way to prevent this? Thanks Michael Blood

repairing error

it using switch -r or -o Any help would be appreciated Michael Blood - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

./configure error

. Michael Blood - 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

Extra Threads running

are running on the same machine. I dont understand why I receive this error either but maybe it has to do with the same thing. Michael Blood - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Best Operating System

Dual 800 PIII 1 GB RAM 3 18GB SCSI Drive to become a single RAID 5 Array Thanks for any advice Michael Blood - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

file usage

Title: Blank I have found a large number of files which have names like this www-bin.040 www-bin.041 www-bin.042 www-bin.043 www-bin.044 which are using up huge amounts of disk space on my server. It looks to me like they are logs all of the queries that are run with a certain

Optimizing MySQL

and all suggestions are very much appreciated. Michael Blood [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Connection Timeout Limit.

Title: Blank I currently have several different systems accessing a mysql server 3.23.34 somewhere in there is a process that forgets about connections that it has open. So after a few days I get a "too many connections open error". Is there a way that I can set connections to time out

Corrupt Tables??

? Michael Blood --:-- - 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

Default Date value

Title: Blank I am trying to set the default value in a date field to be the time that it was created However I do not want the field to be a timestamp because I want to update it to a different value later. I have looked through the mysql documentation and I can not seem to find anywhere

RE: Default Date value

, March 25, 2001 4:06 PM To: Michael Blood; MYSQL Subject: RE: Default Date value BlankI don't think you can do that with a default value. You will need to include the current date in your insert statement. Cal http://www.calevans.com -Original Message- From: Michael Blood [mailto

import out of MS SQL Server into mysql

Title: Blank Has any one heard of a good way to import from MS SQL Server into a new mysql database. I have a small (120 MB) database that I would like to convert to mysql and I was hoping that there was some sort of tool that will allow me to do it while maintaining the DDL Any