Page 1 of 1

handling heavy tables in mysql/php

Posted: Fri Aug 01, 2008 4:21 am
by ashok.pintu
I have a table (mysql) with 66,00,000 records.
now does anyone help me how to handle this table in php/mysql.
my requirement is to search a record based on certain criteria.

Re: handling heavy tables in mysql/php

Posted: Fri Aug 01, 2008 4:27 am
by jaoudestudios
I would index your searchable columns to improve search performance

Re: handling heavy tables in mysql/php

Posted: Fri Sep 05, 2008 9:26 pm
by josh
You're going to need table partitioning, you can set up table partitioning in mysql so mysql can divide the data into more discrete groups, for instance records 1-10M are in partionA on the disk, records 10-20M in partionB, etc...

You can set up partitioning in different ways based on the data you are trying to display. With a table of that size you may need some logic on your application based on what you are trying to do, such as caching or job queues. Can you give us more info on what kind of data youre working with and how youre using / manipulating it?

http://dev.mysql.com/doc/refman/5.1/en/ ... types.html