Quote:
Originally Posted by varshajain87
Hi,
MYSQL version 5.1.41
Linux Version - 2.6.18-238.9.1.el5PAE (mockbuild@x86-004.build.bos.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50)) #1 SMP
Wordpress Version - 3.0.1
|
Ok...are these servers in the same rack? Building? Connected to the same switch, or through different switches? Has the switch been examined, to see if it's getting overloaded?
All the way from one server to another? What else is running on those boxes? Is the network connection getting saturated?
Quote:
- No Firewall - Ok
- Changes made in my.cnf for tuning - please check are they properly configured?
|
No way for us to know what "properly" is. As said before, there are many variables.
Quote:
- No bonding as ther are no multiple network cards
|
Depending on your usage of the existing network link, that may not be a problem.
Quote:
- This is a VMware Virtual machine
|
Uhhh...really?? BOTH of them are, or just one? What are the resources you've got dedicated to the DB and Web servers?
Quote:
- Done partitioning of tables by primary key
- Database size in what terms - has 48 tables- predefined tables for wordpress + few tables for OWA and rolescoper plugin. Currently OWA is deactivated from application end but the tables are still there.
- No changes made in wordpress n linux.
Plz revert in case of any other queries.
|
Spell out your words. Text-speak garbage isn't nice for anyone to read.
Database size in number of records and/or disk space used. If you've got 48 tables, and they've only got 10 records a piece, that's trivial. If you've got 4 tables, each with 10 million records each...that's far different, even though you've got fewer tables. Chances are you're having a problem because this is running in a VM, rather than on a dedicated server. VM has overhead associated with it, and depending on the resources you've got assigned to it, you're overloading it because it's running as fast as it can. Can only ask so much of a machine. If this is a mission-critical machine, then I'd strongly suggest putting it on dedicated servers - NOT VM.
And since you're using RHEL...the best step you could take would be to
CALL REDHAT SUPPORT, since you're paying for it, right?