One, no longer for the Apache process siltation, depletion of memory and troubled
0./etc/my.cnf, add the following line to the mysqld paragraph:
Log-slow-queries=queries-slow.log
- Restart MySQL
- As appropriate, for a period of time, execute the mysqldumpslow command, or view Datadir/queries-slow.log directly, to find out the SQL statement that executes the timeout. Where DataDir is the storage path for all MySQL databases.
- Based on the contents of the SQL statement found in the previous step, locate the appropriate data table and script file to see the reason for the timeout. Possible causes are: The amount of data is really too large, the index is not used to speed up the query, and so on. But the program did not write well certainly is one of the reasons.
- be resolved as appropriate for the reasons identified.
Second, apache+tomcat configuration, tuning
Apache Integrated Tomcat
Apache Tomcat HTTPS app
Apache Performance Tuning
Tomcat Performance Tuning-let the kitten Gallop
Tomcat cluster-group cat Dance
Third, the database
The design of database's permission system
Oracle Performance Tuning-Pilgrimage Prophet Tour
Iv. using threadlocal to improve the division of your hierarchy
Five, apache+weblogic configuration, cluster
Integration and tuning of WebLogic and Apache
Cluster and configuration of WebLogic
Vi. AXIS2 Web Service
Axis2 Web Service (i)
Axis2 Web Service (ii)
Axis2 Web Service (iii)
Axis2 Web Service Security Preliminary
Axis2 Web Service Security Rampart
Vii. IBM WebSphere
Installation and optimization of IBM WebSphere
Integration of IBM WebSphere and IBM Httpserver
IBM WebSphere Cluster Quest-wasnd
Eight, universal framework Spring
Universal frame Spring (I.)
Build a spring project with Maven
Universal Framework Spring (II) MAVEN combined with spring and ibatis
Universal Framework Spring (iii) SSH
Universal frame Spring (iv) using STRUTS2
Ix. maven Ant Integration
The wonderful integration of Maven and Ant
Ten, Unit test
Integration of unit test and dbunit in SSH
XI. Design Document Collaboration
Discussion on the writing skills of architecture and design documents
Linux+jre+apache+mysql+tomcat Tuning