What are the configuration you are using? What's the size of your buffers?
What's your system?
Maybe increasing sort buffer and key buffer will be good.
;)
Alexis
Quoting Brad Teale <[EMAIL PROTECTED]>:
> Hello,
>
> The problem:
> I have the following query with is taking upwards of 2 minute
Hi
Somebody knows what are the buffers that MySQL uses when creating indeces in
InnoDB tables?
I increased the sort buffer, the tmp_table_size, the buffer_pool, the
buffer_log, the log_file but i didn't have performance increase...
Anyone have this problem too?
What buffers are used?
I'm cr
Mysql database have only innodb tables. I'm not using MyISAM.
Quoting Misaochankun <[EMAIL PROTECTED]>:
> Most likely your mysql database is still MyISAM, right?
>
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 30, 2003 12:35 PM
> To: [
Hi all :)
I'm working with InnoDB tables only, and i read that the Key_buffer_size is only
used for MyISAM tables. Is it true?
If yes, i can put this variable to 0?
Thx
Alexis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
I've the same problem with sub-selects too.
One way to resolve this problem is creating index on the attribute that you are
using in the sub-select (in your case, you are doing a full scan, so the index
don't works).
Another way is re-creating the query. You can transform the sub-select in a joi
Yes, i did that.
It's given me something like
si 200/300
so 300/500
It's a lot, doing my system going down. But i think that the problem is that i'm
reserving too much memory for mysql...
Or could exists another reason?
Thx
Alexis
Quoting Per Andreas Buer <[EMAIL PROTECTED]>:
> [EMAIL PRO
Hi,
I'm working in MySQL with innodb tables, in Linux (Red Hat 9).
I'm creating indexes in a table with 16 million rows (it's a fact table), and it
takes a lot of time (2/3/4 hours), because my system is always swapping in/out
(i think).
At the start of the creating, it's fast (because my buff
