1) Is there a way to see MySQL using both processors? Is SMP helpful in
this case? (This server is dedicated to MySQL, only one instance).
PS (*nix) should tell you how your processors are used.
PS does show me about the CPU usage, but it doesnt tell me which
processor, or if they're being used at the same time. Or am I missing
a magic PS switch?
2) Is there a way to confirm that MySQL is using NPTL? The glibc 2.4 is
NPTL only, but I'm not sure if this is right.
Depends on which lib mysql uses in your case.
Yeah, I'm aware of that. Since glibc 2.4 has only NPTL, I was wondering if it
is possible to MySQL use a threading system of its own. However, what I want to
know, is a way to confirm that it has been compiled against NPTL.
This appears on my config.log session:
--enable-threads=posix
Thread model: posix
Is that NPTL? I know NPTL is POSIX, but maybe this should say Thread model:
NPTL.
3) My database is entirely MyISAM, reaching almost 35GB, there are 3
large tables with (approx) 6GB each. And this can really slow things
down with joins. How can I make this perform better? More RAM? The MYI
files are almost twice the size of its respective MYD (lotsof indexes).
Read the Optimization sections of the mysql docs.
More RAM will speed it up also.
Thanks. I'll try to bump it up to 4GB to see what happens.
Thanks a lot!
RV
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
