| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jeroen Geusebroek | Date: | October 25 2002 11:11am |
| Subject: | Mysql Innodb performance slow | ||
| View as plain text | |||
Hi There, We have currently an Interbase Database with millions and millions of rows which I would like to migrate to MySQL if possible to increase the speed. Transaction support is necessary, so I am using innoDB. When inserting 160K rows in the database (in an innoDB table) it takes about 700! seconds while the amount of same rows when inserted in a myisam table take about 100 seconds. Now probably this can be fine tuned (I hope), and would like to ask for some suggestions. Is anybody using innodb with this amount of rows? I'm curious of what the performance is. Is there something I should keep in mind when migrating? Kind regards, Jeroen Geusebroek
| Thread | ||
|---|---|---|
| • Mysql Innodb performance slow | Jeroen Geusebroek | 25 Oct |
| • Re: Mysql Innodb performance slow | Richard Clarke | 25 Oct |
| • Re: Mysql Innodb performance slow | Jeff Mathis | 26 Oct |
| • Re: Mysql Innodb performance slow | Dan Nelson | 28 Oct |
| • Re: Mysql Innodb performance slow | Jeff Mathis | 26 Oct |
| • Re: Mysql Innodb performance slow | Paul DuBois | 27 Oct |
| • Re: Mysql Innodb performance slow | Mark Matthews | 26 Oct |
| • Re: Mysql Innodb performance slow | David Lloyd | 26 Oct |
| • Re: Mysql Innodb performance slow | Mark Matthews | 27 Oct |
| • RE: Mysql Innodb performance slow | Jeroen Geusebroek | 26 Oct |
| • Re: Mysql Innodb performance slow | Mark Matthews | 26 Oct |
