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@lists.mysql.com Sent: Monday, October 29, 2007 3:11 PM Subject: Re: Under utilization of CPU by MySQL with this CPU load, is there any database slowness or any other issues. regards anandkl On 10/29/07, Devi <[EMAIL PROTECTED]> wrote: Hi, I'm running only MySQL in that machine. That's why i can't understand why it consumes only 50% of CPU. Interestingly its nice% is also 0. I mean only if MySQL utilizes the full CPU, i can estimate the performance of MySQL for different Client Applications. 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 application, we can estimate the performance level only it its idle time is less than 5%." What do u mean by the above statement. regards anandkl On 10/29/07, Devi <[EMAIL PROTECTED]> wrote: Hi Anand, Thanks for the immediate response. The us% is around 50 and sy% is around 10. Other than idle some 3-5% was given to software & hardware interrupts. If not wrong, for any application, we can estimate the performance level only it its idle time is less than 5%. Thanks DEVI.G - Original Message - From: "Ananda Kumar" <[EMAIL PROTECTED]> To: "Devi" < [EMAIL PROTECTED]> Cc: < mysql@lists.mysql.com> 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% utilized. It again > depends on what kind of query is running on ur system. > > Can u also please check %us, %wa and %sy. > %us will give amount cpu utilized by any applicaiton running on the > machine. > > %wa will give amount of wait io. > > %sys will give cpu utilized by system kernal. > > regards > anandkl > > > On 10/29/07, Devi < [EMAIL PROTECTED]> wrote: >> >> 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. >> >> Thanks >> DEVI.G > No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.12/1097 - Release Date: 10/28/2007 1:58 PM -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.12/1097 - Release Date: 10/28/2007 1:58 PM -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.12/1097 - Release Date: 10/28/2007 1:58 PM
Re: Under utilization of CPU by MySQL
Hi, I'm running only MySQL in that machine. That's why i can't understand why it consumes only 50% of CPU. Interestingly its nice% is also 0. I mean only if MySQL utilizes the full CPU, i can estimate the performance of MySQL for different Client Applications. 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 application, we can estimate the performance level only it its idle time is less than 5%." What do u mean by the above statement. regards anandkl On 10/29/07, Devi <[EMAIL PROTECTED]> wrote: Hi Anand, Thanks for the immediate response. The us% is around 50 and sy% is around 10. Other than idle some 3-5% was given to software & hardware interrupts. If not wrong, for any application, we can estimate the performance level only it its idle time is less than 5%. Thanks DEVI.G - Original Message - From: "Ananda Kumar" <[EMAIL PROTECTED]> To: "Devi" <[EMAIL PROTECTED]> Cc: < mysql@lists.mysql.com> 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% utilized. It again > depends on what kind of query is running on ur system. > > Can u also please check %us, %wa and %sy. > %us will give amount cpu utilized by any applicaiton running on the > machine. > > %wa will give amount of wait io. > > %sys will give cpu utilized by system kernal. > > regards > anandkl > > > On 10/29/07, Devi < [EMAIL PROTECTED]> wrote: >> >> 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. >> >> Thanks >> DEVI.G > No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.12/1097 - Release Date: 10/28/2007 1:58 PM -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.12/1097 - Release Date: 10/28/2007 1:58 PM
Re: Under utilization of CPU by MySQL
Hi Anand, Thanks for the immediate response. The us% is around 50 and sy% is around 10. Other than idle some 3-5% was given to software & hardware interrupts. If not wrong, for any application, we can estimate the performance level only it its idle time is less than 5%. Thanks DEVI.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% utilized. It again depends on what kind of query is running on ur system. Can u also please check %us, %wa and %sy. %us will give amount cpu utilized by any applicaiton running on the machine. %wa will give amount of wait io. %sys will give cpu utilized by system kernal. regards anandkl On 10/29/07, Devi <[EMAIL PROTECTED]> wrote: 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. Thanks DEVI.G No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.12/1097 - Release Date: 10/28/2007 1:58 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. Thanks DEVI.G
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 before starting the dump and unlocks the same. --opt is default. Thanks ViSolve DB Team - Original Message - From: "Ananda Kumar" <[EMAIL PROTECTED]> To: "MySQL" Sent: Friday, June 15, 2007 10:05 AM Subject: Re: mysqldump for myisam tables. Hi All, What are the parameters that i need to use to take consistent backup of myisam tables using MYSQLDUMP. regards anandkl On 6/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi All, I am taking mysqldump of myisam table for the first time on a production database. Can you please let me know what all necessary thing i need to take care before i start mysqldump. Its on a running database. Also please tell me what all important parameters i need to use in mysqldump. Thanks for your help regards anandkl No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date: 6/14/2007 12:44 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, 2007 8:36 AM Subject: Re: How to overwrite existing file with SELECT .. INTO? At 08:14 AM 4/13/2007, Amer Neely wrote: I'm using MySQL 5.0.21 and am trying to find out if it is possible to overwrite an existing file when using a 'SELECT ... INTO' command from the command line. Is there another parameter that can do this? I've looked through the online reference manual, but found no specific help there. -- Amer Neely Amer, Why can't you do: drop table if exists mynewtable;select .. into mynewtable Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.4.0/762 - Release Date: 4/15/2007 4:22 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -Original Message- From: Peter Brawley [mailto:peter.brawley@;artfulsoftware.com] Sent: Wednesday, November 13, 2002 6:04 PM To: Devi Annisetty Subject: Re: turn off auto commit in MYSQL SET @@autocommit=0 or BEGIN - Hi, I am newbie to MYSQL and ODBC I have to update more than 2 tables simultanously currently my application uses ADOBC connection object. How can turn off the autocommit option and set manaul commit. what places I need to change inorder to work manual commit Thanks in Advance for your time 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
turn off auto commit in MYSQL
Hi, I am newbie to MYSQL and ODBC I have to update more than 2 tables simultanously currently my application uses ADOBC connection object. How can turn off the autocommit option and set manaul commit. what places I need to change inorder to work manual commit Thanks in Advance for your time 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ENUM Data Type
Hi, I have table called Media_table which has column Media_type. The data for Media type can be any of the "Movie","Trailer","Flash","Music" etc(almost fixed, not expected to change in near future,Or even if it changes also very minor updations very rarely). I thinking of two possibilities here 1. either to use the code table for the Media_type and join this table to Media_table(since its a Database standard) =20 2. use ENUM data type istead of code table. Performance is critical issue for the project. SO I am unable to decide which option should 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 Devi (Note:SQL/Query is used to bypass the filters) - 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto increment value in tables
Hi I need to insert the same auto increment value in 2 different tables simultaneously. I am new to the MySQL.Is there any function which helps for this type of manipulations? Or I need to store the value in host variable and update the tables with this host variable? Greatly appreciate you 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]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
