If you have both myisam and innodb. You need to ensure sql's from myisam and sql's from innodb have sufficient memory to run.
you can allocate 25% of you RAM to key_buffer used exclusively for myisam and around 60% of your RAM to innodb_buffer_pool for supporting innodb . Also there are other myisam parameters like myisam_sort_buffer_size which u need to set. regards anandkl On 8/13/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello and Greetings mysql, > > I have been running a WAMP server for some time on my Windows XP Pro > box. Over time I have gone through some issues about which WAMP to use > and last Year converted my Apache2Triad installation to WAMP5. All of > my database installations, out of preference, have been MYISAM as I > didn't see the need for INNODB on my local system. In fact, when I did > the WAMP5 installation, it defaulted to INNODB and I reconfigured it > to be MYISAM. > > I recently discovered that WAMP5 is now simply WAMPSERVER and its > pretty much plug and play with a bunch of "customization" modules that > you can generate pretty much any combination of installations you can > possibly want. I simply chose the default as I like to try to keep > things simple which means that I am now running an INNODB server. I > have not noticed any problems with all the MYISAM databases either > running locally or uploading them to my live server and am wondering > what the possible implications are for mixing and matching structures. > I see now that if I add a table to an MYISAM database, it gets added > as an INNODB table so I have a mix and match in the same database. > > Do I need to be worrying about this? What are the consequences? > Everything seems to work. > > TIA for any wisdom. > > -- > Best regards, > mikesz mailto:[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
