Oliver Krautscheid (oliversk)

My site is super fast, it’s only the comment_form that is slow. So strange ..

1. It’s a security risk and many want to remove it (do a search on this forum). They can look into the readme file for version numbers.
2. Some people may not know that this is a security risk and need to be remembered. Other plugin authors also do this as a precaution.
3. Yes I disabled the upload scripts because I don’t need them and they can be exploited. Others might also want to disable it for security reasons.
4. Well, this depends on your server configuration. A lot of servers that run apache as nobody (WHM default configuration) require 777 on the gallery folder. A solution is mod_suphp, but if you know a way around this, it surely would improve the security of the plugin.
5.+6. Sounds good!

Also why do you write the WPOM.dat to the uploads folder? I don’t want to set one of the most critical folders to 777. I’d recommend to write this to the cache folder as well and avoid even more security risks.

Also, it’s unlikely you need a post_date index. The usual selection by date order also includes type and status, and you have a combined index for those.

Yea that’s what I thought, thanks man.

I’m worried about the overhead because I had a lot of disk IO and my server became unresponsive a couple times per day. Fragmented tables can be one cause of this ??

Ok, so the index name does not matter.

Here’s a discussion about this issue:

One guys says:

Hmm, that was unexpected. If I add an index only on the ordering column and tell MySQL to use it using “USE INDEX (post_date_idx)”, the performance is an order of magnitude better. Thanks!

There is a multi-column index type_status_date in the default installation.. is that one not sufficient?

Did anyone here actually optimize the default indexes for their large sites?

PHP Fatal error: Call to a member function get() on a non-object in /wp-includes/cache.php on line 93..
this one only occurs when a visitor comes from Google Images. Strange huh?

Anyway, I solved it:
It wasn’t Supercache or WP Stats, it was ACE (advanced category excluder)

More infos if you need it.
https://www.webhostingtalk.com/showthread.php?p=7080599&posted=1#post7080599

Server load is going up again .. *sigh* up to 100

Tired of this ??

I change settings under “Advanced Settings” click on Update Status
Then I go back to Easy and it’s Disabled..

However, Supercache is still serving files.. so I suppose it’s a problem with the checkbox.

Please check that, thanks!

Ok now Supercache doesn’t seem to work at all.

When I enable the plugin and then Update the status on advanced it will automatically turn off the plugin.

Next, when I click on Delete cache nothing happens (stats are not updated like in earlier versions).

I’m about to downgrade again..

I upgraded the plugin WordPress.com Stats. When I imported the stats, server load went up to 50%. Strange, but ok.

Shortly afterward, server load went up the sky 190+ and server became an unresponsive. Lucky for me, I catched this on my site:
MySQL server has gone away on line: 124

This guys has the same problem:
https://www.ads-software.com/support/topic/wp-super-cache-mysql-server-has-gone-away-on-line-124

Actually, I knew Supercache was behind all this, because I had to disable eAccelerator and Ioncube before.

Anyway.. I’m on to it now. Downloaded the latest supercache and when I activate it server crashes..

I did a test after disabling cbnet and opened “Add New Post” 5 times instantly.. server load did not go up this time.

I still think there’s a problem somewhere else.. will closely monitor my server and mysql.

Tip: Also download WP Options Manager and get rid of all the junk that is using autoload. I had like 650 entries, now down to 300.

Anyone of you using cbnet optimizer? The only plugin that I’ve added recently.. and it’s also related to post publishing ??

Anyway, I will keep you posted.

Same problems as OP.

Thanks for posting the plugin list. Here are the plugins we have in common:

Advanced Category Excluder
Contact Form 7
WordPress.com Stats
WP-PageNavi
WP Super Cache

So.. I really don’t want to deactivate any of them, but maybe it’s one of them. My server also crashes, becomes totally unresponsive. Heck, I even had to order a remote reboot now.

This guys here disabled a certain plugin to fix the issue:
https://www.webhostingtalk.com/showthread.php?t=700720

Some more suggestions can be found here:
https://www.ads-software.com/support/topic/database-error-on-listing-posts-for-category?replies=16

I tried to repair my tables as well. Might have to compare the indexes.

Haven’t programmed for a while, but was easier than expected.

If anyone wants to know how to do it:
functions.php
function my_function() {
if (whatever){
return “test”;
}
}

this goes into your post:
<?php
if (function_exists(‘my_function’)){
$var1 = my_function();
if ($var1 == “test”){
DO WHATEVER
}
}
?>

I hope this will help someone else. You can do some pretty amazing things with the functions.php

Keep rocking guys

Unfortunately this solutions does not work me.
I have WP 2.3.3 and this one does not have a table wp_capabilities
or wp_user_levels

I used symlinks to create several instances of wordpress and applied the code from above to get one user table for each install but once I try to perform an action I am supposed to login .. although the login itself is working properly.

I can login on the main site and all subsites but can only perform actions e.g. submitting a form on the main site.

Edit: Just noticed if I login into a site I am only logged into that specific site and not any other sites although they are using the same tables.