Results 21 to 30 of 34
-
25th Jun 2011, 03:35 AM#21
Member@downfreak
yes mate.
Bring the admins of heroturko and dl4all.
-
25th Jun 2011, 04:12 AM#22
MemberWebsite's:
Katzbb.com Foxmovie.cotry this to my.cnf
creat msql-slow.log and chmod 666 to place the log[mysqld]
datadir =/var/lib/mysql
socket =/var/lib/mysql/mysql.sock
log_slow_queries =/var/log/mysql/mysql-slow.log
user=mysql
old_passwords=1
port = 3306
skip-locking
max_connections = 300
key_buffer = 64M
myisam_sort_buffer_size = 64M
max_allowed_packet = 16M
table_cache = 1024
thread_cache_size = 512
join_buffer_size = 2M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 512K
net_buffer_length = 256K
thread_stack = 256K
tmp_table_size = 32M
query_cache_limit = 2M
query_cache_size = 32M
query_cache_type = 1
thread_cache_size = 256
thread_concurrency = 4
long_query_time = 1
skip-bdb
skip-innodb
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
#safe-updates
[mysqld_safe]
open_files_limit = 8192
[isamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 32M
write_buffer = 32M
[myisamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 32M
write_buffer = 32M
[mysqlhotcopy]
interactive-timeout
[client]
socket=/path/to/mysql.sock
-
25th Jun 2011, 10:09 PM#23
Member
Hi!
Well, i never used DLE, but using wordpress is similar, so:
- Install caching module, so there will be fever mysql query.
- Delete every statistic module, from most popular to any kind of statistic. Use google analytics or getclicky, etc.
- Delete ajax search module, if you installed one
- edit your theme, and for example if there are any tags or categories, edit them to static html (for example like: <?php showcategories(); ?> to <html><a href="jj">Downloads</a><br> etc.
- edit php config, and disable php-s persistent/keepalive connection to mysql feature
Thats all that comes to my mind at first.
-
27th Jun 2011, 04:28 AM#24
Member
As much optimisation as you want start from: hxxp: builtwith.cxm
and you will see that the big ones are not using apache.
i'm about to change to nginx as well final tweeking stage.
-
27th Jun 2011, 06:30 AM#25
OPMemberWebsite's:
downfreak.comIs the sourceccode of DLE compatible with nginx? or there is mods to be done?
Originally Posted by scriptzm
cheers
-
27th Jun 2011, 07:19 AM#26
Member
I'm testing it at the moment and so far all you need is the htaccess with nginx has in its vhost. below what it should look like
you can also port nginx to apache that should speed up things i i have read!PHP Code:server {
listen ip:80;
server_name home;
root /home/....;
rewrite ^/page/(.*)$ /index.php?cstart=$1 last;
location / {
rewrite "^/([0-9]{4})/([0-9]{2})/([0-9]{2})(/?)+$" /index.php?year=$1&month=$2&day=$3 last;
rewrite "^/([0-9]{4})/([0-9]{2})/([0-9]{2})/page/([0-9]+)(/?)+$" /index.php?year=$1&month=$2&day=$3&cstart=$4 last;
rewrite "^/([0-9]{4})/([0-9]{2})(/?)+$" /index.php?year=$1&month=$2 last;
rewrite "^/([0-9]{4})/([0-9]{2})/page/([0-9]+)(/?)+$" /index.php?year=$1&month=$2&cstart=$3 last;
rewrite "^/([0-9]{4})(/?)+$" /index.php?year=$1 last;
rewrite "^/([0-9]{4})/page/([0-9]+)(/?)+$" /index.php?year=$1&cstart=$2 last;
rewrite "^/([^.]+)(/?)+$" /index.php?do=cat&category=$1 last;
rewrite "^/([^.]+)/page/([0-9]+)(/?)+$" /index.php?do=cat&category=$1&cstart=$2 last;
index index.php index.html index.htm;
}
location /tags/ {
rewrite ^/tags/([^/]*)(/?)+$ /index.php?do=tags&tag=$1 last;
rewrite ^/tags/([^/]*)/page/([0-9]+)(/?)+$ /index.php?do=tags&tag=$1&cstart=$2 last;
}
location /user/ {
rewrite ^/user/([^/]*)/rss.xml$ /engine/rss.php?subaction=allnews&user=$1 last;
rewrite ^/user/([^/]*)(/?)+$ /index.php?subaction=userinfo&user=$1 last;
rewrite ^/user/([^/]*)/page/([0-9]+)(/?)+$ /index.php?subaction=userinfo&user=$1&cstart=$2 last;
rewrite ^/user/([^/]*)/news(/?)+$ /index.php?subaction=allnews&user=$1 last;
rewrite ^/user/([^/]*)/news/page/([0-9]+)(/?)+$ /index.php?subaction=allnews&user=$1&cstart=$2 last;
rewrite ^/user/([^/]*)/news/rss.xml(/?)+$ /engine/rss.php?subaction=allnews&user=$1 last;
}
location /lastnews/ {
rewrite ^/lastnews/(/?)+$ index.php?do=lastnews last;
rewrite ^/lastnews/page/([0-9]+)(/?)+$ /index.php?do=lastnews&cstart=$1 last;
}
location /catalog/ {
rewrite ^/catalog/([^/]*)/rss.xml$ /engine/rss.php?catalog=$1 last;
rewrite ^/catalog/([^/]*)(/?)+$ /index.php?catalog=$1 last;
rewrite ^/catalog/([^/]*)/page/([0-9]+)(/?)+$ /index.php?catalog=$1&cstart=$2 last;
}
location /newposts {
rewrite ^/newposts(/?)+$ /index.php?subaction=newposts last;
rewrite ^/newposts/page/([0-9]+)(/?)+$ /index.php?subaction=newposts&cstart=$1 last;
}
location /favorites {
rewrite ^/favorites(/?)+$ /index.php?do=favorites last;
rewrite ^/favorites/page/([0-9]+)(/?)+$ /index.php?do=favorites&cstart=$1 last;
}
location ~ \.(html|xml) {
rewrite "^/([0-9]{4})/([0-9]{2})/([0-9]{2})/page,([0-9]+),([0-9]+),(.*).html(/?)+$" /index.php?subaction=showfull&year=$1&month=$2&day=$3&news_page=$4&cstart=$5&news_name=$6 last;
rewrite "^/([0-9]{4})/([0-9]{2})/([0-9]{2})/page,([0-9]+),(.*).html(/?)+$" /index.php?subaction=showfull&year=$1&month=$2&day=$3&news_page=$4&news_name=$5 last;
rewrite "^/([0-9]{4})/([0-9]{2})/([0-9]{2})/print:page,([0-9]+),(.*).html(/?)+$" /engine/print.php?subaction=showfull&year=$1&month=$2&day=$3&news_page=$4&news_name=$5 last;
rewrite "^/([0-9]{4})/([0-9]{2})/([0-9]{2})/(.*).html(/?)+$" /index.php?subaction=showfull&year=$1&month=$2&day=$3&news_name=$4 last;
rewrite "^/([^.]+)/page,([0-9]+),([0-9]+),([0-9]+)-(.*).html(/?)+$" /index.php?newsid=$4&news_page=$2&cstart=$3 last;
rewrite "^/([^.]+)/page,([0-9]+),([0-9]+)-(.*).html(/?)+$" /index.php?newsid=$3&news_page=$2 last;
rewrite "^/([^.]+)/print:page,([0-9]+),([0-9]+)-(.*).html(/?)+$" /engine/print.php?news_page=$2&newsid=$3 last;
rewrite "^/([^.]+)/([0-9]+)-(.*).html(/?)+$" /index.php?newsid=$2 last;
rewrite "^/page,([0-9]+),([0-9]+),([0-9]+)-(.*).html(/?)+$" /index.php?newsid=$3&news_page=$1&cstart=$2 last;
rewrite "^/page,([0-9]+),([0-9]+)-(.*).html(/?)+$" /index.php?newsid=$2&news_page=$1 last;
rewrite "^/print:page,([0-9]+),([0-9]+)-(.*).html(/?)+$" /engine/print.php?news_page=$1&newsid=$2 last;
rewrite "^/([0-9]+)-(.*).html(/?)+$" /index.php?newsid=$1 last;
rewrite "^/static/(.*).html(/?)+$" /index.php?do=static&page=$1 last;
rewrite ^/rules.html$ /index.php?do=rules last;
rewrite ^/statistics.html$ /index.php?do=stats last;
rewrite ^/addnews.html$ /index.php?do=addnews last;
rewrite ^/([^.]+)/rss.xml$ /engine/rss.php?do=cat&category=$1 last;
rewrite ^/page,([0-9]+),([^/]+).html$ /index.php?do=static&page=$2&news_page=$1 last;
rewrite ^/print:([^/]+).html$ /engine/print.php?do=static&page=$1 last;
rewrite ^/rss.xml$ /engine/rss.php last;
rewrite ^/sitemap.xml$ /uploads/sitemap.xml last;
}
location ~* \.(jpg|jpeg|gif|png|ico|swf|css|js)$ {
expires 30d;
add_header Cache-Control public;
}
## There is an additional password to admin
location =/admin.php {
auth_basic "closed section";
auth_basic_user_file htpasswd;
fastcgi_pass unix:/tmp/fastcgi.sock;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}
location ~ \.php$ {
fastcgi_pass unix:/tmp/fastcgi.sock;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}
location ~ /\.ht {
deny all;
}
}
All depends on your resources.
Mine are limited so no apache.
So far so good tring to get mysql optimized now to use less resouces.
-
27th Jun 2011, 01:42 PM#27
OPMemberWebsite's:
downfreak.com Originally Posted by scriptzm
Keep us update how you going with it.
cheers mate
-
27th Jun 2011, 01:52 PM#28
Member
test is up scriptzmafia.com
working so far
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.1 0.1 2160 644 ? Ss 15:11 0:02 init [3]
root 2 0.0 0.0 0 0 ? S< 15:11 0:00 [migration/0]
root 3 0.0 0.0 0 0 ? SN 15:11 0:00 [ksoftirqd/0]
root 4 0.0 0.0 0 0 ? S< 15:11 0:00 [events/0]
root 5 0.0 0.0 0 0 ? S< 15:11 0:00 [khelper]
root 6 0.0 0.0 0 0 ? S< 15:11 0:00 [kthread]
root 9 0.0 0.0 0 0 ? S< 15:11 0:00 [kblockd/0]
root 10 0.0 0.0 0 0 ? S< 15:11 0:00 [kacpid]
root 168 0.0 0.0 0 0 ? S< 15:11 0:00 [cqueue/0]
root 171 0.0 0.0 0 0 ? S< 15:11 0:00 [khubd]
root 173 0.0 0.0 0 0 ? S< 15:11 0:00 [kseriod]
root 237 0.0 0.0 0 0 ? S 15:11 0:00 [khungtaskd]
root 238 0.0 0.0 0 0 ? S 15:11 0:00 [pdflush]
root 239 0.0 0.0 0 0 ? S 15:11 0:00 [pdflush]
root 240 0.0 0.0 0 0 ? S< 15:11 0:00 [kswapd0]
root 241 0.0 0.0 0 0 ? S< 15:11 0:00 [aio/0]
root 459 0.0 0.0 0 0 ? S< 15:11 0:00 [kpsmoused]
root 488 0.0 0.0 0 0 ? S< 15:11 0:00 [mpt_poll_0]
root 489 0.0 0.0 0 0 ? S< 15:11 0:00 [mpt/0]
root 490 0.0 0.0 0 0 ? S< 15:11 0:00 [scsi_eh_0]
root 493 0.0 0.0 0 0 ? S< 15:11 0:00 [ata/0]
root 494 0.0 0.0 0 0 ? S< 15:11 0:00 [ata_aux]
root 501 0.0 0.0 0 0 ? S< 15:11 0:00 [kstriped]
root 510 0.0 0.0 0 0 ? S< 15:11 0:00 [kjournald]
root 535 0.0 0.0 0 0 ? S< 15:11 0:00 [kauditd]
root 568 0.0 0.1 2392 716 ? S<s 15:12 0:00 /sbin/udevd -d
root 1886 0.0 0.0 0 0 ? S< 15:12 0:00 [kmpathd/0]
root 1887 0.0 0.0 0 0 ? S< 15:12 0:00 [kmpath_handle]
root 1953 0.0 0.0 0 0 ? S< 15:12 0:00 [kjournald]
root 1955 0.0 0.0 0 0 ? S< 15:12 0:00 [kjournald]
root 2130 0.0 0.0 0 0 ? S< 15:12 0:00 [iscsi_eh]
root 2180 0.0 0.0 0 0 ? S< 15:12 0:00 [ib_addr]
root 2187 0.0 0.0 0 0 ? S< 15:12 0:00 [ib_mcast]
root 2188 0.0 0.0 0 0 ? S< 15:12 0:00 [ib_inform]
root 2189 0.0 0.0 0 0 ? S< 15:12 0:00 [local_sa]
root 2192 0.0 0.0 0 0 ? S< 15:12 0:00 [iw_cm_wq]
root 2196 0.0 0.0 0 0 ? S< 15:12 0:00 [ib_cm/0]
root 2198 0.0 0.0 0 0 ? S< 15:12 0:00 [rdma_cm]
root 2216 0.0 0.0 22456 428 ? Ssl 15:12 0:00 brcm_iscsiuio
root 2221 0.0 0.0 3700 428 ? Ss 15:12 0:00 iscsid
root 2222 0.0 0.8 4156 4152 ? S<Ls 15:12 0:00 iscsid
root 2470 0.0 0.1 1816 580 ? Ss 15:12 0:00 syslogd -m 0
root 2473 0.0 0.0 1764 404 ? Ss 15:12 0:00 klogd -x
dbus 2521 0.0 0.1 2848 856 ? Ss 15:12 0:00 dbus-daemon --s
nsd 2595 0.0 0.1 3796 724 ? Ss 15:12 0:00 /usr/local/sbin
nsd 2600 0.0 0.1 10660 676 ? S 15:12 0:00 /usr/local/sbin
nsd 2601 0.0 0.0 3848 504 ? S 15:12 0:00 /usr/local/sbin
root 2602 0.0 0.4 21204 2468 ? Ss 15:12 0:00 php-fpm: master
nginx 2611 0.0 0.4 21204 2344 ? S 15:12 0:00 php-fpm: pool w
nginx 2612 0.0 0.4 21204 2348 ? S 15:12 0:00 php-fpm: pool w
root 2619 0.0 0.2 7208 1064 ? Ss 15:12 0:00 /usr/sbin/sshd
ntp 2638 0.0 0.8 4508 4504 ? SLs 15:12 0:00 ntpd -u ntp:ntp
root 2675 0.0 0.2 4628 1216 ? S 15:12 0:00 /bin/sh /usr/bi
mysql 2716 0.0 2.2 123224 11420 ? Sl 15:12 0:00 /usr/libexec/my
root 3017 0.0 2.9 19816 15392 ? Ss 15:12 0:00 lfd - sleeping
nobody 3027 0.0 0.1 53988 752 ? Ssl 15:12 0:00 /usr/local/bin/
nobody 3033 0.0 0.1 53988 748 ? Ssl 15:12 0:00 /usr/local/bin/
root 3076 0.0 0.3 9380 1892 ? Ss 15:12 0:00 sendmail: accep
smmsp 3084 0.0 0.2 8288 1496 ? Ss 15:12 0:00 sendmail: Queue
root 3102 0.0 0.1 7220 1024 ? Ss 15:12 0:00 nginx: master p
nginx 3103 0.0 1.7 15828 8940 ? S 15:12 0:00 nginx: worker p
root 3116 0.0 0.2 5384 1104 ? Ss 15:12 0:00 crond
xfs 3139 0.0 0.2 3400 1064 ? Ss 15:12 0:00 xfs -droppriv -
root 3179 0.0 0.0 3612 428 ? S 15:12 0:00 /usr/sbin/smart
root 3182 0.0 0.0 1748 444 tty1 Ss+ 15:12 0:00 /sbin/mingetty
root 3183 0.0 0.0 1748 448 tty2 Ss+ 15:12 0:00 /sbin/mingetty
root 3194 0.0 1.9 25668 10232 ? SN 15:12 0:00 /usr/bin/python
root 3196 0.0 0.2 2656 1068 ? SN 15:12 0:00 /usr/libexec/ga
root 3210 0.0 0.5 10060 2980 ? Ss 15:15 0:00 sshd: root@pts/
root 3213 0.0 0.2 4632 1428 pts/0 Ss 15:15 0:00 -bash
root 3439 0.0 0.1 4352 936 pts/0 R+ 15:50 0:00 ps aux
total used free shared buffers cached
Mem: 502 414 88 0 64 283
-/+ buffers/cache: 66 436
Swap: 1019 0 1019
maybe someone can tell me how to get it up on less mem
specially my.cmf
heres how it looks now
[mysqld]
datadir =/var/lib/mysql
socket =/var/lib/mysql/mysql.sock
log_slow_queries =/var/log/mysql/mysql-slow.log
user=mysql
#old_passwords=1
#port = 3306
skip-locking
max_connections = 300
key_buffer = 64M
myisam_sort_buffer_size = 64M
max_allowed_packet = 16M
table_cache = 1024
thread_cache_size = 512
join_buffer_size = 2M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 512K
net_buffer_length = 256K
thread_stack = 256K
tmp_table_size = 32M
query_cache_limit = 2M
query_cache_size = 32M
query_cache_type = 1
thread_cache_size = 256
thread_concurrency = 4
long_query_time = 1
skip-bdb
skip-innodb
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
#safe-updates
[mysqld_safe]
open_files_limit = 8192
[isamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 32M
write_buffer = 32M
[myisamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 32M
write_buffer = 32M
[mysqlhotcopy]
interactive-timeout
[client]
socket=/var/lib/mysql/mysql.sock
-
27th Jun 2011, 03:43 PM#29
OPMemberWebsite's:
downfreak.comlooks good.. but actually am thinking the problem is not apache.
Its mysql thats using a lot of cpu resources..
Is it apache thats making mysql using a lot of resources?
-
27th Jun 2011, 03:57 PM#30
OPMemberWebsite's:
downfreak.comWhat OS you running on mate? Originally Posted by scriptzm
Register To ReplySponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
My vacation in Natal, Brazil. (Heavy Thread)
By aishamontreal in forum General DiscussionReplies: 223Last Post: 10th Sep 2012, 01:52 PM -
My site will not load in Windows 7 will load on XP
By DJboutit in forum Webmaster DiscussionReplies: 2Last Post: 12th May 2012, 07:56 PM -
Google plans to penalize SEO heavy web sites
By ShareShiz in forum News & Current EventsReplies: 2Last Post: 17th Mar 2012, 08:38 PM -
Jobs With heavy Money I Am Working!
By Royal Prince in forum Webmasters, Money MakingReplies: 2Last Post: 7th Jul 2011, 09:33 AM -
To experience heavy uploaders
By MrCube in forum File Host DiscussionReplies: 6Last Post: 30th May 2011, 10:28 AM
Staff Online
themaCreator - create posts from...
Version 3.07 released. Open older version (or...