Access speed INNODB VS. MyISAM

I have been using a database for several years that uses many 'lookup' style tables. i.e. no updates to these tables. I dumped the whole thing into an INNODB database for simplicity, but I now wonder if I can speed things up if I put only my updatable tables in INNODB (I need row level locking for

RE: Automatically add +1 every 30mins

Kudos! I read a lot of replies to various threads hoping to learn something, and this thread was a double bonus. Never new of the 'events' feature either. But I think this solution below is very elegant and is one of those "so obvious it makes me feel retarded" answers. ;-) Personally, I would

RE: Can I delete old -bin.xxxxx files in order to free up some space?

Thank you Raymond that did the trick. -Original Message- From: Gary Richardson [mailto:[EMAIL PROTECTED] Sent: Saturday, June 03, 2006 14:39 To: Jacob, Raymond A Jr Cc: mysql@lists.mysql.com Subject: Re: Can I delete old -bin.x files in order to free up some space? I believe the co

Re: Can I delete old -bin.xxxxx files in order to free up some space?

I believe the command is PURGE LOGS or something like that. On 6/3/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote: -Original Message- From: Gary Richardson [mailto:[EMAIL PROTECTED] Sent: Saturday, June 03, 2006 14:10 To: Jacob, Raymond A Jr Cc: mysql@lists.mysql.com Subject: Re: Ca

RE: Can I delete old -bin.xxxxx files in order to free up some space?

-Original Message- From: Gary Richardson [mailto:[EMAIL PROTECTED] Sent: Saturday, June 03, 2006 14:10 To: Jacob, Raymond A Jr Cc: mysql@lists.mysql.com Subject: Re: Can I delete old -bin.x files in order to free up some space? Yes you can. Be sure not to delete the one the database

Re: Can I delete old -bin.xxxxx files in order to free up some space?

Yes you can. Be sure not to delete the one the database is currently writing to. Are you replicating your database? Are you using them for point in time restores? If you're replicating, make sure your replicas have all caught up on the files you're deleting. On 6/3/06, Jacob, Raymond A Jr <[EMA

Can I delete old -bin.xxxxx files in order to free up some space?

I have not been monitoring my databases now I am using a 100% disk space. thank you, Raymond

error in JDBC Connection(Sorry there was TYPO ERROR in my previous mail)

Hi all, I have got a problem with the jdbc connection while connecting to Mysql.I have written an XML file.The following is the code for giving the database connection com.mysql.jdbc.Driver<\driver> jdbc:mysql:\\localhost\test<\location> root<\us

Problem with JDBC Connection

Hi all, I have got a problem with the jdbc connection while connecting to Mysql.I have written an XML file.The following is the code for giving the database connection com.mysql.jdbc.Driver<\driver> jdbc:mysql:\\localhost\\test<\location> root<\u

Select query problem

Hi I have one problem that i can`t resolve. I have 3 tables TABLE `predmet` ( `PredmetID` int(10) unsigned NOT NULL auto_increment, `BrojPredmeta` int(10) unsigned NOT NULL default '0', `VrstaPredmetaID` int(10) unsigned NOT NULL default '0', `KorisnikID` int(10) unsigned NOT NULL default

Re: measuring query time

On 6/1/06, Colin Charles <[EMAIL PROTECTED]> wrote: Deniz Ersoz wrote: > > Is there a way to get the time spent in the server for each query? Write it > in a log or append it to the result ??? Will what is in the slow query log help? See the following: http://dev.mysql.com/doc/refman/5.0/en/sl