Quote:
|
Originally Posted by mike_bike_kite
I was correct then. I guess you mean that some tables contain 80m records rather than each record is 80m char long?
Can you give the table definition + indexes?
Can you give some example SQL that's running slowly?
How slow is slow (in seconds)?
I don't see how 80m records will even slightly affect MySQL - that is only a moderate table in database terms.
Mike |
One table tablename transaction is growing in such a way withen 6 month
6 million records entry is done so even making indexes query fired takes
much time
can we do database partitioning for single table
does MyQL 5.0.47 support database partitioning
or is there option to do something else