Problem.4 :When MySpace Crossed 25 million accounts Effect was seen on the performance and I/O speeds
Resolution -Moved to 64-bit SQL server to work around their memory bottleneck issues. Their standard database server configuration uses 64 GB of RAM.
Failure isolation. Segment requests into web server by database. Allow only 7 threads per database. So if the database is slow only those threads will slowdown and the traffic in the other threads will flow.
Further Task for Developers
MySpace still faces overloads more frequently than other sites.
Login errors occurs at 20 to 40%.
Site activity continues to challenge the technology. Developers continue to redesign Database Software and Storage System. Task is never ending