Home Forums LoveStory Connection error with the database

Connection error with the database

  • Adam985

    I know that similar topics have already happened, but I did not find the answer to my problem. Recently, my MyQL database has been receiving too many inquiries from the WordPress installation. Here are the last mistakes that the hosting administrators sent me:

    12250349 | | | | Query | 110212 | statistics | SELECT wp_users.* FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) INNER JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id ) INNER JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id ) INNER JOIN wp_usermeta AS mt4 ON ( wp_users.ID = mt4.user_id ) INNER JOIN wp_usermeta AS mt5 ON ( wp_users.ID = mt5.user_id ) INNER JOIN wp_usermeta AS mt6 ON ( wp_users.ID = mt6.user_id ) INNER JOIN wp_usermeta AS mt7 ON ( wp_users.ID = mt7.user_id ) INNER JOIN wp_usermeta AS mt8 ON ( wp_users.ID = mt8.user_id ) INNER JOIN wp_usermeta AS mt9 ON ( wp_users.ID = mt9.user_id ) INNER JOIN wp_usermeta AS mt10 ON ( wp_users.ID = mt10.user_id ) INNER JOIN wp_usermeta AS mt11 ON ( wp_users.ID = mt11.user_id ) INNER JOIN wp_usermeta AS mt12 ON ( wp_users.ID = mt12.user_id ) INNER JOIN wp_usermeta AS mt13 ON ( wp_users.ID = mt13.user_id ) WHERE 1=1 AND (

    (

    (

    ( wp_usermeta.meta_key = ‘first_name’ AND wp_usermeta.meta_value != ” )

    AND

    ( mt1.meta_key = ‘_themex_seeking’ AND mt1.meta_value = ‘woman’ )

    AND

    ( mt2.meta_key = ‘_themex_gender’ AND mt2.meta_value = ‘man’ )

    AND

    ( mt3.meta_key = ‘_themex_country’ AND mt3.meta_value = ‘ai’ )

    AND

    ( mt4.meta_key = ‘_themex_city’ AND mt4.meta_value = ‘Warszawa’ )

    AND

    ( mt5.meta_key = ‘_themex_age’ AND CAST(mt5.meta_value AS SIGNED) >= ’29’ )

    AND

    ( mt6.meta_key = ‘_themex_age’ AND CAST(mt6.meta_value AS SIGNED) <= ’35’ )

    AND

    ( mt7.meta_key = ‘_themex_plec’ AND mt7.meta_value = ‘2’ )

    AND

    ( mt8.meta_key = ‘_themex_stan-cywilny’ AND mt8.meta_value = ‘1’ )

    AND

    ( mt9.meta_key = ‘_themex_dzieci’ AND mt9.meta_value = ‘1’ )

    AND

    ( mt10.meta_key = ‘_themex_msza-swieta’ AND mt10.meta_value = ‘1’ )

    AND

    ( mt11.meta_key = ‘_themex_papierosy’ AND mt11.meta_value = ‘2’ )

    AND

    ( mt12.meta_key = ‘_themex_alkohol’ AND mt12.meta_value = ‘2’ )

    )

    AND

    (

    (

    ( mt13.meta_key = ‘wp_capabilities’ AND mt13.meta_value LIKE ‘%\”subscriber\”%’ )

    )

    )

    )

    ) AND wp_users.ID NOT IN (329) ORDER BY display_name ASC LIMIT 0, 37 | 0 | 0 |

    How to solve the problem?

    ihor Staff

    Please sign in or register to view replies from the support staff.

    Adam985

    I do not have many users, because the site has only been functioning for several months and these users are just arriving. Currently set up accounts do not even have 100.

    Hosting has, among others this specification:
    Allowable CPU load 2 cores (200%)
    The maximum number of memory used by all 4096 MB processes
    Memory limit for 1 PHP process (memory_limit) 512 MB
    Limit of simultaneous processes PHP / SSH / cron 100
    The maximum duration of the PHP / SSH / cron 300s process
    The maximum number of files on a 500,000 web account
    Operation limit – IOPS per second 1024
    Maximum duration of a single query to the 60s database
    max_user_connections – number of simultaneous 1 user connections to database 100
    Maximum database volume (no hard limit) 5 GB

    According to the tool type: https://viewdns.info, it shows as many as 218 on the same IP (the default in hosting). Do these technical specifications include all these pages?

    The solution is only a dedicated server?

    ihor Staff

    Please sign in or register to view replies from the support staff.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.