ory 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
.MYI' is corrupted
Fix 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.
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
;user: '[EMAIL PROTECTED]' (Using password: YES)(0), retry in 60
>
>Where else could this be stored at? How can I find exactly which
>configuration file it actually used?
>
>Thanks
>
>Michael Blood
>
>
--
ny ideas.
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 unsub
plications which 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
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
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
]]
Sent: Tuesday, June 26, 2001 11:33 AM
To: Mysql
Cc: "Michael Blood"
Subject: Re: Optimizing MySQL
> Recently the index files became corrupted and I ran the
> myisamchk *.MYI -r -S to repair them.
Try an OPTIMIZE TABLE or ANALYZE TABLE. Your queries may be using the
incorrect i
y 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
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 af
?
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 unsubscr
Title: Blank
does any one know how mysql can handle an
exists query.
for example
select xcolumn from ytable
where exists (select 1 from ztable where
ytable.id = ztable.id)
I realize that in this particular example I
can rearrange my query but there are lots of other queries where I find
, 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 [m
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 t
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 suggestio
16 matches
Mail list logo
