Thanks everybody for attention!
I make some changes in hardare and in my table, and obtain a average response
times of 0.09 second.
Now i have a good time ! :-)
Show you my changes:
1-Update MySql 4.1.18 -> 5.0.21.
2-Upgrade my memory to 3 Gb.
3-Severance of temporary/logs files and data file
Jan Gomes wrote:
The query is:
SELECT * FROM table
where id_table2 in (1652272,1652293,1652316,1652362);
+-+---+---+--+
| select_type | table | type | possible_keys |
+-+---+---+--+
| SIMPLE | table | r
Hy Jay,
> You don't show the query you are explaining.
The query is:
SELECT * FROM table
where id_table2 in (1652272,1652293,1652316,1652362);
+-+---+---+--+
| select_type | table | type | possible_keys |
+-+---+---+---
Jan Gomes wrote:
Hy Jay,
Thanks for you attention.
Show you my structure and EXPLAIN:
CREATE TABLE `table` (
`id_table1` int(10) unsigned NOT NULL default '0',
`id_table2` int(10) unsigned NOT NULL default '0',
`field1`smallint(5) unsigned NOT NULL default '0',
`field2`mediumint(8
Hy Jay,
Thanks for you attention.
Show you my structure and EXPLAIN:
CREATE TABLE `table` (
`id_table1` int(10) unsigned NOT NULL default '0',
`id_table2` int(10) unsigned NOT NULL default '0',
`field1`smallint(5) unsigned NOT NULL default '0',
`field2`mediumint(8) unsigned NOT N
Please post your exact table schema using SHOW CREATE TABLE, and your
exact query, along with an EXPLAIN SELECT for the query.
Thanks!
-jay
Jan Gomes wrote:
Hy Guys,
I have a simple structure of tables, howewer has 50 million of registers and
2,5 GB of data.
The table is MyIsam and has 4 in
Jan, right now I would say performance sounds pretty good for the amount
of data you have. 50 million records / 2.5 GB of data is a pretty
sizable dataset, so 4 seconds to retrieve a handful of records seems decent.
Some suggestions for things you could do to possibly improve performance:
1 -