Category Archives: Hosting

own content delivery network CDN nginx

yum install nginx
cd /etc/nginx/conf.d

vi cdn.conf

server {
listen 80;
server_name static.yourdomain.com;

location ~* .(gif|jpg|jpeg|png|wmv|avi|mpg|mpeg|mp4|htm|html|js|css|mp3|swf|ico|flv)$ {
expires max;
proxy_set_header X-Real-IP $remote_addr;
proxy_pass http://yourdomain.com;
proxy_ignore_headers X-Accel-Expires Expires Cache-Control;
proxy_store /var/www/cache$uri;
proxy_store_access user:rw group:rw all:r;
}
}

chkconfig nginx on
nginx -t
service nginx start

ERROR 1290 (HY000) at line 1: The MySQL server is running with the –secure-file-priv

mysql> SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
1 row in set (0.00 sec)

mysql> Bye

mysql -e "SELECT CONCAT('KILL ',ID,';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'user' AND COMMAND = 'Query' AND TIME > 100 INTO OUTFILE '/var/lib/mysql-files/kill_list.txt';" && mysql -e "source /var/lib/mysql-files/kill_list.txt" && rm -rf /var/lib/mysql-files/kill_list.txt

[core:emerg] [pid :tid ] (28)No space left on device: AH00023: Couldn’t create the proxy mutex

[core:emerg] [pid 7732:tid 140396300543936] (28)No space left on device: AH00023: Couldn’t create the proxy mutex
[proxy:crit] [pid 7732:tid 140396300543936] (28)No space left on device: AH02478: failed to create proxy mutex

Fix:

ipcs | grep apache | awk ‘{print $2}’ > sem.txt
for i in `cat sem.txt`; do { ipcrm -s $i; }; done

Permanant fix:

vi /etc/sysctl.conf

kernel.msgmni = 1024
kernel.sem = 250 256000 32 1024