 | levin on Ubuntu 10.10 Maverick with HP … |
| … on project | |
 | lala on 人情信封要怎樣寫 ? |
 | The Crazy World on Best Free Useful Android Apps … |
 | david on Ubuntu 10.10 Maverick with HP … |
There is so many people asking how to improve their mysql instance, and also so many replies that increase key_buffer, sort_buffer, cache size… etc… which believe will lighten up the performance. However, fellows never notice those parameters was actually efficient to their setup.
So here you are MySqlTuner,
(More …)
mkdir /u02/mysql mkdir /u02/mysql/data mkdir /u02/mysql/log mkdir /u02/mysql/run mkdir /u02/mysql/lock chown -R mysql:mysql /u02/mysql mysql_install_db --datadir=/u02/mysql/data --user=mysql
hello levin…
after doing ‘ service mysqld.server2 start ‘ i’m getting one error.
the error is
‘ mysqld.server2: unrecognized service ‘
hope you can help me …
thanks in advance
–
murad
Hi Murad,
How about /etc/rc.d/init.d/mysqld.server2 start ?
Murad, try the following:
$ chmod +x /etc/init.d/mysqld.server2
$ service mysqld.server2 start
The start script in init.d should be executable
This tutorial is covering the web server performance tunings on MySQL, PHP and Apache, WordPress and BuddyPress or general web hosting purpose, the tuning example is based on CentOS 5.
The key of the following performance tuning is focus on memory and caching, most of people host a web site or forum or blog without any tunings or even use the all out-of-box setting.
Thank for performa tuning server guide.
Followed your instructions to setup FastCGI, all worked well accept at the end, when I hit my website, I get:
#!/bin/bash
PHP_CGI=/usr/bin/php-cgi
PHP_FCGI_CHILDREN=16
PHP_FCGI_MAX_REQUESTS=1000
export PHP_FCGI_CHILDREN
export PHP_FCGI_MAX_REQUESTS
exec $PHP_CGI
Hi, please make sure you have the similar lines as below.
ScriptAlias /cgi-bin/ “/var/www/cgi-bin/”
\< Directory "/var/www/cgi-bin" \>
AllowOverride None
Options None
Order allow,deny
Allow from all
\< \/Directory \>
Joris Conijn, 
Murad and one other person are discussing. 
Singularity 11:30 pm on January 21, 2011 Permalink |
how do you figure this is for “dummies”?!
levin 11:34 pm on January 21, 2011 Permalink |
Because I’m the dummy one.. :P
Florin 3:20 am on January 25, 2011 Permalink |
“./mysqltuner.pl” didn’t worked for me .
I made it work with “pearl mysqltuner.pl”
levin 3:29 am on January 25, 2011 Permalink |
try “chmod +x mysqltuner.pl” first, then you can run it without specifying “perl”