my-huge.cnf quite outdated

Hi, Isn't the my-huge.cnf in the MySQL 5.0.22 distribution quite outdated? It says "for systems with 512Mb RAM or more". Nowdays this is pretty basic setup, and 'huge' is probably something in excess of 4Gb RAM. I wonder if anyone has a recommendation for truly huge systems. For example a dual CP

Re: dropping primary key - 99%CPU

Gaspar Bakos wrote: Hi, Dan, RE: Currently mysql handles all "ALTER TABLE" commands by rebuilding the entire table and all indexes. OK, so an "add index" is mapped to "alter table", and the "alter table" rebuilds everything. This means if I have a table with multiple indexes, it does

Re: dropping primary key - 99%CPU

At 04:29 PM 6/10/2006, you wrote: Hi, Dan, RE: > Currently mysql handles all "ALTER TABLE" commands by rebuilding the > entire table and all indexes. OK, so an "add index" is mapped to "alter table", and the "alter table" rebuilds everything. This means if I have a table with multiple indexes,

Re: dropping primary key - 99%CPU

Hi, Dan, RE: > Currently mysql handles all "ALTER TABLE" commands by rebuilding the > entire table and all indexes. OK, so an "add index" is mapped to "alter table", and the "alter table" rebuilds everything. This means if I have a table with multiple indexes, it does not make too much sense to

Re: dropping primary key - 99%CPU

In the last episode (Jun 10), Gaspar Bakos said: > Could someone explain why dropping a primary key of a table (of > ~1million rec) may take up to minutes of time and 99%CPU? > > Naively, I would have thought that this involves only updating the > index file. Currently mysql handles all "ALTER TA

re-installed 4.1 -- can't read tables....

Hi, due to some problems I was having I re-intalled 4.1 the other day (had orig zip from when first downloaded (mysql-4.1.9-win32.zip), so was able to install exact same version I had previously) only problem is, I can't read tables... I had backed up my data, copied my db's back to 'data' dir

dropping primary key - 99%CPU

Hi, Could someone explain why dropping a primary key of a table (of ~1million rec) may take up to minutes of time and 99%CPU? Naively, I would have thought that this involves only updating the index file. However, all the .MYD, MYI and .frm files are duplicated (#sql-*), and then something happe

CRM: Labels instead of specific atributes

Hi everyone, Well I don´t have a question, but instead a proposition that I would to discuss with people to find what are they doing and why. For example I have developed and still developing a big and largely used CRM platform. And since it´s primary version the system has growth in a w

Re: OR isn't optimised

No luck Dan. The reason why I had the straight join was because the optimiser was joining the tables in a non-optimal way - it wasn't using both parts of the key (the same problem I'm having now) so I changed it to straight join to see if the optimiser would use both parts of the key. mysql> exp

MYSQL Query Browser 1.1.20 problem

Hi all I have problem in MYSQL query browser tool. I make a two tables ,one have primary key, and in second table i put reference to first table. I make all this in Query browser and set foreign key of second table to on delete no action. I apply changes but next time when i want to edit second