mysql issues? Slow web performance, anyway
Posted: Fri May 15, 2009 4:20 pm
I've got a few problems, and i feel like maybe theyre connected. I've got a dual 3GHz machine with 2GB of RAM, about 6TB of storage, and a dedicated physical network, using 3Com switches. Everything works (physically), and everything is dedicated, no resources are shared. There are 10 cameras up right now.
Loading pages is hugely slow; it sometimes takes 5 minutes just to bring the index page up, and often a monitor page will just not load. The events window can take up to 20-30 minutes (albeit there are quite a few events, but still). Recently i've started getting these errors when i open a monitor:
Warning: mysql_pconnect() [function.mysql-pconnect]: Link to server lost, unable to reconnect in /usr/share/zoneminder/zm_db.php on line 21
is the slow performance and this connected? Is there anything I can do about either? Let me know if you need logs or other information. Thanks!
Loading pages is hugely slow; it sometimes takes 5 minutes just to bring the index page up, and often a monitor page will just not load. The events window can take up to 20-30 minutes (albeit there are quite a few events, but still). Recently i've started getting these errors when i open a monitor:
Warning: mysql_pconnect() [function.mysql-pconnect]: Link to server lost, unable to reconnect in /usr/share/zoneminder/zm_db.php on line 21
is the slow performance and this connected? Is there anything I can do about either? Let me know if you need logs or other information. Thanks!