Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ORDER BY on 2M rows kills performance permanently
i've got a table with ~2 million rows. i have a select that pulls out an int, a varchar(200) and a CHAR(8) by calculating which entry is the most out-of-date, based on an auto-updating timestamp field and a tinyint priority field. the query is: SELECT url_id, url, hash FROM url WHERE priority... -
mysql uses alot of RAM and doesn't give it back?
i'm using mysql 4.0.16 on a gentoo 1.4 box with a gentoo-patched 2.4.23 kernel, 1.3GHz Athlon, 512MB RAM and 20GB HD space (old hd). i boot up to commandline, login, and top shows 440MB+ of RAM free. i launch an app i've written which begins by hitting mysql with a query against a table of ~2M... -
MySQL performance issues on Linux system
which table type are you using? i've been developing a multi-threaded application that makes one db connection per thread (the threads are persistent, they don't come and go) and i'm also doing alot of inserts and updates and i found the database to be performing at an unacceptable level. i then...
