QA


Q&A

Q

Can MySQL take advantage of multiple CPUs in a single server?

A

Absolutely. If your operating system supports multiple CPUs, MySQL will take advantage of them. However, the performance and tuning of MySQL using multiple processors varies, depending on the operating system. For more information, see the MySQL Manual section for your specific operating system: http://dev.mysql.com/doc/refman/5.0/en/operating-system-specific-notes.html.

Q

What permission level must I have to use the OPTIMIZE command?

A

Any user with INSERT privileges for a table can perform OPTIMIZE commands. If a user has only SELECT permissions, the OPTIMIZE command will not execute.




Sams Teach Yourself PHP, MySQL And Apache All in One
Sams Teach Yourself PHP, MySQL and Apache All in One (3rd Edition)
ISBN: 0672328739
EAN: 2147483647
Year: 2004
Pages: 327

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net