database performance

Forum Moderators: open

Message Too Old, No Replies

database performance

farhaty

3:21 pm on Aug 19, 2011 (gmt 0)

Hi Webmasters,

I have a problem with a database, it take more than 30s to load a page,

database descriptions:

engine: MyISM
size: 1.26GB
tables: 2 tables
1st table: 42 fields
2nd table: 3 fields

rows: 226.521 rows

My VPS :

4096 MB RAM
2 CPU (4GHz)

the page was loading normal when the database has < 150000 rows.

it is better to create multiple tables or just one table for a huge database?

Please help me to perform this database, and give me advices how to perform huge database

Thank you

farhaty

3:53 pm on Aug 19, 2011 (gmt 0)

any help yet... hmmm ... where are these webmasters?!

brotherhood of LAN

4:02 pm on Aug 19, 2011 (gmt 0)

farhaty, welcome

Have patience. Free help is worth the wait surely!

You should find out which queries are causing your pages to load slowly. Try using the EXPLAIN [dev.mysql.com] syntax to evaluate how MySQL is parsing your query and if it is using indexes where it should be.

There are a number of optimizations you can use to tune the database server, but most importantly, make sure your queries are tip-top first.