Re: extend via table VS extend via database

2010-02-01 Thread Johan De Meersman
If you have performance problems, and no slowlog, maybe it just isn't enabled in your config ? Your indexes may not have changed, but the size of your data has. A query that does a full tablescan will run acceptably on a few thousand records, but be damn slow on a few million - especially as soon

extend via table VS extend via database

2010-01-29 Thread Cui Shijun
hi, I'm using innodb engine. There are more and more rows in my table recently, and I've planned to extend the structure. Assume I have testdb, the database, and testTab, the table, in ONE mysql. There are two ways: * extend via table, that is, testTab - testTab_1 -

Re: extend via table VS extend via database

2010-01-29 Thread Johan De Meersman
On Fri, Jan 29, 2010 at 9:52 AM, Cui Shijun rancp...@gmail.com wrote: I'm using innodb engine. There are more and more rows in my table recently, and I've planned to extend the structure. Why do you want to split your table ? What problems are you trying to solve ? -- Bier met grenadyn