Hi ,
I have database which has some tables that contain huge records
upto 8 Million due to this even making indexes queries excution timing
will be too high

Please provide solution for this what step we can take ?

is that the same as

.
=
()
()
()
()
()

(obviously I'm using the ancient Mayan numbering system here).

Mike

8 million records

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

Yes but we need to know the following:

• Can you give the table definition + indexes?
• Can you give some example SQL that's running slowly?
• How slow is slow (in seconds)?
• Do you rebuild your indexes at all?