Hi Alex,
with MySQL 4.1.22 there is not much you can do.
MySQL alter tables recreating a new temporary one and swapping then
afterwards.
In my opinion the effort to speed up the process is not worth for just this
alter table.
Cheers
Claudio
2011/6/21 Alex Schaft
> Hi,
>
> I'm busy creating
Change the following parameter:
myisam_sort_buffer_size=300MB
Larger than here.
myisam_max_sort_file_size=10GB
Reduce this value to 30% of your real memory.
On Tue, May 13, 2008 at 7:10 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi Krishna,
> how do i make my index to get more key blocks
>
> O
Hi Krishna,
how do i make my index to get more key blocks
On 5/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi anand,
>
> PRIMARY KEY (`id`),
> KEY `KI_IDX_0805090456` (`words`,`id`),
> KEY `CI_IDX_0805090456` (`lf_id`)
>
> Since id is a primary key. Then why again indexing o
Hi anand,
PRIMARY KEY (`id`),
KEY `KI_IDX_0805090456` (`words`,`id`),
KEY `CI_IDX_0805090456` (`lf_id`)
Since id is a primary key. Then why again indexing on id is being created
(`words`,`id`). It will be a duplicate index on id. words is a varchar
type. So instead of creating fulltext index
| Handler_commit| 25802690 |
| Handler_delete| 100 |
| Handler_discover | 0|
| Handler_prepare | 10370014 |
| Handler_read_first| 88920|
| Handler_read_key
At 08:18 AM 5/12/2008, you wrote:
Hi All,
We have a table which is around 100 Million rows. Its a myisam table, but
the db default is innodb.
CREATE TABLE `dc_data` (
`id` decimal(22,0) NOT NULL,
`words` varchar(255) NOT NULL,
`lf_id` decimal(22,0) NOT NULL,
`occurence` bigint(20) NOT NUL
myisam_max_sort_file_size=10GB
You have alloted 10GB memory to myisam_max_sort_file_size, The system has
8GB of memory.
send show global status;
On Mon, May 12, 2008 at 6:48 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> We have a table which is around 100 Million rows. Its a myisam ta
Chris,
We have found the same thing, the more indexes you add the longer it takes
to add another index. This is because at least from what I understand is
the index/MYI file is recreated when you add another index.
I don't know enough about INNODB but based on what I do know you would do
much bet
Mike,
Thanks for the input. I also received this tip from Peter of the MySQL team.
We'll see if it works.
Chris.
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 3:03 PM
To: Chris Fossenier
Cc: MySQL List
Subject: Re: Index Creation Bottle
At 12:23 PM 1/26/2004, you wrote:
We have a large database that consists of 1 table with 400 fields. I know,
the first thing you are thinking is normalize, it's not an option right now
and the database gets reloaded every 3 months. The table contains marketing
data so it is not as easy to normalize
10 matches
Mail list logo
