This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 10 replies, has 2 voices.

Last updated by teamF 2 months, 2 weeks ago.

Assigned support staff: Raja Mohammed.

Author Posts
August 20, 2019 at 8:16 pm #4426307

teamF

We have been having a lot of issues with our wp_options table growing too large due to _wp_session_ entries. If we don't run a query to manually delete _wp_session_ entries the server will consume all available CPU due to the slowness of querying the wp_options table. We have only observed this happening if the WPML plugin is installed/activated. Below is an example _wp_session_ entry.

option_id	option_name	option_value	autoload
21271168	_wp_session_d0825557bb87ca1ce9c8731517b31886	a:0:{}	no
21271169	_wp_session_expires_d0825557bb87ca1ce9c8731517b31886	1566243065	no
August 21, 2019 at 7:10 am #4428403

Raja Mohammed
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hi there,

I will help you with your issue,

It seems you are using an older version of WPML 4.2.6, Please update to the latest version 4.2.7.1. If you don't see the update notice on your site follow the manual update process mentioned below
- Secure a backup of your site and database
- Deactivate and remove the existing WPML plugins from the plugin list (this won't cause any data loss)
- Download and install fress copy of plugins from https://wpml.org/account/downloads/
- Install only the WPML Multilingual CMS first to complete the setup
- Once you have registered the site with the plugin, install the additional WPML plugins form plugins > Add new > Commercial tab

Check if that helps. Let me know the results,

Kind regards
Raja

August 21, 2019 at 12:09 pm #4431129

teamF

I have updated all WPML plugins to the latest versions but I am still seeing the issue. Yesterday the wp_options table was at 130,000 records and now it is at 213,000 records, with the vast majority being _wp_session_ records.

August 22, 2019 at 5:36 am #4436371

Raja Mohammed
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Please provide a snapshot (copy) of your site, you can use the Duplicator plugin to create a snapshot of the site and share the package link with me http://wordpress.org/plugins/duplicator/ .

I have enabled private fields for you to securely share the details.

August 23, 2019 at 1:08 pm #4447495

Raja Mohammed
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hi,

FYI, I have not forgotten about your issue, I'm still working on this.

I will update you with the results soon.

August 23, 2019 at 1:55 pm #4447903

Raja Mohammed
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Thanks for your patience, I have noticed the sessions are added from Youtube showcase plugin and its interacting WPML and hence the expired sessions are nor cleared form the list.

Updating to the latest version (4.2.7.1) of WPML and its add on plugins seems to resolve the issue in my local setup

I hope that would help you as well.

Kind regards
Raja

August 29, 2019 at 11:38 am #4480561

teamF

Hi Raja, the issue still exists for us. The snaphost I provided you had already been updated for all the latest versions for WPML and it's plugins and I'm seeing the wp_options table grow about 75,000 records per 24 hour period due to _wp_session entries.

SELECT count(*)
FROM `wp_options`
where option_name like '%_wp_session%'

count(*)
216081
August 30, 2019 at 4:16 am #4484679

Raja Mohammed
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

I have checked the duplicator package in my local environment the options table has just over 700 entires. I could not find any entry with _wp_session this is after WPML update to latest version 4.2.7.1.

As I can see the _wp_session record is added by "Youtube Showcase" plugin can you please temporarily disable the plugin or provide me the URL where the plugin is actually used in the site.

I would also require temporary access to your site for a detailed look into your settings. For this, I have enabled private fields for you to securely share the details.

Kind regards
Raja

August 30, 2019 at 12:50 pm #4487281

teamF

Our client installed the Youtube Showcase plugin and it does not appear to be in use. I deactivated it and the wp_options table immediately stopped growing. Is the issue completely due to the Youtube Showcase plugin or is it a combination of using the Youtube Showcase plugin alongside the WPML plugin?

August 30, 2019 at 1:13 pm #4487385

Raja Mohammed
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Yeah, this seems like a possible conflict, However if the plugin is not is use better to delete it from the list. What I observe is only the plugin Youtube showcase is inserting _wp_session records but it is not able to delete those record when WPML is active. However, I am not 100% sure as this is not the case tested in a clean installation.

If disabling the plugin is not an issue for you, then you should be good to proceed with your project 🙂

Kind regards
Raja

August 30, 2019 at 1:28 pm #4487461

teamF

My issue is resolved now. Thank you!