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
]]
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
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
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
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
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
;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
>
>
--
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
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
, 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
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
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
.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.
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
?
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
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
16 matches
Mail list logo
