QUOTE(Ennio @ 21 Oct, 2009 - 06:21 AM)
I have a website that runs on a ColdFusion 8 server with windows 2003.
The website gets about 2,000 visits per day, and around 400,000 page views per month.
From time to time, the server will run very very slow... and after I reset the CF8 server it goes back to normal.
I noticed that for some reason, some of the DB queries does not disconnect from the DB server and that makes it slow.
The DB server is another windows 2003 server with MySQL 5.1
I tried updating the MySQL Connector to the latest version, and a few other upgrades... but still have that problem from time to time.
Any suggestion or how to solve that?
Should I use the windows 2003 load balancing for the website? I have another server here that I could use for a web server too.
It is not an malfunction or bug. It is simply a setting in the Admin. In your caching settings under Server Settings on ColdFusion Admin ("CF8Server"/CFIDE/Administrator") set the maximum number of cached queries much lower than the default 100.
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
21 Oct, 2009 - 06:21 AM
| 
