Joris Kinable wrote:
Good evening,
I've got to create a very large table: 180GB of data has to be stored.
In order to to this I'm using the following steps:
1. Create database structure including keys.
2. Disable keys: ALTER TABLE ut_netflow_4 DISABLE KEYS
3. Load data into the database.
4. Gen
At 05:42 PM 10/3/2006, you wrote:
Dan Nelson wrote:
In the last episode (Oct 03), Angelo Zanetti said:
I've got a database that has a few thousand rows, I've noticed that
some of the search queries (especially the large ones) are taking
some time. Im looking at adding indexes to my tables
Dan Nelson wrote:
In the last episode (Oct 03), Angelo Zanetti said:
I've got a database that has a few thousand rows, I've noticed that
some of the search queries (especially the large ones) are taking
some time. Im looking at adding indexes to my tables in order to
speed up the data retr
In the last episode (Oct 03), Angelo Zanetti said:
> I've got a database that has a few thousand rows, I've noticed that
> some of the search queries (especially the large ones) are taking
> some time. Im looking at adding indexes to my tables in order to
> speed up the data retrieval.
>
> My ques
Angelo, results should be (nearly) immediate. When you add an index,
MySQL creates an index for the existing data in your table. Later,
when data is added/updated/deleted, the index is updated
simultaneously.
With a few thousand rows, you should be able to get by adding a few
indexes where they
"Ângelo M. Rigo" <[EMAIL PROTECTED]> wrote on 01/27/2005 03:04:15
PM:
> Hi
>
> I have an aplication wich is opening to many connections even i am
> using persistent connectins and closing every connection i do open
>
> I have created indexes in all the fields i supose they are needed
>
> I
005 11:14 AM
To: Dathan Pattishall
Subject: RE: Creating indexes
using the show status variables can i discover wich
collumn or query is consuming resources and opening to
If i need to create / drop indexes from MyISAM tables how does the blocking
work?
I need to mess with some indexes on a production database, and dont want
downtime.
Should i do this in the middle of the night, when hardly anyone is using the
system, or will the blocking be negligable?
thanks
sea
On Wed, Oct 03, 2001 at 05:39:09PM +, 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, glibc 2.2.2.
AFIAK, it is limitation of ext2 file sistem.
You can't create any file lager then 2GB on ext2.
[skip]
This worked once I recompiled the distribution. Thanks.
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
>
> Apparently you have to compile for large file support and have glibc > 2.1.3.
> http://www.suse.de/~aj/linux_lfs.html
>
> I have not used it so I do not know the real-world limitations.
>
>
Apparently you have to compile for large file support and have glibc > 2.1.3.
http://www.suse.de/~aj/linux_lfs.html
I have not used it so I do not know the real-world limitations.
Or (for 100MB files):
mysqldump db table |split -b 1 - table
--Bill
Mike Lucente wrote:
> I'm also unab
Hi!
On Oct 03, 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 bit of space available in the
> partition (utilization is at 30%).
>
> I know that the create process works as follows (from the manual):
>
> C
0
-Original Message-
From: Mike Lucente [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 1:25 PM
To: Adams, Bill TQO
Cc: [EMAIL PROTECTED]
Subject: Re: Creating indexes on large tables
I'm running 2.4.2 and I'm not using symlinks.
On Wed, 3 Oct 2001, Adams, Bill TQO
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, glibc 2.2.2.
hmmm ...
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
> Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
> limit on 2.2.x kernels?
>
> Or, if you
I'm running 2.4.2 and I'm not using symlinks.
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
> Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
> limit on 2.2.x kernels?
>
> Or, if you have moved the tables with symlinks, MySQL will put the new file
> (most of the time?) in
David Turner wrote:
> If this is the case. What are the steps necessary for index rebuilds? Can
> I specify where the index file is rebuilt? Any idea when we can specify
> the location of datafiles and indexfiles?
For the kernel: You either need to upgrade to a later 2.4.x series kernel which,
I
If this is the case. What are the steps necessary for index rebuilds? Can
I specify where the index file is rebuilt? Any idea when we can specify
the location of datafiles and indexfiles?
Thanks, Dave
On Wed, Oct 03, 2001 at 07:57:35AM -0700, Adams, Bill TQO wrote:
> Perhaps your index file (.MY
Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
limit on 2.2.x kernels?
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
18 matches
Mail list logo
