[urgent] - Problem with index_merge
Hello all, I have struck with a big problem with MySQL 5.0.22 server on RHEL 3. After an upgradation from MySQL 4.1.11 to MySQL 5.0.22 almost all the queries are struggling to execute and the DB server is clogged. Below is an example of what is happening. This query usd to execute very fast on MySQL 4.1.11 (in about less than 10 seconds). But on MySQL 5.0.22 it is taking an eternity. Running an EXPLAIN shows that an index_merge is being used as shown below in the EXPLAIN result. On MySQL 4.1.11 the the PRIMARY key was being used as the index as shown in the second query(The same query with FORCE index on PRIMARY). I am really confused as to why it is taking such a long time to execute when an index_merge is being used. As we can see that the number of row scans using index_merge is way too less when compared to the second query. Why is the first query so slow when compared to the second one even if the number of rows to be examined is too less in the former? Is this a bug in index_merge? And we have atleast 15 such queries always running on the system. The server is clogged !! Query with index_merge # Execution time : 53 seconds EXPLAIN SELECT SUM(1) AS ELE13, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 1, 1, 0 ) ) AS ELE14, SUM( IF( ( TFMM.FLD_ISSUE_CLOSED = 2 OR TFMM.FLD_ISSUE_CLOSED = 5 ) , 1, 0 ) ) AS ELE15, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 4, 1, 0 ) ) AS ELE16, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 3, 1, 0 ) ) AS ELE17, SUM( IF( TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE18, SUM( IF( TFMM.FLD_ISSUE_CLOSED != 3 AND TFMM.FLD_ASSIGNED_TO = 134 AND TFMM.FLD_USR_SEEN_FLAG = 0, 1, 0 ) ) AS ELE19, SUM( IF( ( TFMM.FLD_ISSUE_CLOSED = 2 OR TFMM.FLD_ISSUE_CLOSED = 5 ) AND TFMM.FLD_ASSIGNED_TO = 134 AND TFMM.FLD_USR_SEEN_FLAG = 1, 1, 0 ) ) AS ELE20, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 4 AND TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE21, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 3 AND TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE22 FROM TBL_FORUMS_MSG_MAIN TFMM WHERE TFMM.FLD_ACC_ID in (6) AND TFMM.FLD_PARENT_ID = 0 AND TFMM.FLD_MSG_ID 0 AND TFMM.FLD_MARK_AS_DELETED = 0 AND TFMM.FLD_BLOCK_STATE = 0 AND TFMM.FLD_BOUNCED_MAIL_FLAG = 0 AND TFMM.FLD_ESCALATED_FLAG = 0 AND TFMM.FLD_ADD_DATE_TIME = '2007-01-23 00:00:00' AND TFMM.FLD_ADD_DATE_TIME ='2007-01-23 23:59:00' ORDER BY TFMM.FLD_ADD_DATE_TIME ; - *** row 1 *** table: TFMM type: index_merge possible_keys: PRIMARY,FLD_PARENT_ID,FLD_ADD_DATE_TIME,FLD_MARK_AS_DELETED,FLD_ACC_ID,FLD_BLOCK_STATE,FLD_ESCALATED_FLAG,FLD_BOUNCED_MAIL_FLAG key: FLD_PARENT_ID,FLD_MARK_AS_DELETED,FLD_ACC_ID,FLD_BLOCK_STATE,FLD_ESCALATED_FLAG,FLD_BOUNCED_MAIL_FLAG key_len: 4,2,2,2,2,2 ref: NULL rows: 10170 Extra: Using intersect(FLD_PARENT_ID,FLD_MARK_AS_DELETED,FLD_ACC_ID,FLD_BLOCK_STATE,FLD_ESCALATED_FLAG,FLD_BOUNCED_MAIL_FLAG); Using where - Query with FORCE INDEX(PRIMARY) # Execution time : 13 seconds EXPLAIN SELECT SUM(1) AS ELE13, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 1, 1, 0 ) ) AS ELE14, SUM( IF( ( TFMM.FLD_ISSUE_CLOSED = 2 OR TFMM.FLD_ISSUE_CLOSED = 5 ) , 1, 0 ) ) AS ELE15, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 4, 1, 0 ) ) AS ELE16, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 3, 1, 0 ) ) AS ELE17, SUM( IF( TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE18, SUM( IF( TFMM.FLD_ISSUE_CLOSED != 3 AND TFMM.FLD_ASSIGNED_TO = 134 AND TFMM.FLD_USR_SEEN_FLAG = 0, 1, 0 ) ) AS ELE19, SUM( IF( ( TFMM.FLD_ISSUE_CLOSED = 2 OR TFMM.FLD_ISSUE_CLOSED = 5 ) AND TFMM.FLD_ASSIGNED_TO = 134 AND TFMM.FLD_USR_SEEN_FLAG = 1, 1, 0 ) ) AS ELE20, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 4 AND TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE21, SUM( IF( TFMM.FLD_ISSUE_CLOSED = 3 AND TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE22 FROM TBL_FORUMS_MSG_MAIN TFMM FORCE INDEX(PRIMARY) WHERE TFMM.FLD_ACC_ID in (6) AND TFMM.FLD_PARENT_ID = 0 AND TFMM.FLD_MSG_ID 0 AND TFMM.FLD_MARK_AS_DELETED = 0 AND TFMM.FLD_BLOCK_STATE = 0 AND TFMM.FLD_BOUNCED_MAIL_FLAG = 0 AND TFMM.FLD_ESCALATED_FLAG = 0 AND TFMM.FLD_ADD_DATE_TIME = '2007-01-23 00:00:00' AND TFMM.FLD_ADD_DATE_TIME ='2007-01-23 23:59:00' ORDER BY TFMM.FLD_ADD_DATE_TIME ;
[Solved] Urgent problem
It was just to copy the files from the DATA folder in the installation directory. That was easier then I thought. -Original Message- From: Peter Lauri [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 6:52 AM To: mysql@lists.mysql.com Subject: Urgent problem Best group member, My computer stopped working. And I was able to install Windows on another partition and now I face one problem. I was running Windows with MySQL 4.1. I have all C: working, and can access all files. The first question: Can I recover that data from MySQL? The second question: How can I do that? (All attempts to repair Windows has failed, so that option is gone) I have gone thru the manual but all information there seems to be related to if the database crashes. And some options are there when you do make backups, but I do not have the backups. A desperate soul... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent problem
Hi! Peter == Peter Lauri [EMAIL PROTECTED] writes: Peter Best group member, Peter My computer stopped working. And I was able to install Windows on another Peter partition and now I face one problem. I was running Windows with MySQL 4.1. Peter I have all C: working, and can access all files. Peter The first question: Can I recover that data from MySQL? Peter The second question: How can I do that? (All attempts to repair Windows has Peter failed, so that option is gone) Peter I have gone thru the manual but all information there seems to be related to Peter if the database crashes. And some options are there when you do make Peter backups, but I do not have the backups. Peter A desperate soul... In principle you can just copy the tables from one partition/computer to another and start using them. (The MySQL version doesn't have to exactly the same, as long as the new one is newer than the old one). To fix this: - Install MySQL on your new partition (computer) - Copy all files in the MySQL data directory (normally C:\mysql\data) to your new partition. If the path is different, you may have to create a my.cnf file that includes the --basedir and --datadir options to your new path. - Restart MySQL. - Check/repair your tables by using from the command line: C:\mysql\bin\mysqlcheck --all-databases --auto-repair Regards, Monty CTO of MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent problem
Best group member, My computer stopped working. And I was able to install Windows on another partition and now I face one problem. I was running Windows with MySQL 4.1. I have all C: working, and can access all files. The first question: Can I recover that data from MySQL? The second question: How can I do that? (All attempts to repair Windows has failed, so that option is gone) I have gone thru the manual but all information there seems to be related to if the database crashes. And some options are there when you do make backups, but I do not have the backups. A desperate soul... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent problem
Hi I did something stupid: I locked myself out of the MySQL server... My problem: I use MySQLFront to change the allowed hosts and did it for all users. They were 'localhost' and I set them to 'localhost; EcolMod1' where the EcolMod1 is the name of my computer where the MySQL server is installed on. After these changes, I couldn't log on any more. Windows 2000, MySQL 4.012. Any help welcome what I could do to access the data again, Rainer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent problem
Hi I did something very stupid: I locked myself out of the MySQL server (all accounts, incl administrator)... My problem: I use MySQLFront to change the allowed hosts and did it for all users. They were 'localhost' and I set them to 'localhost; EcolMod1' where the EcolMod1 is the name of my computer where the MySQL server is installed on. After these changes, I couldn't log on any more. Windows 2000, MySQL 4.012. Any help welcome what I could do to access the data again, Rainer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Urgent problem
I did something very stupid: I locked myself out of the MySQL server (all accounts, incl administrator)... My problem: I use MySQLFront to change the allowed hosts and did it for all users. They were 'localhost' and I set them to 'localhost; EcolMod1' where the EcolMod1 is the name of my computer where the MySQL server is installed on. After these changes, I couldn't log on any more. Windows 2000, MySQL 4.012. Any help welcome what I could do to access the data again, One mail should be enough in most cases! You may try to edit your host.mid file in \mysql-dir\data\mysql. Make a backup of that file before you start and use a hex-editor for doing so. The first chars in there should look like ÿlocalhost; EcolMod1. Simply overwrite (not erase) what you don't need with spaces (20 hex). You need to restart mysql to apply changes made. Regards, TomH -- PROSOFT EDV-Lösungen GmbH Co. KG Ladehofstraße 28, D-93049 Regensburg Geschäftsführer: Axel-Wilhelm Wegmann AG Regensburg HRA 6608 USt.183/68311 www : http://www.proSoft-Edv.de email: [EMAIL PROTECTED] phone: +49 941 / 78 88 7 - 121 fax : +49 941 / 78 88 7 - 20 cellphone: +49 174 / 41 94 97 0 -- -Original Message- From: Rainer M. Krug [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:03 AM To: [EMAIL PROTECTED] Subject: Urgent problem Hi Rainer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql-list@ 7thweb.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Urgent problem
restart mysql with the skip-grants option -Original Message- From: Rainer M. Krug [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 3:03 AM To: [EMAIL PROTECTED] Subject: Urgent problem Hi I did something very stupid: I locked myself out of the MySQL server (all accounts, incl administrator)... My problem: I use MySQLFront to change the allowed hosts and did it for all users. They were 'localhost' and I set them to 'localhost; EcolMod1' where the EcolMod1 is the name of my computer where the MySQL server is installed on. After these changes, I couldn't log on any more. Windows 2000, MySQL 4.012. Any help welcome what I could do to access the data again, Rainer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Neither of these two machines send the request. I have 12 webservers, which send the requests. I have 5 database servers, 1 master(for updates/inserts/deletes) and 4 slaves(for selects). Machine A below was the current Master DB server, however it is old and was being replaced by machine B -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin [EMAIL PROTECTED]: Hi Keith, soory now I got confused. Which machine is sending the requests (client) and which machine is the mysql server (server). Do you use php or something like this (webinterface) on the client ? If yes, than my suggestions below apply. If no than I we will have to think the next step. Best regards Nils Valentin Tokyo/Japan 2003年 6月 27日 金曜日 11:29、Keith Bussey さんは書きました: Ok but that's not what I meant. I'll try to explain better. Machine A: IP = 192.168.1.71 Machine B: IP = 192.168.1.79 1) Scripts goto 192.168.1.71 - Everything is OK 2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up until server is killed 3) Halt machine B 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs) 5) Problem persists even though it's a different machine, site works but then processes pile up and kill machine 6) Change scripts to use 192.168.1.71 again 7) Site works fine What I don't get is why do processes run normally with IP 192.168.1.71, but NOT with IP 192.168.1.79 even when they are on the same machine ? -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin [EMAIL PROTECTED]: Hi Keith, The wrong IP address could only avoid a client to connect to the database server. If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in config.inc.php or which ever tool you use than of course it will try to connect to this IP address. Best regards Nils Valentin Tokto/Japan 2003å¹´ 6æ 27æ¥ éææ¥ 11:02ãKeith Bussey ããã¯æ¸ãã¾ãã: Hrmmmeaning if I do id mysql, that information (group etc..) ? I've halted that server and moved everything back to my original server for now, I had too much downtime. I did notice something else interesting though: The old mahcine's IP is 192.168.1.71 New machine's IP is 192.168.1.79 Now that it's halted, instead of changing the IP back to .71 in my pages/scripts I added .79 to the .71 machine so it has both Now that machine experienced the exact same problem. Switching my code to use .71 again however, and no problems. Could somehow there be a problem with the IP address 192.168.1.79?? It seems very strange, however tomorrow I will try putting the .71 on the new machine and see if it works or not -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
When you said you modified the scripts, are these the scripts on the 12 webservers (mysql clients) ? If not, then these mysql clients (webservers) would still be wanting to send to IP addres 192.168.1.71 as configured for php or in your client. Best regards Nils Valentin Tokyo/Japan 2003 6 27 14:58Keith Bussey : Neither of these two machines send the request. I have 12 webservers, which send the requests. I have 5 database servers, 1 master(for updates/inserts/deletes) and 4 slaves(for selects). Machine A below was the current Master DB server, however it is old and was being replaced by machine B -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin [EMAIL PROTECTED]: Hi Keith, soory now I got confused. Which machine is sending the requests (client) and which machine is the mysql server (server). Do you use php or something like this (webinterface) on the client ? If yes, than my suggestions below apply. If no than I we will have to think the next step. Best regards Nils Valentin Tokyo/Japan 2003 6 27 11:29Keith Bussey : Ok but that's not what I meant. I'll try to explain better. Machine A: IP = 192.168.1.71 Machine B: IP = 192.168.1.79 1) Scripts goto 192.168.1.71 - Everything is OK 2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up until server is killed 3) Halt machine B 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs) 5) Problem persists even though it's a different machine, site works but then processes pile up and kill machine 6) Change scripts to use 192.168.1.71 again 7) Site works fine What I don't get is why do processes run normally with IP 192.168.1.71, but NOT with IP 192.168.1.79 even when they are on the same machine ? -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin [EMAIL PROTECTED]: Hi Keith, The wrong IP address could only avoid a client to connect to the database server. If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in config.inc.php or which ever tool you use than of course it will try to connect to this IP address. Best regards Nils Valentin Tokto/Japan 2003 6 27 11:02Keith Bussey : Hrmmmeaning if I do id mysql, that information (group etc..) ? I've halted that server and moved everything back to my original server for now, I had too much downtime. I did notice something else interesting though: The old mahcine's IP is 192.168.1.71 New machine's IP is 192.168.1.79 Now that it's halted, instead of changing the IP back to .71 in my pages/scripts I added .79 to the .71 machine so it has both Now that machine experienced the exact same problem. Switching my code to use .71 again however, and no problems. Could somehow there be a problem with the IP address 192.168.1.79?? It seems very strange, however tomorrow I will try putting the .71 on the new machine and see if it works or not -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Hi Keith, from your last e-mail I understand now finally that we are talking about replication here. Would have been a short cut to mention it in your first e-mail. The failed login attempts couldn't be from your slaves trying to login, but you havent set them up on the master yet ? Just a guess, so. 2003 6 27 09:05Keith Bussey : | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | | login NULL | | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | | login NULL | | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | | login NULL | | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | | login NULL Best regards Nils Valentin Tokyo/Japan -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
If it is the replication problem...:: Check the replication account on the master server: ...[EMAIL PROTECTED] identified by ... ...[EMAIL PROTECTED] identified by ... ...[EMAIL PROTECTED] identified by ... ... ...[EMAIL PROTECTED] identified by ... or perhaps simply set to ...replication_account@% identified by ... make sure the account has access to the specified db.tables, too. Me fail English? That's unpossible ###___Archon___### - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Keith Bussey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 27, 2003 1:30 PM Subject: Re: URGENT problem with mysql processes Hi Keith, from your last e-mail I understand now finally that we are talking about replication here. Would have been a short cut to mention it in your first e-mail. The failed login attempts couldn't be from your slaves trying to login, but you havent set them up on the master yet ? Just a guess, so. 2003 6 27 09:05Keith Bussey : | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | | login NULL | | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | | login NULL | | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | | login NULL | | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | | login NULL Best regards Nils Valentin Tokyo/Japan -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
No, the slaves replicate fine and I can see their entries in the processlist normally (as their hostname), not as unauthenticated user.. -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin [EMAIL PROTECTED]: Hi Keith, from your last e-mail I understand now finally that we are talking about replication here. Would have been a short cut to mention it in your first e-mail. The failed login attempts couldn't be from your slaves trying to login, but you havent set them up on the master yet ? Just a guess, so. 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました: | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | | login NULL | | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | | login NULL | | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | | login NULL | | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | | login NULL Best regards Nils Valentin Tokyo/Japan -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
No, replication is fine I can see those processes as they should be. The problem processes all come from the webservers' requests. -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Dominicus Donny [EMAIL PROTECTED]: If it is the replication problem...:: Check the replication account on the master server: ...[EMAIL PROTECTED] identified by ... ...[EMAIL PROTECTED] identified by ... ...[EMAIL PROTECTED] identified by ... ... ...[EMAIL PROTECTED] identified by ... or perhaps simply set to ...replication_account@% identified by ... make sure the account has access to the specified db.tables, too. Me fail English? That's unpossible ###___Archon___### - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Keith Bussey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 27, 2003 1:30 PM Subject: Re: URGENT problem with mysql processes Hi Keith, from your last e-mail I understand now finally that we are talking about replication here. Would have been a short cut to mention it in your first e-mail. The failed login attempts couldn't be from your slaves trying to login, but you havent set them up on the master yet ? Just a guess, so. 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました: | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | | login NULL | | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | | login NULL | | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | | login NULL | | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | | login NULL Best regards Nils Valentin Tokyo/Japan -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Quoting Nils Valentin [EMAIL PROTECTED]: When you said you modified the scripts, are these the scripts on the 12 webservers (mysql clients) ? Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12 webservers If not, then these mysql clients (webservers) would still be wanting to send to IP addres 192.168.1.71 as configured for php or in your client. Best regards Nils Valentin Tokyo/Japan 2003年 6月 27日 金曜日 14:58、Keith Bussey さんは書きました: Neither of these two machines send the request. I have 12 webservers, which send the requests. I have 5 database servers, 1 master(for updates/inserts/deletes) and 4 slaves(for selects). Machine A below was the current Master DB server, however it is old and was being replaced by machine B -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin [EMAIL PROTECTED]: Hi Keith, soory now I got confused. Which machine is sending the requests (client) and which machine is the mysql server (server). Do you use php or something like this (webinterface) on the client ? If yes, than my suggestions below apply. If no than I we will have to think the next step. Best regards Nils Valentin Tokyo/Japan 2003å¹´ 6æ 27æ¥ éææ¥ 11:29ãKeith Bussey ããã¯æ¸ãã¾ãã: Ok but that's not what I meant. I'll try to explain better. Machine A: IP = 192.168.1.71 Machine B: IP = 192.168.1.79 1) Scripts goto 192.168.1.71 - Everything is OK 2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up until server is killed 3) Halt machine B 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs) 5) Problem persists even though it's a different machine, site works but then processes pile up and kill machine 6) Change scripts to use 192.168.1.71 again 7) Site works fine What I don't get is why do processes run normally with IP 192.168.1.71, but NOT with IP 192.168.1.79 even when they are on the same machine ? -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin [EMAIL PROTECTED]: Hi Keith, The wrong IP address could only avoid a client to connect to the database server. If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in config.inc.php or which ever tool you use than of course it will try to connect to this IP address. Best regards Nils Valentin Tokto/Japan 2003å¹´ 6æ 27æÂÂ¥ éÂÂæÂÂæÂÂ¥ 11:02ãÂÂKeith Bussey ãÂÂãÂÂã¯æ¸ãÂÂã¾ãÂÂãÂÂ: Hrmmmeaning if I do id mysql, that information (group etc..) ? I've halted that server and moved everything back to my original server for now, I had too much downtime. I did notice something else interesting though: The old mahcine's IP is 192.168.1.71 New machine's IP is 192.168.1.79 Now that it's halted, instead of changing the IP back to .71 in my pages/scripts I added .79 to the .71 machine so it has both Now that machine experienced the exact same problem. Switching my code to use .71 again however, and no problems. Could somehow there be a problem with the IP address 192.168.1.79?? It seems very strange, however tomorrow I will try putting the .71 on the new machine and see if it works or not -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
URGENT problem with mysql processes
Major problem! I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is - quad-xeon (500mhz each cpu) - 3 gig RAM - Linux Redhat 7.3 When I start up mysql, processes looking like the following begin to pile up until it kills the server: | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | login | NULL | | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | login | NULL | | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | login | NULL | | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | login | NULL | I need to fix this immediately as my site cannot run ! Thanks in advance. I've seen this exact same situation happen to others (posted on various boards), however never saw any solutions ;/ -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Hi Keith, The wrong IP address could only avoid a client to connect to the database server. If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in config.inc.php or which ever tool you use than of course it will try to connect to this IP address. Best regards Nils Valentin Tokto/Japan 2003 6 27 11:02Keith Bussey : Hrmmmeaning if I do id mysql, that information (group etc..) ? I've halted that server and moved everything back to my original server for now, I had too much downtime. I did notice something else interesting though: The old mahcine's IP is 192.168.1.71 New machine's IP is 192.168.1.79 Now that it's halted, instead of changing the IP back to .71 in my pages/scripts I added .79 to the .71 machine so it has both Now that machine experienced the exact same problem. Switching my code to use .71 again however, and no problems. Could somehow there be a problem with the IP address 192.168.1.79?? It seems very strange, however tomorrow I will try putting the .71 on the new machine and see if it works or not -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: Fwd: urgent: problem in deleting multi table
Thank you for your fine bug report, thanks to which, I was able to fix a problem. Final fix will come up in 4.0.3, but this is a patch that fixes it temporarily : = /mnt/work/mysql-4.0/sql/sql_delete.cc 1.80 vs edited = *** /tmp/sql_delete.cc-1.80-1656Tue Jul 23 18:31:17 2002 --- edited//mnt/work/mysql-4.0/sql/sql_delete.ccMon Jul 29 15:26:47 2002 *** *** 227,233 table-used_keys=0; tempfiles[counter] = new Unique (refposcmp2, (void *) table-file-ref_length, !table-file-ref_length, MEM_STRIP_BUF_SIZE); } } --- 227,233 table-used_keys=0; tempfiles[counter] = new Unique (refposcmp2, (void *) table-file-ref_length, !table-file-ref_length + 1, MEM_STRIP_BUF_SIZE); } } -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
urgent: problem in deleting multi table
Hello, I'm working on a purge utility to purge 3 tables: call_record, modem_call_rec and makrup. Those 3 tables are related with foreign key recid, so I used the following sql to purge data that is older than 30 days: delete call_record, modem_call_rec, markup from call_record, modem_call_rec, markup where to_days(now())-to_days(call_record.setup)=30, and call_record.recid=modem_call_rec.recid and call_record.recid=markup.recid; The result is, it works well with limited number of records. But when the number of records increases, for example to 500 records per table, call_record table is purged correctly, but the other two tables (modem_call_rec and markup) are not purged at all. The mysql manual mentioned that delete may not work when deleting tables with correlated columns. Is that the reason why the above query does not work? In my case, I may have 1.5 million records in each table. Could you give me some suggestions regarding how to perform delete in those 3 tables with that many data? Thanks Minjie - 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
URGENT - problem in inserting single quote
I am inserting into the table values with single Quote (MySql table). If I give the command through text file - Insert into test values ('manisha\' test') - then this is ok, but when i try to insert the manisha ' test value through http://hostname/sqladmin using GUI then MySql is giving error. Any help regarding this ? Any body knows how to stop and start the MySql service ? - 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
urgent problem with mysql and phpmyadmin
Andrew, Thursday, February 21, 2002, 3:31:16 AM, you wrote: AB I have created a table in the mysql db, using phpmyadmin with the following AB statement: AB create table books AB ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary AB key(isbn)); AB which works fine and creates the table i need the problem comes when i try AB to insert some values into the price column using the phpmyadmin form, if AB for example i try to enter the price 34.99 it will only allow me to enter AB 34.9, and then when i go to the browse feature it shows the value as 34.90 AB any ideas on what's going wrong??? I have tested it and it worked fine. What version of MySQL do you use? AB any help would be much apprecited. AB thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
urgent problem with mysql and phpmyadmin
I have created a table in the mysql db, using phpmyadmin with the following statement: create table books ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary key(isbn)); which works fine and creates the table i need the problem comes when i try to insert some values into the price column using the phpmyadmin form, if for example i try to enter the price 34.99 it will only allow me to enter 34.9, and then when i go to the browse feature it shows the value as 34.90 any ideas on what's going wrong??? any help would be much apprecited. thanks - 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
RE: urgent problem with mysql and phpmyadmin
My guess. . . I have seen this problem with other databases . . . don't know if it is true for MySQL as well. Try to change to your field definition to float(5,2) as it may be counting the (.) as part of your field size. So if you number is xx.xx you will need 5,2. 4,2 would give you xx.x David McInnis -Original Message- From: Andrew Bunkell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 5:31 PM To: [EMAIL PROTECTED] Subject: urgent problem with mysql and phpmyadmin I have created a table in the mysql db, using phpmyadmin with the following statement: create table books ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary key(isbn)); which works fine and creates the table i need the problem comes when i try to insert some values into the price column using the phpmyadmin form, if for example i try to enter the price 34.99 it will only allow me to enter 34.9, and then when i go to the browse feature it shows the value as 34.90 any ideas on what's going wrong??? any help would be much apprecited. thanks - 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
urgent : Problem in Group by clause
hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i need to use group by in select statement.. i want to display the details in the web page ... say there are 3 records as below against each field: 1. 'a.jpg','test','david','john','2002-02-14' 2. 'b.bmp','bmp file','richard','mary','2002-02-14' 3. 'c.htm','web','david','mary','2002-02-15' now i want to display the details grouped by Designer (the third field). when i use the following query: select FileName,Title,Designer,UploadedBy,SubmittedDate From UploadDetails Group By Designer i get only one row... why? can anyone solve this problem... thanks in advance Shankar __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - 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
urgent : Problem in Group by clause
hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i need to use group by in select statement.. i want to display the details in the web page ... say there are 3 records as below against each field: 1. 'a.jpg','test','david','john','2002-02-14' 2. 'b.bmp','bmp file','richard','mary','2002-02-14' 3. 'c.htm','web','david','mary','2002-02-15' now i want to display the details grouped by Designer (the third field). when i use the following query: select FileName,Title,Designer,UploadedBy,SubmittedDate From UploadDetails Group By Designer i get only one row... why? can anyone solve this problem... thanks in advance Shankar __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - 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
Re: urgent : Problem in Group by clause
Hi Shankar, This is your old buddy Scott S. Try order by rather than group byThis will get you what you are looking for Scott Salisbury - Original Message - From: SankaraNarayanan Mahadevan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 16, 2002 3:42 PM Subject: urgent : Problem in Group by clause hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i need to use group by in select statement.. i want to display the details in the web page ... say there are 3 records as below against each field: 1. 'a.jpg','test','david','john','2002-02-14' 2. 'b.bmp','bmp file','richard','mary','2002-02-14' 3. 'c.htm','web','david','mary','2002-02-15' now i want to display the details grouped by Designer (the third field). when i use the following query: select FileName,Title,Designer,UploadedBy,SubmittedDate From UploadDetails Group By Designer i get only one row... why? can anyone solve this problem... thanks in advance Shankar __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - 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
Re: Urgent problem : recovering a table with no MYI file ?
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote: Hi, I'm administrating a machine which has just badly crashed, and a MYI file has disappeared for one table. Is this possible to repair this table? Try to touch the file (to create an empty one), and see if that is sufficient to get MySQL doing what it should. Don't know if it will help, but you never know. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 28 days, processed 213,616,674 queries (88/sec. avg) - 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
MySQL on NetApp Filer - Urgent Problem
Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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
Re: MySQL on NetApp Filer - Urgent Problem
Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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 i forgot: nfs ops and network traffic for the filer stayed the same Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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
Re: MySQL on NetApp Filer - Urgent Problem
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: *This message was transferred with a trial version of CommuniGate(tm) Pro* On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? i forgot: nfs ops and network traffic for the filer stayed the same Then it would seem to be a problem with the netapp, wouldn't it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 Jeremy, Finally you where right. I refused to believe it but the filer itself was the problem. it was running out of inodes. damn, sorry for bothering you Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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