Databases
StackOverflow2013
Postsdbo
POHow to improve performance of my Joomla based Intranet system?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to improve performance of my Joomla based Intranet system?
    text
    copied!<p>I have a Joomla 1.5.10 based Intranet system. In this application, we have more than 80% custom extensions. Below is the configuration:</p> <pre> Apache version : Apache/2.2.22 (Win32) mod_ssl/2.2.22 OpenSSL/0.9.8 PHP version : 5.3.13 MySQL version : mysqlnd 5.1.11 </pre> <p>It has 3 dedicated Appliocation Server which configuration is :</p> <pre> Windows Server 2008 Standard Edition Service Pack 2 Compiler: MSVC9 (Visual C++ 2008) Architecture: x86 </pre> <p>Again, it has dedicated DB server which configuration is :</p> <pre> 8x Intel(R) Xeon(R) CPU X5460 @3.16GHz, 8.0GB RAM, Windows Server 2008 Standard Edition Service Pack 2.</pre> <p>Below is the MySQL settings in my system:</p> <pre> Sl.# Parameter Value 1 Key Buffer 547M 2 Sort Buffer Size 256K 3 Query cache limit 4M 4 Cache size 350M 5 Long query time 5 6 Interactive timeout 300 7 Max Connection 800 8 Thread cache size 36 </pre> <p>We have configured WAMPSERVER (32 BITS &amp; PHP 5.3) 2.2E on our servers and then install MySQL5.1 on other dedicated server. Hence, we are not using MySQL provided with WAMP. My system become too slow or crash when number of DB connection threads crossed 100. Number of logged-in users we can see are 3000-5000 only. Multiple queries start logging in the slow query logs and huge number of queries are in sleep state. Those queries which are running normal also start logging in slow query log and taking much time in execution. I am unable to find the bottlenecks in my system. Is there Joomla or MySQL creating bottlenecks. Would upgrade helpful to avoid the bottlenecks and increased the performance of our system? If yes, what should we upgrade - Joomla or MySQL and what will be the strategy to upgrade the system. Is there a known performance/scalability issue in 1.5.10 that is resolved by an upgrade?</p> <p>My overall goal is to increase the system performance.</p> <p>Thanks in advance.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload