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

Reply via email to