MySQL error
We are running MySQL 5.0.45 on a Linux machine. Today, when I tried to go into MySQL via the command line, I got an error message: Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' The error log was full of the following messages: InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. We stopped MySQL and started it again and everything seems to be working. However, we would like to understand what happened. The strange thing here is that we are not using InnoDB tables so we don't understand why we are getting InnoDB errors and what it is trying to do with the ibdata1 file. We do have an ibdata1 file and ib_logfile files. Could it be that we are using InnoDB tables and we don't realize it? Could we have made a mistake somewhere? Is there a way to check this? Can we erase these files? Any help will be appreciated. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: malki.cymbali...@weizmann.ac.il -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: MySQL error
If you do not want to use InnoDB at all, add this line to /etc/my.cnf under the [mysqld] section skip_innodb Then do the following service mysql stop rm -f /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile[01] service mysql start This will totally and cleanly disable InnoDB on the DB server Give it a try !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: malki.cymbali...@weizmann.ac.il [mailto:malki.cymbali...@weizmann.ac.il] Sent: Monday, June 08, 2009 10:02 AM To: mysql@lists.mysql.com Cc: shlomit.af...@weizmann.ac.il Subject: MySQL error We are running MySQL 5.0.45 on a Linux machine. Today, when I tried to go into MySQL via the command line, I got an error message: Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' The error log was full of the following messages: InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. We stopped MySQL and started it again and everything seems to be working. However, we would like to understand what happened. The strange thing here is that we are not using InnoDB tables so we don't understand why we are getting InnoDB errors and what it is trying to do with the ibdata1 file. We do have an ibdata1 file and ib_logfile files. Could it be that we are using InnoDB tables and we don't realize it? Could we have made a mistake somewhere? Is there a way to check this? Can we erase these files? Any help will be appreciated. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: malki.cymbali...@weizmann.ac.il -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
slow connection from localhost
hi, I need some urgent help. We have encountered a problem, when we try to connect in shell with a mysql client to the mysqld (via socket or via localhost). The connection takes 5 to 50 seconds, or it happens that the connection is fast, but then the use somethingdb; needs 5 to 50 seconds. We have tried to use some advice from here already: http://www.debianhelp.co.uk/mysqlperformance.htm We tried to use mysqltuner.pl, which is an optimizing tool. Here we set Maximum possible memory usage:, in fact the real memory usage is few megas only. The other problem, which we found out in mysqlreport.txt, that if we set Max used to any number, sooner or later it gets full and that is why the Maximum possible memory usage: is huge in the mysqltuner.txt. okay, so I can attach the mysql config currently used and the mysqlreport.txt and mysqltuner.txt. The problem comes when the load increases during the weekend. However, this load is still not huge, around 200 connections at a time. Hope someone can help us with some good advice. Thank you in advance, Viktor brDr. Csernus Imre: A férfi - Rendelje meg 20% kedvezménnyel!brhttp://bookline.hu/product/home!execute.action?tabname=konyvtype=22_v=Dr_Csernus_Imre_A_ferfiid=80504tabname=bookaffiliate=frejkakar8779 r...@sun:~# mysqlreport MySQL 5.0.32-Debian_7et uptime 0 1:2:8 Sun Jun 7 20:10:51 2009 __ Key _ Buffer used 5.86M of 512.00M %Used: 1.14 Current 99.22M%Usage: 19.38 Write ratio 0.45 Read ratio 0.00 __ Questions ___ Total 230.79k 61.91/s Slow 7230.19/s %Total: 0.31 %DMS: 2.39 DMS30.20k8.10/s 13.09 __ Table Locks _ Waited 9.18k2.46/s %Total: 30.23 Immediate 21.18k5.68/s __ Tables __ Open 577 of 1024%Cache: 56.35 Opened6950.19/s __ Connections _ Max used 1227 of 2400 %Max: 51.12 Total 41.03k 11.01/s __ Created Temp Disk table 00.00/s Table 560.02/s File00.00/s r...@sun:~# ./mysqltuner.pl MySQLTuner 1.0.0 - Major Hayden ma...@mhtx.net Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with '--help' for additional options and output filtering General Statistics -- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.0.32-Debian_7etch10-log [OK] Operating on 64-bit architecture Storage Engine Statistics --- [--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 22M (Tables: 9) [OK] Total fragmented tables: 0 Performance Metrics - [--] Up for: 1h 3m 4s (231K q [61.137 qps], 41K conn, TX: 184M, RX: 24M) [--] Reads / Writes: 98% / 2% [--] Total buffers: 602.0M global + 24.4M per thread (2400 max threads) [!!] Maximum possible memory usage: 57.7G (367% of installed RAM) [OK] Slow queries: 0% (733/231K) [OK] Highest usage of available connections: 51% (1242/2400) [OK] Key buffer size / total MyISAM indexes: 512.0M/8.6M [OK] Key buffer hit rate: 99.7% (1M cached / 6K reads) [OK] Query cache efficiency: 84.0% (159K cached / 189K selects) [OK] Query cache prunes per day: 0 [OK] Temporary tables created on disk: 0% (0 on disk / 59 total) [OK] Thread cache hit rate: 84% (6K created / 41K connections) [OK] Table cache hit rate: 83% (577 open / 695 opened) [OK] Open file limit used: 5% (605/12K) [!!] Table locks acquired immediately: 70% Recommendations - General recommendations: MySQL started within last 24 hours - recommendations may be inaccurate Reduce your overall MySQL memory footprint for system stability Enable the slow query log to troubleshoot bad queries Optimize queries and/or use InnoDB to reduce lock wait -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL University session on June 11: The New MySQL Release Model
The New MySQL Release Model http://forge.mysql.com/wiki/The_New_MySQL_Release_Model This Thursday (June 11th, 14:00 UTC), Tomas Ulin will give a MySQL University session on The New MySQL Release Model. Tomas is the MySQL Server Director, and will explain the new MySQL release model which has just recently been announced. For MySQL University sessions, point your browser to this page: http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session. Here's the schedule for the upcoming weeks: # June 18, 2009: No session scheduled # June 25, 2009: MySQL code contributions (Lenz Grimmer) # July 2: Starring Sakila - a data warehouse mini-tutorial (Roland Bouman) # July 9 through September 3: Semester break The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones. Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: stefan.h...@sun.com Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: slow connection from localhost
Did you try --skip-name-resolve ? Not sure if you are using any sort of caching, but memcahced may be a solution to mitigate some of the load for reads. 2009/6/8 Jancsok Akos jak...@freemail.hu hi, I need some urgent help. We have encountered a problem, when we try to connect in shell with a mysql client to the mysqld (via socket or via localhost). The connection takes 5 to 50 seconds, or it happens that the connection is fast, but then the use somethingdb; needs 5 to 50 seconds. We have tried to use some advice from here already: http://www.debianhelp.co.uk/mysqlperformance.htm We tried to use mysqltuner.pl, which is an optimizing tool. Here we set Maximum possible memory usage:, in fact the real memory usage is few megas only. The other problem, which we found out in mysqlreport.txt, that if we set Max used to any number, sooner or later it gets full and that is why the Maximum possible memory usage: is huge in the mysqltuner.txt. okay, so I can attach the mysql config currently used and the mysqlreport.txt and mysqltuner.txt. The problem comes when the load increases during the weekend. However, this load is still not huge, around 200 connections at a time. Hope someone can help us with some good advice. Thank you in advance, Viktor Dr. Csernus Imre: A férfi - Rendelje meg 20% kedvezménnyel! http://bookline.hu/product/home%21execute.action?tabname=konyvtype=22_v=Dr_Csernus_Imre_A_ferfiid=80504tabname=bookaffiliate=frejkakar8779 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=rstei...@gmail.com