Re: /var/log/mysql is taking up a lot of diskspace

2009-01-30 Thread Bazooka Joe
On Fri, Jan 30, 2009 at 8:13 PM, will will.va...@gmail.com wrote:
 ok, cool. I was not sure if I could use logrotate with the mysql logs.
 Is it safe to delete what I have there at the moment? I need to free
 up some disk space.


this is what logrotate run before and after

[ -e /var/lock/subsys/mysqld ]  /bin/kill -HUP `cat
/var/run/mysqld/mysqld.pid  2 /dev/null ` || /bin/true

Assuming paths are the same I would run the above commands. Short of
that I would take down mysql, delete log, then bring mysql back up.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



OO base - jdbc - mysql timeout problem

2008-12-03 Thread Bazooka Joe
I am trying to develop an db app w/ OO base as the front end to mysql
db that is running on the web in a shared hosting environment using
jdbc as the connector.

The problem is if I let OO base sit for a few minutes it looses the
connection to the db and I have to restart OO base to get it to
reconnect.

Not only is this a major pain but if I can't fix it I can't expect my
client to constantly be restarting the OO base.

All I have found on the web is to increase the interactive timeout but
it is at 28,800 now. So that isn't it.

Any ideas?

I am using:
OO v3 on windows
jdbc v5.1.7
mysqld v5.0.45

-bazooka

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]