Lost InnoDB Data

if we go back to backups which are not entirerly new but later than jan 31. I have no idea what's causing this, and I have absolutely no clue what to do about it. Any suggestions? We're running MySQL 4.0.21 on Red Hat. Any help with this would be greatly appreciated! Best regards,

Re: max_user_connections problem after upgrading

hat I think is happening is the connections are not properly getting >> closed. The users are allowed to connect after a "flush > user_resources" >> is run. Is there a bug in the particular version of MySQL (4.0.12) >> where the "user connections" are not ge

Re: max_user_connections problem after upgrading

uot;flush user_resources" >> is run. Is there a bug in the particular version of MySQL (4.0.12) >> where the "user connections" are not getting decremented when a >> connection is "closed"? >> >> Joe >> >> Henrik Skotth wrote: >> >

Re: max_user_connections problem after upgrading

ws a ton of idle connections, it should tell you > which machines they are coming from and which users, and that should > help you track down who's holding connections open. > > --Pete > > > On Wed, Nov 12, 2003 at 01:15:54AM +0100, Henrik Skotth wrote: >&g

RE: max_user_connections problem after upgrading

ou double > check > that there really aren't any open connections to the server. > > Thanks, > > Mike > >> -Original Message- >> From: Henrik Skotth [mailto:[EMAIL PROTECTED] >> Sent: 10 November 2003 18:54 >> To: [EMAIL PROTECTED] >> Subject

Re: max_user_connections problem after upgrading

gerald_clark skrev: > Are you sure you are net exceeding the setting for > maximum connections per hour for that user? > > Henrik Skotth wrote: > >>Hi! >> >>What I meant was that even if there are currently only two user >>connections being used

Re: max_user_connections problem after upgrading

Hi! What I meant was that even if there are currently only two user connections being used, and the limit is 300, we still get the "already more than max_user_connections" error... -- Henrik gerald_clark skrev: > > > Henrik Skotth wrote: > >>Hello all, >> >

max_user_connections problem after upgrading

or two active connections and our max_user_connections is 300. I have to take down and restart the server to solve the problem, and it keeps happening over and over again every few days... Am I the only one having this problem? Any suggestions? Regards, -- Henrik Skotth, Hogwarts.nu -- MySQL

Mysql 4 problem, more than max_user_connections

there is already more than max_user_connections, but there is really only one or two active connections and our max_user_connections is 300. I have to take down and restart the server to solve the problem. Does anyone know of any solution to this? Regards, -- Henrik Skotth -- MySQL General