Does anybody have a cure yet?
Since 8-1-2006 i have the same problems: MySQL freezing.
- Sometimes the plesk-mysql and sometimes customer-mysql
- When plesk-mysql freezing: most of the services are down
- When customer-mysql freezing: only php+mysql sites are down
- Sometimes when I run statistics
- Sometimes when I run nothing
I made this script to check repair mysql as one of you described in this topic
mysqlcheck.bat:
cd\
cd Program Files\SWsoft\Plesk\MySQL\bin
mysqlcheck -uadmin -ppassword -P 8306 -A -r -o
cd\
cd Program Files\SWsoft\Plesk\Databases\MySQL\bin
mysqlcheck -uadmin -ppassword -P 3306 -A -r -o
I'm not sure yet this script helps solving the problem.
HARDWARE:
- Dell PowerEdge 1850
- Intel Xeon 3Ghz/2MB cache, 800FSB processor
- 2GB memory
- 2 x 73GB SCSI Ultra320, 10.000rpm hot-swap hdd's
- SCSI RAID mirror
SOFTWARE:
- Windows Server 2003 SP1
- Plesk 7.5.6
- ODBC driver MyODBC-standard-3.51.9-win.exe
PLESK COMPONENTS:
- Antivirus ClamAV 0.88
- Microsoft SQL Server 8.00.194
- MySQL 4.1.12
- BIND DNS Server 9.2.4
- Windows Firewall Service Pack 1
- FTP Server Microsoft FTP Server 6.0
- Java JDK 1.5
- Apache Tomcat 5.5.4
(service stopped: component not in use AND BECAUSE IT FREEZES THE SERVER AFTER THREE DAYS)
- MailEnable Standard 1.8
- QoS Packet Scheduler 5.2.3790.1830
- Plesk Agent 1.4.0.0
- ASP 6.0.3790.1830
- ASP.NET 1.1.4322.0
- ASP.NET 2.0.50727.0
- Perl v5.8.6 built for MSWin32-x86-multi-thread
- PHP 4.3.11 (cgi-fcgi) (built: Mar 30 2005 17:34:09)
- Python 2.4.3
- SSI 6.0.3790.1830
- SiteBuilder for Windows 1.2.0
- SpamAssassin 2.64
- ASP.NET Enterprise Manager 0.1.3
- phpMyAdmin 2.6.0-pl3
- AWStats 6.3 (build 1.800)
- Webalizer V2.01-10 (CYGWIN_NT-5.2 1.5.12(0.116/4/2))
- SSL Wrapper stunnel 4.07
(service stopped: component not in use)
- Horde IMP H3 (4.0.1)
- Microsoft FrontPage 5.0.2.5012
- Microsoft IIS 6.0 duh
I use the default out-of-the-box config file for both MySQL databases.
please help me
