MySQL Forums :: Memory Storage Engine :: Use more CPU and Ram
Use more CPU and Ram
Posted by: PF SQL ()
Date: November 28, 2012 05:07PM
Hi,
Fist of all i'd like to know if I am using 32bit mysql or 64bit when the result to SHOW GLOBAL VARIABLES LIKE 'version_compile_machine'; query is x86. NOT x86_64! show variables like 'version_compile_machine'; gives the same result.
Secondly I'd like to improve the performance of mysql when adding and retrieving data, I've notice that only 30% cpu and 1-2% Ram are used. I am using InnoDb default storage engine (if that helps).
Thank you.
Fist of all i'd like to know if I am using 32bit mysql or 64bit when the result to SHOW GLOBAL VARIABLES LIKE 'version_compile_machine'; query is x86. NOT x86_64! show variables like 'version_compile_machine'; gives the same result.
Secondly I'd like to improve the performance of mysql when adding and retrieving data, I've notice that only 30% cpu and 1-2% Ram are used. I am using InnoDb default storage engine (if that helps).
Thank you.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Use more CPU and Ram | 733 | PF SQL | 11/28/2012 05:07PM |
| Re: Use more CPU and Ram | 431 | Rick James | 12/02/2012 07:46PM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates