Hi all,
I've got many unauthenticated user, writing to net, reading from net, ... when use "show processlist" command in myslql. It makes database server be full of processes and moodle's performance is so slow.
I've tried scp command to test data transfer speed between webserver and database server. The result that:
- It's very slow if mysql still running in db server (about 500KB/s).
- It's very fast if I stop mysql in db server (about 40MB/s)
What happen? Who can help me to solve that problem.
Thanks.
Many unauthenticated user, writing to net after using show processlist command
回帖数:6
回复Jai Gupta
Re: Many unauthenticated user, writing to net after using show processlist command
回复Đặng Quang Hùng
Re: Many unauthenticated user, writing to net after using show processlist command
回复Jai Gupta
Re: Many unauthenticated user, writing to net after using show processlist command
回复Đặng Quang Hùng
Re: Many unauthenticated user, writing to net after using show processlist command
http://en.wikipedia.org/wiki/Memcached
Memcached is basically a caching system for database. If you install it on webserver then it may cache a reasonable amount of data in webserver, reducing the calls to db server hence reducing bandwidth.
You can download it from http://www.danga.com/memcached/download.bml
Memcached is basically a caching system for database. If you install it on webserver then it may cache a reasonable amount of data in webserver, reducing the calls to db server hence reducing bandwidth.
You can download it from http://www.danga.com/memcached/download.bml
回复Đặng Quang Hùng
Re: Many unauthenticated user, writing to net after using show processlist command
I would suggest that you get some more detail on whats going on with your servers using some monitoring tools. Sar (systat) is good and something like Cacti is pretty; see http://cacti.net and https://help.ubuntu.com/community/Cacti?action=show&redirect=CactiHowTo