On Tue, Jul 10, 2001 at 04:23:13PM +0100, kevin lyda wrote:
> have a problem with a few huge sql queries that join a lot of tables.
> tried increasing the table_cache and it just dies at startup now.
> any tips? has anyone here done large sql queries on large tables in
> mysql - any ideas on how to get them to return quicker?
What do the logs say?
How big did you set table_cache to be? 1024 is, typically, quite a
big number for MySQL's table_cache. Try a big temporary table max size:
... -O tmp_table_size=8388608
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!