Cless Posted October 3, 2008 Share Posted October 3, 2008 I have a powerful server (actually, I use redundancy, and therefore, I have two). The database is stored upon an 8GB Quad. In addition, I have done the following to increase speed -- MySQL caché, limits, and indexes. My MySQL server version is 5.0.4.4. After checking the statuses, I, apparently, have no slow queries. At one time, I usually have about 200 to 500 users online. Basically, are there other things which could be causing lag? Too many queries? Looping? Table size? If you can't help me with that, is there a way to check how many queries are being executed per page? Yes, I have checked out all of the sites located within here: http://www.phpfreaks.com/forums/index.php/topic,126096.0.html (the MySQL optimization topic located within this forum). Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/126955-lag-despite-powerful-server-and-optimized-queries/ Share on other sites More sharing options...
corbin Posted October 3, 2008 Share Posted October 3, 2008 Are you sure it's MySQL lagging? Also, how many queries are being executed per second? Quote Link to comment https://forums.phpfreaks.com/topic/126955-lag-despite-powerful-server-and-optimized-queries/#findComment-656713 Share on other sites More sharing options...
Cless Posted October 3, 2008 Author Share Posted October 3, 2008 Are you sure it's MySQL lagging? Also, how many queries are being executed per second? I will look into that later. It seems that MySQL is the culprit, since, whenever I close the site for maintenance, it goes extremely fast. Also, how would I find out how many are being executed per second? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/126955-lag-despite-powerful-server-and-optimized-queries/#findComment-656715 Share on other sites More sharing options...
awpti Posted October 4, 2008 Share Posted October 4, 2008 Are you running a forum? And if so, which one? Quote Link to comment https://forums.phpfreaks.com/topic/126955-lag-despite-powerful-server-and-optimized-queries/#findComment-656810 Share on other sites More sharing options...
Cless Posted October 4, 2008 Author Share Posted October 4, 2008 I run an online RPG. Quote Link to comment https://forums.phpfreaks.com/topic/126955-lag-despite-powerful-server-and-optimized-queries/#findComment-657001 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.