MySQL Forums
Forum List  »  Newbie

Re: Suggested settings for MySql
Posted by: Hans Brost
Date: October 11, 2017 09:47AM

PS.

You keep asking why it's on ISAM.....cause it is...lol

It ran in 28 seconds on ISAM before, so I don't see the point of going to innodb.....in fact....maybe I can get rid of the innodb stuff in my.cnf altogether?

I don't know why there are innodb values in the status page at all, since I'm not using it.

And the 'old DV' was actually a DS.....

The DV I'm on now is the second one I got.......like I said the first DV also had 2G and the script ran in 1:30 ......so I'm ASSUming...lol....there are some settings that are different on this second one.....hence my original question........what values should I use on the various options available??

Maybe delayed write of some kind?......every record in the DB IS getting updated on this script.....I just don't get why it can't totally run in memory.......it's a TINY DB, relatively speaking.......

z

Options: ReplyQuote


Subject
Written By
Posted
October 05, 2017 11:03AM
October 05, 2017 02:46PM
October 05, 2017 04:21PM
October 05, 2017 02:49PM
October 05, 2017 02:50PM
October 05, 2017 04:18PM
October 05, 2017 04:21PM
October 05, 2017 04:28PM
October 09, 2017 12:18PM
October 11, 2017 09:35AM
October 11, 2017 10:12AM
Re: Suggested settings for MySql
October 11, 2017 09:47AM
October 14, 2017 12:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.