Welcome to WebmasterWorld Guest from 54.159.19.75

Forum Moderators: open

Message Too Old, No Replies

database performance

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

New User

joined:Mar 4, 2011
posts: 4
votes: 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
3:53 pm on Aug 19, 2011 (gmt 0)

New User

joined:Mar 4, 2011
posts: 4
votes: 0


any help yet... hmmm ... where are these webmasters?!
4:02 pm on Aug 19, 2011 (gmt 0)

Moderator from GB 

WebmasterWorld Administrator brotherhood_of_lan is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Jan 30, 2002
posts:4842
votes: 1


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.