WordPress.org

Support

Support » Plugins and Hacks » W3 Total Cache » wp-mu or large site may have problem with database cache funtion

wp-mu or large site may have problem with database cache funtion

  • if your site have new user register every 1-3 minute and you have enabled database cache then check your wp_users table in database regularly because plugin run query when user register again and again (run from cache in your ram that store for 180 second) so you’ll have many duplicate user in database

    tick ” Don’t cache queries for logged in users” doesn’t work because user not logged-in when they register

    fixed: put “users” in “Ignored query stems:” so plugin wont cache query when visitor register

    ————————–
    if your site have many users, you can run this query to check duplicate user

    SELECT user_login, user_email, count(*)
    FROM wp_users
    GROUP BY user_login, user_email
    HAVING count(*) > 1

    ————————–

    sometime database cache have problem with wp_comments too but only happen with very large site that have many comments

    all regular sites not affected

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Frederick Townes

    @fredericktownes

    That will slow your site down QUITE a bit. Once a user registers, they should be logged in and database caching should be disabled (that’s the default setting).

    if it default setting why i get many duplicate user before i put “users” in Ignored query stems: ?

    or i have to tick “Don’t cache queries for logged in users” too ?

    my site handle with many logged-in users because some content hidden to visitor but show to logged-in users only so i dont want to overload mysql query then i try un-check “Don’t cache queries for logged in users” (my site also run many query)

    is it okay for my case ? if i un-check “Don’t cache queries for logged in users” and use “Ignored query stems:” to prevent duplicate user problem while optimize db query for logged-in users

    hi, after i run a plugin with default settings for 2-3 days

    i found that there re still DUPLICATE user in table WP_USERS in database

    i have tick “Don’t cache queries for logged in users” in “Database Cache” already

    now i have to put “users” in “Ignored query stems:” to prevent duplicate row problem

    anybody use db cache and have problem same me? check your users table

    Plugin Author Frederick Townes

    @fredericktownes

    Can you please submit a bug submission form from the support tab of the plugIn if you haven’t already?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wp-mu or large site may have problem with database cache funtion’ is closed to new replies.
Skip to toolbar