Re: Under utilization of CPU by MySQL

no.. i had an impression that the slowness can be perfectly measured only if i have very less idle CPU.. My worries how to make MySQL to utilize the fullest CPU time.. either in User/Nice mode. Thanks DEVI.G - Original Message - From: Ananda Kumar To: Devi Cc: mysql

Re: Under utilization of CPU by MySQL

Thanks DEVI.G - Original Message - From: Ananda Kumar To: Devi Cc: mysql@lists.mysql.com Sent: Monday, October 29, 2007 2:33 PM Subject: Re: Under utilization of CPU by MySQL This says, that all app running on this machine are using 50% CPU (50%us). "If not wrong, for any

Re: Under utilization of CPU by MySQL

VI.G - Original Message - From: "Ananda Kumar" <[EMAIL PROTECTED]> To: "Devi" <[EMAIL PROTECTED]> Cc: Sent: Monday, October 29, 2007 1:10 PM Subject: Re: Under utilization of CPU by MySQL Hi Devi, If idle time is around 37%, it means your cpu is 63% utiliz

Under utilization of CPU by MySQL

Hello friends, I'm using MySQL5 on RHEL5. From the top, i understood that the CPU is under utlized by MySQL, whose idle time is around 37%. It is dedicated box for MySQL alone. Is there any way to reduce the idle time of the CPU or how can i make my MySQL to Utilize the full CPU time. Thank

Re: mysqldump for myisam tables.

HI You can use $mysqldump dbname table1 [,table2,table3] >dumpfile[path] or $ mysqldump dbname > dumpfile [path] or $ mysqldump --all-databases >dumpfile [path] --opt will Add a DROP TABLE statement before each CREATE TABLE, Uses the multiline INSERT syntax,Locks all tables on the server befo

Re: How to overwrite existing file with SELECT .. INTO?

Hello Mike, AFAIK, What you have specified is applicable only for tables! But for file in "Select ..into outfile", sure Exit handler is declared when we try to overwrite an existing file! Thanks DEVI.G - Original Message - From: "mos" <[EMAIL PROTECTED]> To: Sent: Sunday, April 15,

Setting up multiple daemons

Hi MySQLeers, How can I setup multiple daemons, One daemon for one database? So that they can act independenly. What might be the pitfalls over here? In what situation one can opt for multiple daemons? What about maximum_connections. Is it for all the server instances? Thanks DEVI. G

Re: Update failing with error 1062

Hi MySQLeers, How can I setup multiple daemons, One daemon for one database? So that they can act independenly. What might be the pitfalls over here? In what situation one can opt for multiple daemons? What about maximum_connections. Is it for all the server instances? Thanks DEVI. G

Fw: Update failing with error 1062

- Original Message - From: "Devi" <[EMAIL PROTECTED]> To: Sent: Monday, February 12, 2007 5:34 PM Subject: Re: Update failing with error 1062 Hi MySQLeers, How can I setup multiple daemons, One daemon for one database? So that they can act independenly. W

RE: turn off auto commit in MYSQL

Hi Peter, Thank you very much I got one more question Do I need to change the table type to transaction-safe tables (InnoDB and BDB) ? AS I am going thru the manuals I read that tables should be of InnoDB or BDB inorder to work for manual commit. once again thanks in advance, Devi

turn off auto commit in MYSQL

Devi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail &

ENUM Data Type

uld I go for.I have no clear Idea of all odd's of each option. If its other database like oracle 7.X/8 I would have used code tables itself, as they don't have any data type like ENUM. Any suggestions would be greatly appreciated.=20 D

auto increment value in tables

time and help Thanks and Regards Devi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]&