Le 2010-12-02 à 13:36, Kieran Kelleher a écrit : > InnoDB is free. It is a transactional database engine. MyISAM is for logging > and should not be used for relational databases where data integrity matters. > > It is mandatory for WebObjects EOEditingContext > save/transaction-fail/rollback to work. > > If you existing databases and/or table-names have any uppercase in them, > convert those first before using the 'lower_case_table_names' option. Also > that option is important only if developing on Mac/Win and deploying on Linux > > > Regards, Kieran > > PS. InnoDB can be faster than MyISAM since it caches rows in available > memory, whereas MyISAM only caches indexes in memory and must go to disk for > rwo data that is not available in the index used for the query. > > PPS. For low-effort high performance, try to ensure your memory allocation to > mysql is equal to the size of your dataset, also tell innodb how much memory > it can have in the /etc/my.cnf ...... hopefully I can do a session at WOWODC > next year, if Pascal approves, entitled "MySQL for WebObjects Engineers" .....
I already gave you my approval :-) > which should hopefully save people having to go learn more than they need to > know to find out the bits they need to know. ....... and maybe create a few > well-documented boilerplate my.cnf files for common dev-machine and server > configs. > > > > On Dec 1, 2010, at 9:39 PM, Pascal Robert wrote: > >> At a minimum, create a file called my.cnf in /etc , and add this text in the >> file: >> >> [mysqld] >> lower_case_table_names = 1 >> default-storage-engine = InnoDB >> >> And restart MySQL. EOF will be more happy. The default table type in MySQL >> is MyISAM, which is fast but is not transactions safe (and it auto commit). >> >>> OK, so InnoDB appears to be part of the MySQL Community Server. I'll have >>> a look. Thanks. >>> >>> >>> On Dec 1, 2010, at 9:24 PM, Chuck Hill wrote: >>> >>>> It is free. Look in the community edition. >>>> >>>> >>>> On Dec 1, 2010, at 6:24 PM, Andrew R. Kinnie wrote: >>>> >>>>> eesh. I'm not being paid for my time (except in beer and wings) so I >>>>> don't think I can do a commercial transaction engine. :-/ >>>>> >>>>> Is there something else that is effectively free for something this small? >>>>> >>>>> On Dec 1, 2010, at 9:09 PM, Chuck Hill wrote: >>>>> >>>>>> >>>>>> On Dec 1, 2010, at 6:06 PM, Andrew R. Kinnie wrote: >>>>>> >>>>>>> I don't know what InnoDB is, so I'd have to say no. >>>>>> >>>>>> I don't use MySQL. But I do know that MySQL without InnoDB is... not >>>>>> something I would trust data to. Check the Wiki or search for posts on >>>>>> this by Kieran. >>>>>> >>>>>> >>>>>>> I did delete all the bookings and add new ones. No change. :-/ >>>>>>> >>>>>>> The bookings for the feature are still not appearing either, even >>>>>>> though they are new, but I assume that's a different issue. >>>>>> >>>>>> Could be lack of InnoDB, but more likely something wrong in your app or >>>>>> model. >>>>>> >>>>>> >>>>>> Chuck >>>>>> >>>>>> >>>>>> >>>>>>> >>>>>>> On Dec 1, 2010, at 9:01 PM, Chuck Hill wrote: >>>>>>> >>>>>>>> On Dec 1, 2010, at 5:58 PM, Andrew R. Kinnie wrote: >>>>>>>>> On Dec 1, 2010, at 8:42 PM, Chuck Hill wrote: >>>>>>>>> On Dec 1, 2010, at 5:35 PM, Andrew R. Kinnie wrote: >>>>>>>>>> >>>>>>>>>>> Hmm. That was checked, but set as false. In any event, I was >>>>>>>>>>> using an auto-increment. I gather I should remove this? EOF will >>>>>>>>>>> do the right thing and create it's own pk? >>>>>>>>>> >>>>>>>>>> Yes. Auto-increment does not mix well with data created from EOF. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> I changed the debug enabled to true and got this in the console >>>>>>>>>>> when I tried to delete a duplicate: >>>>>>>>>> >>>>>>>>>>> ... >>>>>>>>>>> SELECT t0.AGENT_ID, t0._rowid, t0.COMIC_ID FROM BOOKING t0 FOR >>>>>>>>>>> UPDATE >>>>>>>>>>> ... >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> That is a pretty clear sign that EOF is visibly upset. :-) See if >>>>>>>>>> removing the auto-increment helps. >>>>>>>>>> >>>>>>>>> >>>>>>>>> I already tried that and it didn't help. :-/ >>>>>>>>> >>>>>>>>> Of course now the other issue is that the bookings for the feature >>>>>>>>> act are not showing up at all. >>>>>>>>> >>>>>>>>> This is a new site. Am I better off just deleting all the bookings >>>>>>>>> and adding new ones? (there's only about 25 of them) >>>>>>>> >>>>>>>> >>>>>>>> That is worth a try. If you created data with auto-increment and >>>>>>>> don't have the FK constraints enforced in the database, the >>>>>>>> relationships might be broken (bad data). >>>>>>>> >>>>>>>> Are you running MySQL with InnoDB? >>>>>>>> >>>>>>>> >>>>>>>> Chuck >>>>>>>> >>>>>>>> -- >>>>>>>> Chuck Hill Senior Consultant / VP Development >>>>>>>> >>>>>>>> Practical WebObjects - for developers who want to increase their >>>>>>>> overall knowledge of WebObjects or who are trying to solve specific >>>>>>>> problems. >>>>>>>> http://www.global-village.net/products/practical_webobjects >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> Chuck Hill Senior Consultant / VP Development >>>>>> >>>>>> Practical WebObjects - for developers who want to increase their overall >>>>>> knowledge of WebObjects or who are trying to solve specific problems. >>>>>> http://www.global-village.net/products/practical_webobjects >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> -- >>>> Chuck Hill Senior Consultant / VP Development >>>> >>>> Practical WebObjects - for developers who want to increase their overall >>>> knowledge of WebObjects or who are trying to solve specific problems. >>>> http://www.global-village.net/products/practical_webobjects >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >>> >>> This email sent to [email protected] >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com >> >> This email sent to [email protected] > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
