Bug Urgent issue

[digitalblahblah]

Hello

We are having major issues with the forum. We have isolated down to when rewriting thread urls is enabled.

As soon as we turn this on a huge additonal load is placed on the server.

We are using Memcached but this doesn't seem to make any difference.

Has something changed in the new version, to us it looks like the cache part is being ignored.

Is there a way for us to use a different instance of Memcache to test this theory? We did try using filecache just for DBSEO but couldnt get this to work, can you explain how to do this?

 

[Fillip H.]

There's no support for dedicated Memcache servers for DBSEO at this time, however you can modify /dbtech/dbseo/includes/class_datastore.php and change the variables in this piece of code:

	private function connect()
	{
		if (!$this->memcache_connected)
		{
			if (is_array(DBSEO::$configFile['Misc']['memcacheserver']))
			{
				if (method_exists($this->memcache, 'addServer'))
				{
					foreach (array_keys(DBSEO::$configFile['Misc']['memcacheserver']) AS $key)
					{
						$this->memcache->addServer(
							DBSEO::$configFile['Misc']['memcacheserver'][$key],
							DBSEO::$configFile['Misc']['memcacheport'][$key],
							DBSEO::$configFile['Misc']['memcachepersistent'][$key],
							DBSEO::$configFile['Misc']['memcacheweight'][$key],
							DBSEO::$configFile['Misc']['memcachetimeout'][$key],
							DBSEO::$configFile['Misc']['memcacheretry_interval'][$key]
						);
					}
				}
				else if (!$this->memcache->connect(DBSEO::$configFile['Misc']['memcacheserver'][1], DBSEO::$configFile['Misc']['memcacheport'][1], DBSEO::$configFile['Misc']['memcachetimeout'][1]))
				{
					return 3;
				}
			}
			else if (!$this->memcache->connect(DBSEO::$configFile['Misc']['memcacheserver'], DBSEO::$configFile['Misc']['memcacheport']))
			{
				return 3;
			}
			$this->memcache_connected = true;
			return 1;
		}
		return 2;
	}

 

[digitalblahblah]

Thanks for replying. Is there any reason why it would be so slow?

 

[digitalblahblah]

We just tried that, it did write to memcache but again the load on our servers was to much.

We really have a big setup of servers which should be able to handle this, what happens is DB connections don't close.

Is there definitely not an issue with Memcache caching?

 

[Fillip H.]

We have had no reports of similar slow-downs from any other sites, so I can't say I can think of a reason. For optimal performance, make sure your forum and member profile URLs have forum_id and user_id as a part of their URL configurations.

DragonByte SEO uses vBulletin's shutdown system to close its connections. If these events are not firing on your forum, then that will be an entirely separate issue not related to DBSEO.

 

[digitalblahblah]

Its so strange

We use this

[forum_title]/[thread_title]-[thread_id]/

We replaced VBSEO so are using that format, didn't really have much choice.

 

[Fillip H.]

I mean for Forum URL and Member Profile URL formats, not Thread URL formats.

 

[digitalblahblah]

Can I just ask for a fairily large forum, what size would you expect the datastore_cache.php to be. I know this gets inserted into Memcache.

Ours is currently

1.4mb

Does that sound right?

 

[Fillip H.]

Is that for Filecache? DragonByte SEO does not support the Filecache method of caching, so I really couldn't say what is normal for the regular vBulletin datastore cache.

 

[digitalblahblah]

I was just looking at the inbuilt VB datastore. We were storing it in Memcache, but out of interest I have put it as a file and its 1.4mb which seemed pretty large!

 

[DragonByte Technologies]

Hello digitalblahblah,

This ticket has now been closed with the status Not A Bug.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!