It does not seem fine to me, mysql seems to really get slow once you
break about the 3 gig myd size, or 1.5 gig myi size
not sure why, I've changed every setting, but nothing seems to help
Matt
Clyde Lewis wrote:
Matt,
Looking at how the database if currently configured, do you have any
su
On Monday 29 August 2005 04:55 pm, Alexey Polyakov wrote:
> I'd try setting
> innodb_buffer_pool_size=8G
> in my.cnf
Then it will run out of memory. You only get 2gig for bufferpools no matter
how much more you have.
--
===
Jab
I'd try setting
innodb_buffer_pool_size=8G
in my.cnf
--
Alexey Polyakov
If you are doing big updates on indexes, like during an import, you
want to adjust your variables accordingly. The variables that would
speed inserts and index updates are
key_buffer_size
bulk_insert_buffer_size
if using MYISAM table types:
myisam_max_sort_file_size
myisam_sort_buffer_size
R
Get used to it, I've got similar tables, mine have less columns, but
more records, my biggest takes a week to restore a mysqldump
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This is a test server with nothing else hitting the box. I imported a
dump of a production database and is trying to find a way to reduce the
time it takes to rebuild the index on the mentioned table
Hard Drive spec:
Clarion EMC Hard drive 100 GB internal 3.5" Fibre Channel 1 rpm buffer
Clyde Lewis <[EMAIL PROTECTED]> wrote on 08/29/2005 01:47:11 PM:
> Guys,
>
> I have a huge table to which I'm attempting to update the foreign key
> and index. It is taking me more than 20 hrs to complete the process and
> would like to know if someone can point me in the right direction.
> Pl
Guys,
I have a huge table to which I'm attempting to update the foreign key
and index. It is taking me more than 20 hrs to complete the process and
would like to know if someone can point me in the right direction.
Please let me know of any additional information that I should provide.
mysq