hello
For httpd.conf i want good configuration for high performance server.so that can optimize my MySQL and Apache server.please provide configuration that will help me to set my goal
hello
For httpd.conf i want good configuration for high performance server.so that can optimize my MySQL and Apache server.please provide configuration that will help me to set my goal
following are a few points which you should consider for faster performance.
1.compile MySQL with -static option. that will require more disk space but runs faster.
2. start debug option only if required. Enabling debug mode installs a SAFEMALLOC checker. Running SAFEMALLOC is making slow. So if you have enabled debug performance will degrade, you should start mysqld with -skip-safemallaoc option.
3. Compile without -fomit-frame-pointer. which is a pointer to the current stack frame. which used for debugging purpose. that will speed up it.
4. Use the character sets required for application only and specify by the -with-charset in the configure option. also use minimum character set with -with-extra-charsets=none option.
You can do three things to make your MySQL server faster, from least effective to most effective:
1. Throw hardware at the problem.
2. Tune the settings of the MySQL process.
3. Optimize your queries.
check more information here http://www.ibm.com/developerworks/li...ne-lamp-3.html and http://www.ibm.com/developerworks/li...ne-lamp-2.html
Bookmarks