Hi all, I am a new member of this list. now I have a question. on my site, I add a new lonely database to store some data, and in this db, there is a table contained four columns, in which I put more than 17 million records in each column. after do that, I found out that my site became very slow. my site is based on nuke, and not very much things in it. my site env (PIII933x2, 512M, SCSI18Gx3, RH71 with XFS, mysql3.23.36)
BTW, new db query is very slow for sure. who have good idea to speed it? some detail as follow: mysql> show tables; +----------------+ | Tables_in_nudb | +----------------+ | father_child | | function_xy | | general_info | | head_info | | interpolation | | series_b | | type | +----------------+ 7 rows in set (0.00 sec) mysql> select count(*) from function_xy; +----------+ | count(*) | +----------+ | 17516779 | +----------+ 1 row in set (0.01 sec) mysql> desc function_xy; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | no | int(10) unsigned | | PRI | NULL | auto_increment | | record_no | int(10) unsigned | | | 0 | | | X | char(11) | | | | | | Y | char(11) | | | | | +-----------+------------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) mysql> select * from function_xy where no=123456; +--------+-----------+-------------+-------------+ | no | record_no | X | Y | +--------+-----------+-------------+-------------+ | 123456 | 154 | 2090.66774 | 2.79507+ 1 | +--------+-----------+-------------+-------------+ 1 row in set (0.13 sec) mysql> regards Ares --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
