Thanks Mike,
I've always ignored CHECK TABLE because I always thought it was
just for MyISAM.
I ran CHECK TABLE. It told me that my table was corrupt. I then
dumped the table with mysqldump and recreated it. After that
CHECK TABLE said it was OK (and in comparing values with the master
server
I have several MySQL and FreeBSD installs across a few different sites, and
I consistently have problems with mysqld. It will begin to eat up all of the
CPU and eventually become unresponsive (or the machine will just burn). I
can't seem to manually reproduce this, but given enough time a
Somewhere about Sat, 31-Jul-2004 at 11:17AM -0400 (give or take), Michael Stassen
wrote:
| With LOCAL, the *client* reads the file on the client's machine.
| Without LOCAL, the *server* reeads the file on the server's
| machine. Even though the client and server machines are the same
| in your
Hi!
On Aug 01, Helge Jung wrote:
Description:
When I start up my fresh compiled mysqld it crashes immediately, the
error log file says:
It was reported just a few hours ago at bugs.mysql.com
(which is the recommended way to report bugs, by the way :)
you may follow the progress using
Hi!
On Aug 01, Keith Thompson wrote:
Thanks Mike,
I've always ignored CHECK TABLE because I always thought it was
just for MyISAM.
Then, I decided to run CHECK TABLE on all my tables (which for the
ones with 125 million rows will probably be running for a while).
The problem now is that
Hi Sergei,
I did come from 4.0.17 to 4.1.3 with a complete dump/reload.
Then, all changes after that forward came via replication.
I didn't read anything about corruption problems as a replication
slave.
-keith
Hi!
On Aug 01, Keith Thompson wrote:
Thanks Mike,
I've always ignored CHECK
I use Mysql with JBOSS as applicationserver.
i have strange response-time differences, which i can't explain.
1) after reboot the computer, it takes about 300ms to read 12 entities (cmp,
read ahead, 2 rows each entity) One entity is accessed by primary key, the
others by
foreign key.
2) when i
Hi
Sorry if I'm off topic but I am a touch desperate
We make use of a mysql 4.x hosted by a third party and we use ASP to access
this data
Our Connection string looks like this:
xDb_Conn_Str=DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://xxx/x
xx};uid=xxx;pwd=xx;
This
- Original Message -
From: John Berman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 01, 2004 7:27 AM
Subject: Connectiing
Hi
Sorry if I'm off topic but I am a touch desperate
We make use of a mysql 4.x hosted by a third party and we use ASP to
access
this data
At 01:21 AM 8/1/2004, Keith Thompson wrote:
Thanks Mike,
I've always ignored CHECK TABLE because I always thought it was
just for MyISAM.
I ran CHECK TABLE. It told me that my table was corrupt. I then
dumped the table with mysqldump and recreated it. After that
CHECK TABLE said it was OK (and
Patrick Connolly wrote:
Somewhere about Sat, 31-Jul-2004 at 11:17AM -0400 (give or take), Michael Stassen
wrote:
| With LOCAL, the *client* reads the file on the client's machine.
| Without LOCAL, the *server* reeads the file on the server's
| machine. Even though the client and server machines
hi...
i'm testing an app where i want a parent app to create the mysql db
connection link/handle, and basically pass this handle off to child
procesess. is there any reason why this can't be done? are there any
examples of this already being accomplished that you might provide???
as far as i can
SELECT offerid, resellerid, price FROM A WHERE pricece = MIN(price) GROUP BY
resellerid;
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Daniel Lahey [EMAIL PROTECTED]
Cc: Haitao Jiang [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 30, 2004 7:33 PM
Subject: Re:
David Griffiths wrote:
Really? I had no idea. I am pretty sure that only Day will have a range.
Our index is currently, (yearmonth, day, stem_base), so I need to drop
and recreate it.
I think part of the slowness is the size of the table as well. We have
data going back years in there. I am
I've just downloaded 4.0.20 for windows
Installed on the D: drive. Set up an .ini pointing at D: drive
Ran D:\mysql\bin\mysqld
When I then ran mysqlshow I only had the test database, not the mysql database as the
documentation said I should.
I then deleted everything and installed again,
I just set up another reeplication slave for one of my servers - it's not
something new to me. I'm using 4.1.3-beta on a new server which will
eventually take over as the master. I set up a server id, did change
master to... and started the slave - but the slave seems to perpetually stay
in a
Hey Mike,
Thanks again for your suggestions.
I understand (and agree) with your comments about a clean shutdown.
I'm always careful to do that. In this case, the mysql server has
only been shutdown a couple times and it was a clean shutdown in
each case.
You suggest running table checks daily.
That won't work either. You cannot use an aggregate function in the WHERE
clause. The purpose of the WHERE clause is to determine which rows to look
at, but you won't know the MIN(price) until after you've looked at them.
You can use aggregate functions in the HAVING clause, but that filters
[note: This discussion went on off-list, but I thought the info might
be useful in list context, so I am reposting it to the list. Sorry
about the lack of individual messages. I wish gmail had an option to
automatically add an address to a reply when you are replying to a
message that has been
faild and locked up. I'm hoping it is no. 1 that happened. if so,
how do I get a command prompt after I start the server?
Did you end the command with a character?
I've been looking through the doc, the --help file, and the messages in the
archives, and I can't find a reference to what this
Whil Hentzen wrote:
faild and locked up. I'm hoping it is no. 1 that happened. if so,
how do I get a command prompt after I start the server?
Did you end the command with a character?
I've been looking through the doc, the --help file, and the messages in the
archives, and I can't
hi...
within the linux/unix world, the '' at the end of a shell/command normally
has meant to run the command as a background process
for further information, search google for ' background process linux'
etc...
-bruce
-Original Message-
From: Whil Hentzen [mailto:[EMAIL
I've been looking through the doc, the --help file, and the messages in
the archives, and I can't find a reference to what this character
_means_.
The tells bash to fork the process into the background so you get
your console / xterm back. If you don't use the at the end, the
At 12:55 PM 8/1/2004, Keith Thompson wrote:
Hey Mike,
Thanks again for your suggestions.
I understand (and agree) with your comments about a clean shutdown.
I'm always careful to do that. In this case, the mysql server has
only been shutdown a couple times and it was a clean shutdown in
each
On Sun, Aug 01, 2004 at 09:22:21AM -0700, bruce wrote:
hi...
i'm testing an app where i want a parent app to create the mysql db
connection link/handle, and basically pass this handle off to child
procesess. is there any reason why this can't be done? are there any
examples of this already
On Sun, Aug 01, 2004 at 01:42:24PM +0200, Marc wrote:
I use Mysql with JBOSS as applicationserver.
i have strange response-time differences, which i can't explain.
1) after reboot the computer, it takes about 300ms to read 12 entities (cmp,
read ahead, 2 rows each entity) One entity is
jeremy...
hey.. how's yahoo!! anyway, i know you should be able to do this... do you
have any examples of code or can you point me to an example that
demonstrates how to do it...
i've been trying to accomplish this with perl for 2-3 days now with no
luck.. so i know there must be something i'm
At 18:29 -0500 8/1/04, Whil Hentzen wrote:
I've been looking through the doc, the --help file, and the messages in
the archives, and I can't find a reference to what this character
_means_.
The tells bash to fork the process into the background so you get
your console / xterm back. If
Ah, it's not part of the mysqld command itself. Got it.
Right. It's a process-control aspect of how the shell itself works.
And it's also rather confusing! *s* I really thought it was just another part
of the command, not a structure like a pipe or a redirector.
Oh, these Windows
Which mysql username did you use to log in? I've not used mysql on Windows,
but I expect that if you simply ran mysqlshow on a new install, you'd
connect as the anonymous user. The anonymous user only has rights to the
test db, so that's all you'd see. Try
mysqlshow -u root
or, if you've
Hello everyone,
I recently decided to perform an experiment. I was using Java to do
string comparison on sometimes large data sets (this would sometimes
take days). A friend of mine at work suggested that I use MySQL's full
text searching. I quickly made the change over and I've found that
31 matches
Mail list logo
