Hi Mike,
Try the following:
ALTER TABLE tblname DISABLE KEYS;
LOAD DATA INFILE ...
ALTER TABLE tblname ENABLE KEYS;
hth, Cor
- Original Message -
From: mos [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, July 29, 2006 4:50 AM
Subject: Re: Way too slow Load Data Infile
Dear list,
we are running a Mysql 5.0.22 server that is accessed by a number of
java web applications (jdbc driver 3.1) over the network. The
database layer was realized using the Cayenne framework and InnoDB
was chosen as the table type. All applications share the same
database because
Hello list,
I've a question about understanding table-locks of myisam-tables:
From time to time it happens that my proccesslist gets flooded by
Queries, that
are waiting for a locked table. Quickly there are 100-500 waiting
Queries in the
queue - some of them waiting since more than 1000
i am working on a data collection system for an epidemiological study.
the study holds among other things sensitive personal information. the
personal info is stored in ONE table (i am using innodb_file_per_table)
which we encrypt and wipe after the server is shutdown.
the question is, where
At 03:56 AM 7/29/2006, C.R.Vegelin wrote:
Hi Mike,
Try the following:
ALTER TABLE tblname DISABLE KEYS;
LOAD DATA INFILE ...
ALTER TABLE tblname ENABLE KEYS;
hth, Cor
Hi,
I had tried that on another (larger) t year, and it does of course
load the data slightly faster because the
On 7/28/06, Dan Nelson wrote:
In the last episode (Jul 28), leo huang said:
So, the deleted rows' disk space in tablespace can't re-use when I
use Innodb, can it? And the tablespace is growing when we update the
tables, even the amount of rows do not increase.
It can be re-used after the
Hello,
Why MySQL 5.0.23 while it has serious bug?
I thought you guys will release 5.0.24 instead.
Security fix: If a user has access to MyISAM table t, that user can create a
MERGE table m that accesses t. However, if the user's privileges on t are
subsequently revoked, the user can
On Sat, Jul 29, 2006 at 08:35:41AM -0700, Abdullah Ibn Hamad Al-Marri wrote:
Why MySQL 5.0.23 while it has serious bug?
I thought you guys will release 5.0.24 instead.
This is still the case. 5.0.23 will not be released, and 5.0.24 will be
released as soon as it is ready.
(I see that some
That's why I wondered.
So when will we get MySQL 5.0.25 for FreeBSD?
-A
On Sat, Jul 29, 2006 at 08:35:41AM -0700, Abdullah Ibn Hamad Al-Marri wrote:
Why MySQL 5.0.23 while it has serious bug?
I thought you guys will release 5.0.24 instead.
This is still the case. 5.0.23 will not be
Marco,
It is also possible to set table locks by hand using a lock table
query. These connections will simply show up as sleeping or doing
something else. There currently isn't a show locks command in MySQL.
Depending on what the process list looks like tracking it down could
be as simple as
Vahric,
There are so many variations between different hardware platforms
that can affect performance on your specific application that it's
better to run benchmarks on the actual hardware if you have it. If not
then Peter Zaitsev's performance blog is the next best resource.
In the last episode (Jul 29), Jochem van Dieten said:
On 7/28/06, Dan Nelson wrote:
In the last episode (Jul 28), leo huang said:
So, the deleted rows' disk space in tablespace can't re-use when I
use Innodb, can it? And the tablespace is growing when we update
the tables, even the amount of
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: MySQL 5.0.22 install problems with NetBSD
Description:
Started the install (new install). Reached the step:
scripts/mysql_install_db --user=mysql.
Recieved the following errors:
scripts/mysql_install_db: line 86: ./bin/my_print_defaults:
13 matches
Mail list logo