On Aug 16, 2007, at 5:40 PM, Davide Alberani wrote: > On Aug 16, Davide Alberani <[EMAIL PROTECTED]> wrote: > >> I'll do some tests for performances > > I've set default-storage-engine and default-table-type to InnoDB > in my MySQL 5.0 and I've run imdbpy2sql.py.
Should do the trick. > After the data, it starts building the indexes and... it stays there > forever (or at least for a looong time). > The directory imdbtest (imdbtest is the name of the database I was > creating) is just under 200 KB, while the ibdata1 file is 2.4 GB > and growing. hermes:/var/www/DWS/tools# du -sh /var/lib/mysql/imdb_inno/ 3.2G /var/lib/mysql/imdb_inno/ :-) > The database contains all the data, but as far as I can see, no > index is being create. :-/ The way I did it was just to do a ALTER TABLE and set the ENGINE=InnoDB;. It took a long time to convert but all the indexes are there, and it works fine. > Can anyone test MySQL with InnoDB? > What I've done wrong? Do I have misconfigured something, or it's > just MySQL that hates me? :-) I'm sure MySQL hates you a little too ;-) With regards to performance, the InnoDB *is* a little bit slower for single lookups, but if you fire up e.g. 5 threads that read from the imdb tables, they will process much faster since InnoDB locks on a per-row level, not on a per-table. I need this, and that's why I started this discussion in the first place. > > > -- > Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] > http://erlug.linux.it/~da/ > > ---------------------------------------------------------------------- > --- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a > browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Imdbpy-devel mailing list > Imdbpy-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/imdbpy-devel ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel