Rus wrote:
>
> Hi!
> Does MySQL open all tables in database when I select data from one table?
No. But he will keep last x ones for faster access. My my.cnf file:
[tonu@no tonu]$ cat /etc/my.cnf
[mysqld]
log-slow-queries=/var/log/mysql-slow-query.log
set-variable = long_query_time=1
set-variab
1: No.
2: It depends on a lot of things. If your site traffic is heavy and you can
split your data into discrete elements, you could possibly get better
performance by splitting your data into separate databases and running them
on different servers.
Cal
http://www.calevans.com
-Original M
