MySQL Load on server
Hello: We have multiple web sites hosted on a virtual web server. Many of the web sites are using MySQL databases. Recently we are having problems with the CPU load due to mysql processes. We are not able to track the corrupted database or script (PHP). There are many databases on the server. CPU Load on server CPU states: % user, % nice, % system, % interrupt, % idle Mem: 654M Active, 82M Inact, 142M Wired, 37M Cache, 112M Buf, 90M Free Swap: 1024M Total, 226M Used, 798M Free, 22% Inuse PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 28181 cyber001 50 0 32088K 7180K RUN 282:01 71.29% 71.29% mysqld Is there any way to track the processes on the MySQL databases? Please suggest a solution to fix this problem. Thank You. Regards Sheni R Meledath [EMAIL PROTECTED]
RE: MySQL Load on server
Dear Tom, Thank you very much. Is there a way to log all the processes on the MySQL server to analyze later. At 09:48 AM 1/5/2005, Tom Crimmins wrote: If I understand correctly, this is what you want: SHOW PROCESSLIST --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Sheni R. Meledath [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 04, 2005 11:40 PM To: MySQL Masters Subject: MySQL Load on server Hello: We have multiple web sites hosted on a virtual web server. Many of the web sites are using MySQL databases. Recently we are having problems with the CPU load due to mysql processes. We are not able to track the corrupted database or script (PHP). There are many databases on the server. CPU Load on server CPU states: % user, % nice, % system, % interrupt, % idle Mem: 654M Active, 82M Inact, 142M Wired, 37M Cache, 112M Buf, 90M Free Swap: 1024M Total, 226M Used, 798M Free, 22% Inuse PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 28181 cyber001 50 0 32088K 7180K RUN 282:01 71.29% 71.29% mysqld Is there any way to track the processes on the MySQL databases? Please suggest a solution to fix this problem. Thank You. Regards Sheni R Meledath [EMAIL PROTECTED] Regards Sheni R Meledath [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't install Mysql on Windows XP
Hello: I am trying to install mysql on my laptop which is running Windows XP professional. But after installation when trying to connect to the MySQL server I am getting the following error message: Error 2003: Can't connect to MySQL server on 'localhost' (10061). Tried all the options with my knowledge. No luck yet. Can anybody help me out. MySQL installation file/version - mysql4.0.20d-win Regards Sheni R Meledath Assistant Manager - Web Development * Cyber Gear LLC P.O. Box 53735 Dubai, United Arab Emirates Tel: (971 4) 331-2627, Fax: (971 4) 331-8812 Email: [EMAIL PROTECTED], http://www.cyber-gear.com VISIT OUR ASSOCIATE SITES: http://www.Click2Advertising.com http://www.DubaiCityGuide.com http://www.MiddleEastDirectory.com http://www.MiddleEastEvents.com http://www.MiddleEastPostBox.com http://www.PressReleaseNetwork.com * This message has been checked for all known viruses by McAfee. No liability is accepted by virtue of checking this message and you are recommended to have in place your own anti-virus detection procedures.
MySQL Server - automatic shutdown
Hello: We are using MySQL database on a FreeBSD server. The problem we are facing is sometimes the MySQL server is automatically shutting down. There is no error logged on the server. The entry in the log file mysite.com.err shows: 040525 21:52:37 /usr/local/mysql-3.23.49/libexec/mysqld: Normal shutdown This happened more than once in the last 2 months. Can anybody help me to fix this problem on the server. Sheni R Meledath [EMAIL PROTECTED]
MySQL Server - shutdown
Hello: We are using MySQL database on a FreeBSD server. The problem we are facing is sometimes the MySQL server is automatically shutting down. There is no error logged on the server. The entry in the log file mysite.com.err shows: 040213 11:28:59 /usr/local/mysql-3.23.49/libexec/mysqld: Normal shutdown 040213 11:29:04 /usr/local/mysql-3.23.49/libexec/mysqld: Shutdown Complete This happened more than once in the last 2 months. Can anybody help me to fix this problem on the server. Sheni R Meledath [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on Windows 2000
Hi, We have installed PHP/MySQL on a Windows 2000 server. PHP MySQL are working fine on the server. We also require to connect ASP to MySQL database. How can we do that? Currently the MySQL/ODBC driver is not available on Windows 2000 server. How can we add that and proceed with ASP/MySQL? Sheni R Meledath [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL - MS SQL
Hi, I have designed a site using PHP MySQL. Recently an urgent requirement has come up from the client side to change the web server to IIS. So I have to migrate the scripts and database to Windows based ASP MS SQL. Can any body provide me some details regarding migrating MySQL databases to MS SQL databases. It would be highly appreciated if you could send me the details at the earliest. Sheni R Meledath [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ISAMCHK utility - MySQL server - 3.21.33b
Hi, Many Thanks. I couldn't find out the isamchk utility on our server. I tried Telnet'ing to the server and typing the command. Its showing command not found. Could you please send me more details of this utility. Regards At 06:47 PM 5/16/02 +0200, you wrote: Hi. Well, what's the problem with using isamchk in detail? Shut down the mysql daemon, run isamchk on all tables to find out which are corrupted and run isamchk -r on those. Then restart mysqld. Do not forget to make backup copies of the tables in question beforehand, in case anything unexpected happens. You can get more information about your version of isamchk with isamchk --help. If you still have some problem, please describe in detail what you have tried and where you got stuck. Bye, Benjamin. On Thu, May 16, 2002 at 10:56:27AM +0400, [EMAIL PROTECTED] wrote: Hello: Can anybody help me out to repair my database tables using ISAMCHK utility. The MySQL server version is 3.21.33b installed on BSD server. Many thanks Sheni Details of the problem that we are facing now: We are facing a serious problem with the MySQL server installed on our web server (BSD/OS). The server was working fine till last week. Since then it started crashing. It crashes 2-3 times a day. Every time we have to kill the process and restart the server (UNIX). Not only the MySQL server the entire server crashes because of the load on the CPU. ###CPU STATE### load averages: 1.00, 1.00, 0.92 02:47:57 278 processes: 13 running, 265 sleeping CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M PID PRI NICE SIZE RESSTATE TIME WCPU CPUCOMMAND 270 94 44420K 2024K run43:48 97.17% 97.17% mysqld ## The MySQL version is 3.21.33b . Since its an old version I couldn't find out any information regarding the issue from the MySQL web site. We have got 4-5 MySQL databases on this server. [...] -- [EMAIL PROTECTED] Sheni R Meledath [EMAIL PROTECTED] - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ISAMCHK utility - MySQL server - 3.21.33b
Hello: Can anybody help me out to repair my database tables using ISAMCHK utility. The MySQL server version is 3.21.33b installed on BSD server. Many thanks Sheni Details of the problem that we are facing now: We are facing a serious problem with the MySQL server installed on our web server (BSD/OS). The server was working fine till last week. Since then it started crashing. It crashes 2-3 times a day. Every time we have to kill the process and restart the server (UNIX). Not only the MySQL server the entire server crashes because of the load on the CPU. ###CPU STATE### load averages: 1.00, 1.00, 0.92 02:47:57 278 processes: 13 running, 265 sleeping CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M PID PRI NICE SIZE RESSTATE TIME WCPU CPUCOMMAND 270 94 44420K 2024K run43:48 97.17% 97.17% mysqld ## The MySQL version is 3.21.33b . Since its an old version I couldn't find out any information regarding the issue from the MySQL web site. We have got 4-5 MySQL databases on this server. Could anybody help me out to solve this issue. Regards Sheni R Meledath [EMAIL PROTECTED] - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with MySQL server - 3.21.33b
Hello: We are facing a serious problem with the MySQL server installed on our web server (BSD/OS). The server was working fine till last week. Since then it started crashing. It crashes 2-3 times a day. Every time we have to kill the process and restart the server (UNIX). Not only the MySQL server the entire server crashes because of the load on the CPU. ###CPU STATE### load averages: 1.00, 1.00, 0.92 02:47:57 278 processes: 13 running, 265 sleeping CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M PID PRI NICE SIZE RESSTATE TIME WCPU CPUCOMMAND 270 94 44420K 2024K run43:48 97.17% 97.17% mysqld ## The MySQL version is 3.21.33b . Since its an old version I couldn't find out any information regarding the issue from the MySQL web site. We have got 4-5 MySQL databases on this server. Could anybody help me out to solve this issue. Regards Sheni R Meledath [EMAIL PROTECTED] - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with SELECT
Many Thanks for your quick reply. The MySQL version is 3.22 on Unix/FreeBSD/Apache. thanks At 08:43 AM 5/2/02 -0500, Gerald Clark wrote: Unfortunately, you did not tell us what version you are running, or what platform you are running it on. Try rebuilding the indexes with myisamchk or whatever is appropriate for your table type. Sheni R. Meledath wrote: Hello: I have a problem while selecting the records from a table. This table has got 15494 records. But when selecting its displaying only 1745 records. ### $result=mysql_query(SELECT COUNT(*) as numrows FROM $table2); $row=mysql_fetch_array($result); $num_rows2 = $row[numrows]; echo $num_rows2; =15494 $result=mysql_query(select * from $table2); $num_rows1=mysql_num_rows($result); echo $num_rows1; =1745 ### Using the second command I can't display all the records. But using separate select statement I can select display any record which is not displayed in the above case. ### $result=mysql_query(select * from $table2 where id='15000'); $row=mysql_fetch_array($result); echo $row[name]; =sheni ### Could you please help me to figure it out. Regards Sheni R Meledath [EMAIL PROTECTED] - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sheni R Meledath [EMAIL PROTECTED] - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Select a Random record
Dear MySQL masters, Is there any way to display a random record from a table. If there are no direct SQL commands can you pls suggest a logic for doing the same. Details: There is a table of 200 records. The user must be able to select a record randomly. Once that record is displayed then that record will not be available for the next query. (this I am planning to do with a flag field and adding this in the query statement). SELECT * from $table WHERE flag != 'TRUE'; I am using PHP to retrieve the records. so the PHP function mysql_fetch_array($query); should retrieve a random record, not a record in any particular order (ORDER BY). If anybody has got any suggestions on this please send it to me. thanks Sheni R Meledath [EMAIL PROTECTED] - 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
Random record from a table
Dear MySQL masters, Can I select a random record from a table. After doing a query on a table can i retrieve a record randomly. Is there a way in MySQL to achieve this. If, can you please send me details. thanks Sheni R Meledath [EMAIL PROTECTED] - 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