quix0r

Oh, oops. I need to mention that “root-access” (btw: over a “normal” user account and then become root with “su”) on your server is needed for doing this. ??

Please visit my blog I have added a post about a SQL cache.

An approach for a faster WordPress (2.0.4-) powered weblog

I ran the APD (Advanced PHP Debugger) on WordPress 2.0.4 and here is the result. The first is for user+system time spent in subroutines the second the number of calls:

Trace for /var/www/htdocs/index.php
Total Elapsed Time = 19.88
Total System Time = 1.26
Total User Time = 6.30

Real User System secs/ cumm
%Time (excl/cumm) (excl/cumm) (excl/cumm) Calls call s/call Memory Usage Name
--------------------------------------------------------------------------------------
5.7 0.51 0.51 0.35 0.35 0.08 0.08 18497 0.0000 0.0000 0 mysql_fetch_object
5.4 1.25 1.25 0.28 0.28 0.12 0.12 4591 0.0001 0.0001 0 mysql_query
5.0 0.44 0.50 0.33 0.38 0.05 0.06 9263 0.0000 0.0000 0 WP_Object_Cache->get
4.9 0.38 0.38 0.30 0.30 0.07 0.07 16688 0.0000 0.0000 0 mysql_num_fields
4.7 0.42 0.42 0.29 0.29 0.07 0.07 9088 0.0000 0.0000 0 microtime
4.6 0.55 0.55 0.31 0.31 0.04 0.04 12213 0.0000 0.0000 0 mysql_fetch_field
4.3 0.31 0.31 0.27 0.27 0.05 0.05 11700 0.0000 0.0000 0 str_replace
4.3 0.40 0.40 0.24 0.24 0.09 0.09 14607 0.0000 0.0000 0 preg_match
3.7 0.33 0.33 0.26 0.26 0.02 0.02 4527 0.0001 0.0001 0 wpdb->flush
3.4 0.30 0.30 0.25 0.25 0.01 0.01 4124 0.0001 0.0001 0 logthis
3.4 0.23 0.23 0.20 0.20 0.05 0.05 11379 0.0000 0.0000 0 explode
3.2 0.24 0.36 0.22 0.30 0.02 0.02 7998 0.0000 0.0000 0 preg_replace
3.0 0.24 0.24 0.19 0.19 0.04 0.04 13614 0.0000 0.0000 0 is_array
2.6 0.28 0.28 0.18 0.18 0.02 0.02 2021 0.0001 0.0001 0 strtotime
2.6 0.24 0.24 0.18 0.18 0.02 0.02 7674 0.0000 0.0000 0 func_get_args
2.5 0.26 0.26 0.18 0.18 0.01 0.01 4933 0.0000 0.0000 0 unserialize
2.2 0.18 0.18 0.15 0.15 0.02 0.02 2301 0.0001 0.0001 0 date
1.8 0.11 0.11 0.12 0.12 0.02 0.02 4475 0.0000 0.0000 0 mysql_free_result
1.7 0.16 0.16 0.10 0.10 0.03 0.03 7584 0.0000 0.0000 0 merge_filters
1.6 0.15 0.15 0.10 0.10 0.02 0.02 7674 0.0000 0.0000 0 array_slice

And here goes the second test:

Trace for /var/www/htdocs/index.php
Total Elapsed Time = 19.88
Total System Time = 1.26
Total User Time = 6.30

Real User System secs/ cumm
%Time (excl/cumm) (excl/cumm) (excl/cumm) Calls call s/call Memory Usage Name
--------------------------------------------------------------------------------------
5.7 0.51 0.51 0.35 0.35 0.08 0.08 18497 0.0000 0.0000 0 mysql_fetch_object
4.9 0.38 0.38 0.30 0.30 0.07 0.07 16688 0.0000 0.0000 0 mysql_num_fields
4.3 0.40 0.40 0.24 0.24 0.09 0.09 14607 0.0000 0.0000 0 preg_match
3.0 0.24 0.24 0.19 0.19 0.04 0.04 13614 0.0000 0.0000 0 is_array
4.6 0.55 0.55 0.31 0.31 0.04 0.04 12213 0.0000 0.0000 0 mysql_fetch_field
4.3 0.31 0.31 0.27 0.27 0.05 0.05 11700 0.0000 0.0000 0 str_replace
3.4 0.23 0.23 0.20 0.20 0.05 0.05 11379 0.0000 0.0000 0 explode
5.0 0.44 0.50 0.33 0.38 0.05 0.06 9263 0.0000 0.0000 0 WP_Object_Cache->get
1.5 0.11 0.60 0.07 0.43 0.04 0.10 9151 0.0000 0.0000 0 wp_cache_get
4.7 0.42 0.42 0.29 0.29 0.07 0.07 9088 0.0000 0.0000 0 microtime
3.2 0.24 0.36 0.22 0.30 0.02 0.02 7998 0.0000 0.0000 0 preg_replace
2.6 0.24 0.24 0.18 0.18 0.02 0.02 7674 0.0000 0.0000 0 func_get_args
1.6 0.15 0.15 0.10 0.10 0.02 0.02 7674 0.0000 0.0000 0 array_slice
1.7 0.16 0.16 0.10 0.10 0.03 0.03 7584 0.0000 0.0000 0 merge_filters
1.3 0.09 1.54 0.08 1.15 0.02 0.24 7556 0.0000 0.0000 0 apply_filters
2.5 0.26 0.26 0.18 0.18 0.01 0.01 4933 0.0000 0.0000 0 unserialize
0.9 0.09 0.34 0.06 0.24 0.01 0.02 4914 0.0000 0.0000 0 maybe_unserialize
0.7 0.08 1.35 0.04 0.98 0.02 0.16 4909 0.0000 0.0000 0 get_settings
5.4 1.25 1.25 0.28 0.28 0.12 0.12 4591 0.0000 0.0000 0 mysql_query
1.2 0.13 0.13 0.08 0.08 0.00 0.00 4530 0.0000 0.0000 0 mysql_error

I guess it’s clear: the database acceses are consuming very much time. I suggestion here is to develop a class for caching SQL queries.

Whenever a SELECT command runs it checks for a cache file, in other cases (DELETE, UPDATE and so on) it will purge all assigned cache files with that table.

More details in a minute. ??

As long as your server is accepting email from unreachable (faked) email-addresses you will receive more spam.

Aside many other things, I test this in my main.cf (postfix)

reject_invalid_hostname,
reject_multi_recipient_bounce,
reject_non_fqdn_recipient,
reject_non_fqdn_sender,
reject_unauth_destination,
reject_unauth_pipelining,
reject_unknown_recipient_domain,
reject_unknown_sender_domain,
reject_unverified_recipient,
reject_unverified_sender


If you are interested in my VHCS main.cf and master.cf files then please send me an email and I send you back the links to them.

roland [at] NOSPAM_REMOVE_THIS haeder [dot] net

@spencerp: thanks for sending the mail anyway. Maybe someone is coming arround here…

@vkaryl: The headers From and Return-Path is both webmaster_REMOVE_THIS_@mxchange_NOSPAM_.org without the BIG_LETTERS again ??

The From lin includes also my name. But as far as I know this is usual?

Thx… ??

Little typo in second sentence found: […] same as your blog […] and not guestbook. :-/

??? Nothing to say? ??

I have updated my patch. It tracks now the commentator’s website which s/he can enter in the form. My patched version of the click counter encodes the URL with Base-64 encoding to avoid some trouble with “Cracker Tracker” scripts (see: Poland and Perl are ending with .pl). go.php is decoding it again before it counts the click. ??

??

r.haeder_REMOVE_THIS_@will-hier-weg._NO_SPAM_de is a so-called “fun-domain” address provided by GMX ( gmx.net )

And I have subscribed with the above email address which I have setup on my server.

Sure. ?? Feel free to do so. If you encounter any problems which hadn’t before you install my plugin please report them on my blog.

[offtopic]Space Cadet Day?[/offtopic]

I have written an anti-spam plugin that targets the POST request of those spambots.

Remember this: wp-comments-post.php is the relevant script where the comments form will be send to. So the spammer feeds his bot with informations on which server WP is installed and the bot tries to send-out his spam to that script.

You can find my plugin here:
https://blog.mxchange.org/2006/08/26/wordpress-plugin-comments-post-rewriter/

Q

Still no luck… ?? And I have some good topics to discuss about: performance and caching

I have tried it with different addresses from different servers.

Thanks for your help and opening my eyes for this. ??

PS: I shall change my script-kiddy-like nickname to something better..

[offtopic]For handling trackback spam I have the Moderate Trackback Plugin and Referral Bouncer[/offtopic]

I have seen many access attempts with an empty user-agent string. Is there a way of…

1) blocking such attempts via .htaccess
2) while letting RSS feeds pass through?

It must be something like this:

RewriteCond %{HTTP_USER_AGENT} ^$ [AND]
RewriteCond %{BLA_BLA}
RewriteRule BLA_BLA [F]

It will not work this way and I’m not good in writing .htaccess.