table that they're waiting for is a MyISAM table. These
should be atomic processes. Is there something at the OS-level that might
tell me what's causing the hangup? Did I jump onto the RH9 bandwagon too
soon?
On Fri, 4 Jul 2003, Jeremy Zawodny wrote:
> On Thu, Jul 03, 2003 at 06:5
Hello,
I have nine process that import data to tables with the same structure
within about 1000 databases on a server. Each process fires at the same
time, every 5 minutes.
Lately I'm seeing these inserts hang, all waiting upon the same table, and
they do not clear up. I've searched through th
le is crashed
>
> I hope this helps.
>
>
>
> -Original Message-
> From: Mike Lucente [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 9:00 AM
> To: [EMAIL PROTECTED]
> Subject: Unable to add index
>
>
> Hello,
>
> I cannot add a
Hello,
I cannot add an index to one of my tables. I get the following message:
mysql> alter table devlog add index (dt_status);
ERROR 1030: Got error 127 from table handler
I've run 'myisamchk -o ' on the table in question.
What should I try next?
Version: Server version 3.23.29a-gam
-world limitations.
>
> Or (for 100MB files):
> mysqldump db table |split -b 1 - table
>
> --Bill
>
>
> Mike Lucente wrote:
>
> > I'm also unable to create files >2GB with mysqldump, even after a
> > recompile with gcc 2.96, RH 7.1 w/2.4.2 kernel
s?
>
> Or, if you have moved the tables with symlinks, MySQL will put the new file
> (most of the time?) in the configured data directory and not where the
> symlink points.
>
> --Bill
>
>
>
> Mike Lucente wrote:
>
> > I'm running out of space while
t; (most of the time?) in the configured data directory and not where the
> symlink points.
>
> --Bill
>
>
>
> Mike Lucente wrote:
>
> > I'm running out of space while creating indexes on some fairly large (1.8
> > GB) tables, even though I have quite a
I'm running out of space while creating indexes on some fairly large (1.8
GB) tables, even though I have quite a bit of space available in the
partition (utilization is at 30%).
I know that the create process works as follows (from the manual):
Create a new table named `A-xxx' with the requested
