Announcement

Collapse
No announcement yet.

Database errors at vb5 and vb4 forum even after moving to more powerful server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database errors at vb5 and vb4 forum even after moving to more powerful server

    I wasn't getting any database errors then we turned PHP-FM off and the errors started pouring in. However, we had to turn PHP-FM off to address a different issue and I never had it on at my prior server.

    I realize you always say this is a server problem, but I am on a new server at Liquid Web with now 8Gb (versus 2Gb before) and 8 core (versus 2 core before) and still stacks of database errors are coming in.

    There may be something wrong with my database? that perhaps has to do with that it is upgraded from vb3. It doesn't make sense that a forum with as little traffic as mine (no more than a couple hundred logged on at the same time, and usually more like a hundred) would have all these problems on a 8 core VPS.

    (errors below are truncated, too long to post here)

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_64199_lvl1data' AND event = 'nodeChg_64199') OR
    (cacheid = 'node_64200_lvl1data' AND event = 'nodeChg_64200') OR
    (cacheid = 'node_64201_lvl1data' AND event = 'nodeChg_64201') OR
    (cacheid = 'node_64202_lvl1data' AND event = 'nodeChg_64202') OR
    (cacheid = 'node_64203_lvl1data' AND event = 'nodeChg_64203') OR
    (cacheid = 'node_64204_lvl1data' AND event = 'nodeChg_64204') OR
    (cacheid = 'node_64205_lvl1data' AND event = 'nodeChg_64205') OR

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    /** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
    VALUES
    ('node_132_lvl1data', 1573486984, 1573400584, 0, '1', 'a:57:{s:6:"nodeid";s:3:"132";s:7:"routeid";s:2:"91";s:13:"contenttypeid";s:2:"20";s:11:"p ublishdate";s:10:"1237530543";s:13:"unpublishdate";s:1:"0";s:6:"userid";s:1:"1";s:7:"group id";N;s:10:"authorname";s:5:"XXXXX";s:11:"description";N;s:5:"title";s:84:"XXXXXXXX";s:9 :" htmltitle";s:84:"MC___ suspension

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    SELECT * FROM cache
    WHERE `cacheid` IN ('node_1_lvl1data');

    MySQL Error : MySQL server has gone away

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    SELECT * FROM cache
    WHERE `cacheid` IN ('vB_UserPerms1');

    MySQL Error :

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    SELECT `title`,`textonly`,`template_un`,`template` FROM template
    WHERE `templateid` IN (25551);

    MySQL Error : MySQL server has gone away

    ---
    also in my vb4 forum

    Database error in vBulletin :

    mysqli_real_connect(): (HY000/2002): Connection refused
    /home/XXX/public_html/XXXX.com/forums/includes/class_core.php on line 1351
    Last edited by MDawg; Sun 10th Nov '19, 9:36am.

  • #2
    We re-implemented PHP-FM for the vb5 forum, made some tweaks, and are hoping this will resolve. For now, the database errors have settled down.

    Comment


    • #3
      A MySQL Gone Away error means that MySQL closed the connection before returning the results of the query. There are many reasons for this. However, they all go back to MySQL Resources. Make sure you buffers, timeouts, and settings can support your database. Unfortunately, we don't have anyone on the staff that can provide server optimization at this time.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #4
        After re-implementing PHP-FM and doing some tweaking, the only database error that seems to be recurring is a cache event one:

        Database error in vBulletin 5.5.5:

        Invalid SQL:
        /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
        ('node_91016_lvl1data','nodeChg_91016'),
        ('node_90852_lvl1data','nodeChg_90852'),
        ('node_90633_lvl1data','nodeChg_90633'),
        ('node_90492_lvl1data','nodeChg_90492'),
        ('node_90462_lvl1data','nodeChg_90462'),
        .
        .
        .

        ('node_64260_lvl1data','nodeChg_64260'),
        ('node_64347_lvl1data','nodeChg_64347'),
        ('node_64207_lvl1data','nodeChg_64207'),
        ('node_64206_lvl1data','nodeChg_64206');

        MySQL Error : Deadlock found when trying to get lock; try restarting transaction
        Error Number : 1213
        Request Date : Wednesday, November 13th 2019 @ 06:11:08 AM
        Error Date : Wednesday, November 13th 2019 @ 06:11:11 AM
        Script : XXX
        Referrer :
        IP Address : 64.91.XXX.XX
        Username : Guest
        Classname : vB_Database_MySQLi
        MySQL Version :

        Stack Trace:
        #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
        #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
        #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 561
        #3 vB_Database->query_write() called in [path]/vb/db/mysql/querydefs.php on line 7214
        #4 vB_dB_MYSQL_QueryDefs->saveDbCache() called in [path]/vb/db/query/method.php on line 175
        #5 vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 301
        #6 vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 387
        #7 vB_Cache_Db->shutdown() called in [path]/vb/shutdown.php on line 93
        #8 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 483
        #9 vB::shutdown() called in on line

        ---

        Truncating this table doesn't seem to prevent the error from recurring.
        Last edited by MDawg; Mon 18th Nov '19, 9:58am.

        Comment


        • #5
          Restart MySQL to clear the locks. I am guessing your MySQL installation is the basic installation and not optimized to actually be used as production database.

          https://www.mysql.com/news-and-event...or-mysql-2019/
          https://www.mysql.com/why-mysql/performance/index.html
          https://www.percona.com/blog/2016/10...-installation/

          Do you have PHP opcache installed? Memcached? Have you thought about offloading search to Sphinx Server?

          Though, I have to admit that I know nothing about PHP-FPM. We use mod_php here.
          Last edited by Wayne Luke; Wed 13th Nov '19, 9:43am.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


          • #6
            This is what Liquid Web did:

            * Increase the table_open_cache a little

            * Memcached
            That is already installed and running on the system, so it'd just be a matter of ensuring that you configure vBulletin to use it ***Is it configured to use it?

            * Opcache
            Host did not find it already installed for your PHP version you were using, so went ahead and got that installed

            * Sphinx
            Host says that's beyond scope software and may be overkill for your setup

            However, although happening quite rarely, the cache event database still do come in occasionally.

            Database error in vBulletin 5.5.5:

            Invalid SQL:
            /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
            ('node_91183_lvl1data','nodeChg_91183'),
            ('node_91135_lvl1data','nodeChg_91135'),
            ('node_91016_lvl1data','nodeChg_91016'),
            ('node_90852_lvl1data','nodeChg_90852'),
            .
            .
            .
            ('node_64435_lvl1data','nodeChg_64435'),
            ('node_64249_lvl1data','nodeChg_64249'),
            ('node_64229_lvl1data','nodeChg_64229');

            MySQL Error : Deadlock found when trying to get lock; try restarting transaction
            Error Number : 1213
            Request Date : Monday, November 18th 2019 @ 10:26:03 AM
            Error Date : Monday, November 18th 2019 @ 10:26:03 AM
            Script :
            Referrer :
            IP Address : 64.91.XXX.XX
            Username : Guest
            Classname : vB_Database_MySQLi
            MySQL Version :

            Stack Trace:
            #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
            #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
            #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 561
            #3 vB_Database->query_write() called in [path]/vb/db/mysql/querydefs.php on line 7214
            #4 vB_dB_MYSQL_QueryDefs->saveDbCache() called in [path]/vb/db/query/method.php on line 175
            #5 vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 301
            #6 vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 387
            #7 vB_Cache_Db->shutdown() called in [path]/vb/shutdown.php on line 93
            #8 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 483
            #9 vB::shutdown() called in on line

            Comment


            • #7
              What is the output of the MySQL Table Status under Maintenance -> Diagnostics -> System Variables?
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API - Full / Mobile
              Vote for your favorite feature requests and the bugs you want to see fixed.

              Comment


              • #8
                Diagnostics
                MySQL Status
                Variable_name Value
                Aborted_clients 24
                Aborted_connects 76383
                Access_denied_errors 3057
                Acl_column_grants 0
                Acl_database_grants 279
                Acl_function_grants 0
                Acl_procedure_grants 0
                Acl_package_spec_grants 0
                Acl_package_body_grants 0
                Acl_proxy_users 2
                Acl_role_grants 0
                Acl_roles 0
                Acl_table_grants 0
                Acl_users 126
                Aria_pagecache_blocks_not_flushed 0
                Aria_pagecache_blocks_unused 15706
                Aria_pagecache_blocks_used 9441
                Aria_pagecache_read_requests 1007473
                Aria_pagecache_reads 25324
                Aria_pagecache_write_requests 285154
                Aria_pagecache_writes 134441
                Aria_transaction_log_syncs 55
                Binlog_commits 0
                Binlog_group_commits 0
                Binlog_group_commit_trigger_count 0
                Binlog_group_commit_trigger_lock_wait 0
                Binlog_group_commit_trigger_timeout 0
                Binlog_snapshot_file
                Binlog_snapshot_position 0
                Binlog_bytes_written 0
                Binlog_cache_disk_use 0
                Binlog_cache_use 0
                Binlog_stmt_cache_disk_use 0
                Binlog_stmt_cache_use 0
                Busy_time 0.000000
                Bytes_received 20262113758
                Bytes_sent 442538827471
                Column_compressions 0
                Column_decompressions 0
                Com_admin_commands 57
                Com_alter_db 0
                Com_alter_db_upgrade 0
                Com_alter_event 0
                Com_alter_function 0
                Com_alter_procedure 0
                Com_alter_server 0
                Com_alter_sequence 0
                Com_alter_table 1
                Com_alter_tablespace 0
                Com_alter_user 0
                Com_analyze 0
                Com_assign_to_keycache 0
                Com_begin 107
                Com_binlog 0
                Com_call_procedure 0
                Com_change_db 1047154
                Com_change_master 0
                Com_check 232
                Com_checksum 0
                Com_commit 107
                Com_compound_sql 0
                Com_create_db 0
                Com_create_event 0
                Com_create_function 0
                Com_create_index 0
                Com_create_package 0
                Com_create_package_body 0
                Com_create_procedure 0
                Com_create_role 0
                Com_create_sequence 0
                Com_create_server 0
                Com_create_table 43
                Com_create_temporary_table 0
                Com_create_trigger 0
                Com_create_udf 0
                Com_create_user 0
                Com_create_view 0
                Com_dealloc_sql 0
                Com_delete 413800
                Com_delete_multi 644
                Com_do 0
                Com_drop_db 2
                Com_drop_event 0
                Com_drop_function 0
                Com_drop_index 0
                Com_drop_procedure 0
                Com_drop_package 0
                Com_drop_package_body 0
                Com_drop_role 0
                Com_drop_server 0
                Com_drop_sequence 0
                Com_drop_table 43
                Com_drop_temporary_table 0
                Com_drop_trigger 0
                Com_drop_user 1
                Com_drop_view 0
                Com_empty_query 6
                Com_execute_immediate 0
                Com_execute_sql 0
                Com_flush 5
                Com_get_diagnostics 0
                Com_grant 48
                Com_grant_role 0
                Com_ha_close 0
                Com_ha_open 0
                Com_ha_read 0
                Com_help 0
                Com_insert 1373974
                Com_insert_select 284
                Com_install_plugin 0
                Com_kill 0
                Com_load 0
                Com_lock_tables 147
                Com_multi 0
                Com_optimize 0
                Com_preload_keys 0
                Com_prepare_sql 0
                Com_purge 0
                Com_purge_before_date 0
                Com_release_savepoint 0
                Com_rename_table 0
                Com_rename_user 0
                Com_repair 0
                Com_replace 494893
                Com_replace_select 10
                Com_reset 0
                Com_resignal 0
                Com_revoke 3
                Com_revoke_all 0
                Com_revoke_role 0
                Com_rollback 0
                Com_rollback_to_savepoint 0
                Com_savepoint 0
                Com_select 13786323
                Com_set_option 685027
                Com_show_authors 0
                Com_show_binlog_events 0
                Com_show_binlogs 0
                Com_show_charsets 0
                Com_show_collations 0
                Com_show_contributors 0
                Com_show_create_db 0
                Com_show_create_event 0
                Com_show_create_func 0
                Com_show_create_package 0
                Com_show_create_package_body 0
                Com_show_create_proc 0
                Com_show_create_table 0
                Com_show_create_trigger 0
                Com_show_create_user 0
                Com_show_databases 11
                Com_show_engine_logs 0
                Com_show_engine_mutex 0
                Com_show_engine_status 0
                Com_show_errors 0
                Com_show_events 0
                Com_show_explain 0
                Com_show_fields 9830
                Com_show_function_status 0
                Com_show_generic 0
                Com_show_grants 475
                Com_show_keys 14
                Com_show_master_status 0
                Com_show_open_tables 0
                Com_show_package_status 0
                Com_show_package_body_status 0
                Com_show_plugins 0
                Com_show_privileges 0
                Com_show_procedure_status 0
                Com_show_processlist 6303
                Com_show_profile 0
                Com_show_profiles 0
                Com_show_relaylog_events 0
                Com_show_slave_hosts 0
                Com_show_slave_status 0
                Com_show_status 11842
                Com_show_storage_engines 0
                Com_show_table_status 4
                Com_show_tables 11
                Com_show_triggers 14
                Com_show_variables 49
                Com_show_warnings 0
                Com_shutdown 0
                Com_signal 0
                Com_start_all_slaves 0
                Com_start_slave 0
                Com_stmt_close 80
                Com_stmt_execute 80
                Com_stmt_fetch 0
                Com_stmt_prepare 80
                Com_stmt_reprepare 0
                Com_stmt_reset 0
                Com_stmt_send_long_data 0
                Com_stop_all_slaves 0
                Com_stop_slave 0
                Com_truncate 44
                Com_uninstall_plugin 0
                Com_unlock_tables 147
                Com_update 481304
                Com_update_multi 1209
                Com_xa_commit 0
                Com_xa_end 0
                Com_xa_prepare 0
                Com_xa_recover 0
                Com_xa_rollback 0
                Com_xa_start 0
                Compression OFF
                Connection_errors_accept 0
                Connection_errors_internal 0
                Connection_errors_max_connections 0
                Connection_errors_peer_address 0
                Connection_errors_select 0
                Connection_errors_tcpwrap 0
                Connections 682911
                Cpu_time 0.000000
                Created_tmp_disk_tables 27786
                Created_tmp_files 21547
                Created_tmp_tables 643535
                Delayed_errors 0
                Delayed_insert_threads 0
                Delayed_writes 0
                Delete_scan 1145
                Empty_queries 1438609
                Executed_events 0
                Executed_triggers 0
                Feature_check_constraint 0
                Feature_custom_aggregate_functions 0
                Feature_delay_key_write 0
                Feature_dynamic_columns 0
                Feature_fulltext 3
                Feature_gis 0
                Feature_invisible_columns 0
                Feature_json 0
                Feature_locale 0
                Feature_subquery 1040810
                Feature_system_versioning 0
                Feature_timezone 0
                Feature_trigger 0
                Feature_window_functions 0
                Feature_xml 0
                Flush_commands 1
                Handler_commit 9929042
                Handler_delete 7773813
                Handler_discover 1820
                Handler_external_lock 0
                Handler_icp_attempts 475480011
                Handler_icp_match 437355512
                Handler_mrr_init 0
                Handler_mrr_key_refills 0
                Handler_mrr_rowid_refills 0
                Handler_prepare 0
                Handler_read_first 31957
                Handler_read_key 441466833
                Handler_read_last 30185
                Handler_read_next 1846033039
                Handler_read_prev 254761087
                Handler_read_retry 0
                Handler_read_rnd 516539168
                Handler_read_rnd_deleted 951
                Handler_read_rnd_next 3831435219
                Handler_rollback 700
                Handler_savepoint 0
                Handler_savepoint_rollback 0
                Handler_tmp_delete 0
                Handler_tmp_update 5050437
                Handler_tmp_write 20549085
                Handler_update 7953818
                Handler_write 16130504
                Innodb_buffer_pool_dump_status
                Innodb_buffer_pool_load_status Buffer pool(s) load completed at 191110 17:45:10
                Innodb_buffer_pool_resize_status
                Innodb_buffer_pool_load_incomplete OFF
                Innodb_buffer_pool_pages_data 6725
                Innodb_buffer_pool_bytes_data 110182400
                Innodb_buffer_pool_pages_dirty 8
                Innodb_buffer_pool_bytes_dirty 131072
                Innodb_buffer_pool_pages_flushed 9249862
                Innodb_buffer_pool_pages_free 1024
                Innodb_buffer_pool_pages_misc 443
                Innodb_buffer_pool_pages_total 8192
                Innodb_buffer_pool_read_ahead_rnd 0
                Innodb_buffer_pool_read_ahead 165911
                Innodb_buffer_pool_read_ahead_evicted 1630
                Innodb_buffer_pool_read_requests 1110625423
                Innodb_buffer_pool_reads 961533
                Innodb_buffer_pool_wait_free 0
                Innodb_buffer_pool_write_requests 139240202
                Innodb_data_fsyncs 2592605
                Innodb_data_pending_fsyncs 0
                Innodb_data_pending_reads 0
                Innodb_data_pending_writes 0
                Innodb_data_read 18647288320
                Innodb_data_reads 1139934
                Innodb_data_writes 11365978
                Innodb_data_written 313256403456
                Innodb_dblwr_pages_written 9249731
                Innodb_dblwr_writes 221437
                Innodb_log_waits 0
                Innodb_log_write_requests 16494771
                Innodb_log_writes 1702006
                Innodb_os_log_fsyncs 1819767
                Innodb_os_log_pending_fsyncs 0
                Innodb_os_log_pending_writes 0
                Innodb_os_log_written 10098768384
                Innodb_page_size 16384
                Innodb_pages_created 109297
                Innodb_pages_read 1138135
                Innodb_pages0_read 1789
                Innodb_pages_written 9249862
                Innodb_row_lock_current_waits 0
                Innodb_row_lock_time 15704
                Innodb_row_lock_time_avg 2
                Innodb_row_lock_time_max 256
                Innodb_row_lock_waits 7822
                Innodb_rows_deleted 7384819
                Innodb_rows_inserted 7489037
                Innodb_rows_read 349908815
                Innodb_rows_updated 6886210
                Innodb_system_rows_deleted 0
                Innodb_system_rows_inserted 0
                Innodb_system_rows_read 0
                Innodb_system_rows_updated 0
                Innodb_num_open_files 1792
                Innodb_truncated_status_writes 0
                Innodb_available_undo_logs 128
                Innodb_undo_truncations 0
                Innodb_page_compression_saved 0
                Innodb_num_index_pages_written 0
                Innodb_num_non_index_pages_written 0
                Innodb_num_pages_page_compressed 0
                Innodb_num_page_compressed_trim_op 0
                Innodb_num_pages_page_decompressed 0
                Innodb_num_pages_page_compression_error 0
                Innodb_num_pages_encrypted 0
                Innodb_num_pages_decrypted 0
                Innodb_have_lz4 OFF
                Innodb_have_lzo OFF
                Innodb_have_lzma ON
                Innodb_have_bzip2 OFF
                Innodb_have_snappy OFF
                Innodb_have_punch_hole ON
                Innodb_defragment_compression_failures 0
                Innodb_defragment_failures 0
                Innodb_defragment_count 0
                Innodb_instant_alter_column 0
                Innodb_onlineddl_rowlog_rows 0
                Innodb_onlineddl_rowlog_pct_used 0
                Innodb_onlineddl_pct_progress 0
                Innodb_secondary_index_triggered_cluster_reads 27178749
                Innodb_secondary_index_triggered_cluster_reads_avoided 0
                Innodb_encryption_rotation_pages_read_from_cache 0
                Innodb_encryption_rotation_pages_read_from_disk 0
                Innodb_encryption_rotation_pages_modified 0
                Innodb_encryption_rotation_pages_flushed 0
                Innodb_encryption_rotation_estimated_iops 0
                Innodb_encryption_key_rotation_list_length 0
                Innodb_encryption_n_merge_blocks_encrypted 0
                Innodb_encryption_n_merge_blocks_decrypted 0
                Innodb_encryption_n_rowlog_blocks_encrypted 0
                Innodb_encryption_n_rowlog_blocks_decrypted 0
                Innodb_encryption_n_temp_blocks_encrypted 0
                Innodb_encryption_n_temp_blocks_decrypted 0
                Innodb_scrub_background_page_reorganizations 0
                Innodb_scrub_background_page_splits 0
                Innodb_scrub_background_page_split_failures_underflow 0
                Innodb_scrub_background_page_split_failures_out_of_filespace 0
                Innodb_scrub_background_page_split_failures_missing_index 0
                Innodb_scrub_background_page_split_failures_unknown 0
                Innodb_scrub_log 0
                Innodb_encryption_num_key_requests 0
                Key_blocks_not_flushed 0
                Key_blocks_unused 0
                Key_blocks_used 66282
                Key_blocks_warm 65690
                Key_read_requests 2391483357
                Key_reads 304244
                Key_write_requests 6210334
                Key_writes 5893190
                Last_query_cost 0.000000
                Master_gtid_wait_count 0
                Master_gtid_wait_time 0
                Master_gtid_wait_timeouts 0
                Max_statement_time_exceeded 0
                Max_used_connections 64
                Memory_used 290168752
                Memory_used_initial 223575424
                Not_flushed_delayed_rows 0
                Open_files 1446
                Open_streams 0
                Open_table_definitions 2405
                Open_tables 2711
                Opened_files 261707
                Opened_plugin_libraries 0
                Opened_table_definitions 84046
                Opened_tables 85093
                Opened_views 0
                Performance_schema_accounts_lost 0
                Performance_schema_cond_classes_lost 0
                Performance_schema_cond_instances_lost 0
                Performance_schema_digest_lost 0
                Performance_schema_file_classes_lost 0
                Performance_schema_file_handles_lost 0
                Performance_schema_file_instances_lost 0
                Performance_schema_hosts_lost 0
                Performance_schema_locker_lost 0
                Performance_schema_mutex_classes_lost 0
                Performance_schema_mutex_instances_lost 0
                Performance_schema_rwlock_classes_lost 0
                Performance_schema_rwlock_instances_lost 0
                Performance_schema_session_connect_attrs_lost 0
                Performance_schema_socket_classes_lost 0
                Performance_schema_socket_instances_lost 0
                Performance_schema_stage_classes_lost 0
                Performance_schema_statement_classes_lost 0
                Performance_schema_table_handles_lost 0
                Performance_schema_table_instances_lost 0
                Performance_schema_thread_classes_lost 0
                Performance_schema_thread_instances_lost 0
                Performance_schema_users_lost 0
                Prepared_stmt_count 0
                Qcache_free_blocks 1
                Qcache_free_memory 1031320
                Qcache_hits 0
                Qcache_inserts 0
                Qcache_lowmem_prunes 0
                Qcache_not_cached 0
                Qcache_queries_in_cache 0
                Qcache_total_blocks 1
                Queries 18912711
                Questions 18912551
                Rows_read 6715306706
                Rows_sent 155506861
                Rows_tmp_read 29846909
                Rpl_semi_sync_master_clients 0
                Rpl_semi_sync_master_get_ack 0
                Rpl_semi_sync_master_net_avg_wait_time 0
                Rpl_semi_sync_master_net_wait_time 0
                Rpl_semi_sync_master_net_waits 0
                Rpl_semi_sync_master_no_times 0
                Rpl_semi_sync_master_no_tx 0
                Rpl_semi_sync_master_request_ack 0
                Rpl_semi_sync_master_status OFF
                Rpl_semi_sync_master_timefunc_failures 0
                Rpl_semi_sync_master_tx_avg_wait_time 0
                Rpl_semi_sync_master_tx_wait_time 0
                Rpl_semi_sync_master_tx_waits 0
                Rpl_semi_sync_master_wait_pos_backtraverse 0
                Rpl_semi_sync_master_wait_sessions 0
                Rpl_semi_sync_master_yes_tx 0
                Rpl_semi_sync_slave_send_ack 0
                Rpl_semi_sync_slave_status OFF
                Rpl_status AUTH_MASTER
                Rpl_transactions_multi_engine 0
                Select_full_join 16751
                Select_full_range_join 160
                Select_range 2869992
                Select_range_check 0
                Select_scan 2096110
                Slave_connections 0
                Slave_heartbeat_period 0.000
                Slave_open_temp_tables 0
                Slave_received_heartbeats 0
                Slave_retried_transactions 0
                Slave_running OFF
                Slave_skipped_errors 0
                Slaves_connected 0
                Slaves_running 0
                Slow_launch_threads 0
                Slow_queries 27
                Sort_merge_passes 10771
                Sort_priority_queue_sorts 51602
                Sort_range 454734
                Sort_rows 723399237
                Sort_scan 856886
                Ssl_accept_renegotiates 0
                Ssl_accepts 0
                Ssl_callback_cache_hits 0
                Ssl_cipher
                Ssl_cipher_list
                Ssl_client_connects 0
                Ssl_connect_renegotiates 0
                Ssl_ctx_verify_depth 0
                Ssl_ctx_verify_mode 0
                Ssl_default_timeout 0
                Ssl_finished_accepts 0
                Ssl_finished_connects 0
                Ssl_server_not_after
                Ssl_server_not_before
                Ssl_session_cache_hits 0
                Ssl_session_cache_misses 0
                Ssl_session_cache_mode NONE
                Ssl_session_cache_overflows 0
                Ssl_session_cache_size 0
                Ssl_session_cache_timeouts 0
                Ssl_sessions_reused 0
                Ssl_used_session_cache_entries 0
                Ssl_verify_depth 0
                Ssl_verify_mode 0
                Ssl_version
                Subquery_cache_hit 11661
                Subquery_cache_miss 3983998
                Syncs 338
                Table_locks_immediate 7605148
                Table_locks_waited 5253
                Table_open_cache_active_instances 1
                Table_open_cache_hits 20410622
                Table_open_cache_misses 85092
                Table_open_cache_overflows 80285
                Tc_log_max_pages_used 0
                Tc_log_page_size 4096
                Tc_log_page_waits 0
                Threadpool_idle_threads 0
                Threadpool_threads 0
                Threads_cached 63
                Threads_connected 1
                Threads_created 65
                Threads_running 6
                Transactions_gtid_foreign_engine 0
                Transactions_multi_engine 0
                Update_scan 39
                Uptime 710308
                Uptime_since_flush_status 710308
                wsrep_applier_thread_count 0
                wsrep_cluster_conf_id 18446744073709551615
                wsrep_cluster_size 0
                wsrep_cluster_state_uuid
                wsrep_cluster_status Disconnected
                wsrep_connected OFF
                wsrep_local_bf_aborts 0
                wsrep_local_index 18446744073709551615
                wsrep_provider_name
                wsrep_provider_vendor
                wsrep_provider_version
                wsrep_ready OFF
                wsrep_rollbacker_thread_count 0
                wsrep_thread_count 0
                Powered by vbulletin 5.5.5

                Comment


                • #9
                  Need the Table Status results so I can see the statistics for each table. There should be a drop down that allows you to switch from MySQL Variables to Table Status.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API - Full / Mobile
                  Vote for your favorite feature requests and the bugs you want to see fixed.

                  Comment


                  • #10
                    The section first of all, is called Maintenance / Diagnostics / System Information
                    Under System Information there are 3 pull down menus:
                    MySQL variables
                    MySQL status (which I posted above)
                    Table Status (which is below)
                    Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
                    ad InnoDB 10 Dynamic 3 5461 16384 0 16384 0 4 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    adcriteria InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    adminhelp InnoDB 10 Dynamic 1498 98 147456 0 147456 0 70492 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    administrator InnoDB 10 Dynamic 2 8192 16384 0 0 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    adminlog InnoDB 10 Dynamic 12875 123 1589248 0 1589248 4194304 13035 2019-11-04 00:17:34 2019-11-19 15:54:04 utf8_unicode_ci 0 N
                    adminmessage InnoDB 10 Dynamic 23 712 16384 0 32768 0 24 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    adminutil InnoDB 10 Dynamic 3 5461 16384 0 0 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    album InnoDB 10 Dynamic 25 2621 65536 0 16384 0 26 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    albumupdate InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    announcement InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    announcementread InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    apiclient InnoDB 10 Dynamic 234 350 81920 0 16384 0 237 2019-11-04 00:17:34 2019-11-19 10:06:16 utf8_unicode_ci 0 N
                    apiclient_devicetoken InnoDB 10 Dynamic 45 364 16384 0 16384 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    apilog InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    attach InnoDB 10 Dynamic 524 156 81920 0 16384 0 2019-11-04 00:17:34 2019-11-19 14:56:40 utf8_unicode_ci 0 N
                    attachment InnoDB 10 Dynamic 70 234 16384 0 81920 0 71 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    attachmentcategory InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    attachmentcategoryuser InnoDB 10 Dynamic 70 234 16384 0 32768 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    attachmentpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    attachmenttype InnoDB 10 Dynamic 13 1260 16384 0 0 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    attachmentviews InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    autosavetext InnoDB 10 Dynamic 12 1365 16384 0 49152 0 2019-11-04 00:17:34 2019-11-19 12:04:57 utf8_unicode_ci 0 N
                    avatar InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    bbcode InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    bbcode_video InnoDB 10 Dynamic 9 1820 16384 0 49152 0 10 2019-11-04 00:17:34 utf8_unicode_ci 0 N
                    cache InnoDB 10 Dynamic 21772 3980 86671360 0 3162112 9437184 2019-11-04 00:17:34 2019-11-19 15:52:41 utf8_unicode_ci 0 N
                    cacheevent InnoDB 10 Dynamic 73185 144 10567680 0 7438336 6291456 2019-11-04 00:17:36 2019-11-19 15:52:41 utf8_unicode_ci 0 N
                    calendar InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2019-11-04 00:17:37 utf8_unicode_ci 0 N
                    calendarcustomfield InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:37 utf8_unicode_ci 0 N
                    calendarmoderator InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:37 utf8_unicode_ci 0 N
                    calendarpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:17:37 utf8_unicode_ci 0 N
                    channel InnoDB 10 Dynamic 105 468 49152 0 49152 0 2019-11-04 00:17:37 utf8_unicode_ci 0 N
                    channelprefixset InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:37 utf8_unicode_ci 0 N
                    closure InnoDB 10 Dynamic 316579 38 12075008 0 32571392 6291456 2019-11-04 00:17:37 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    contentpriority InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    contenttype InnoDB 10 Dynamic 32 512 16384 0 16384 0 33 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    cpsession InnoDB 10 Dynamic 1 16384 16384 0 0 0 2019-11-04 00:17:42 2019-11-19 15:54:04 utf8_unicode_ci 0 N
                    cron InnoDB 10 Dynamic 25 655 16384 0 32768 0 46 2019-11-04 00:17:42 2019-11-19 15:51:25 utf8_unicode_ci 0 N
                    cronlog InnoDB 10 Dynamic 35265 74 2637824 0 1589248 4194304 36015 2019-11-04 00:17:42 2019-11-19 14:54:00 utf8_unicode_ci 0 N
                    customavatar InnoDB 10 Dynamic 144 18318 2637824 0 0 4194304 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    customprofile InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    datastore InnoDB 10 Dynamic 59 26936 1589248 0 0 4194304 2019-11-04 00:17:42 2019-11-19 15:51:25 utf8_unicode_ci 0 N
                    dbtech_infopanels_block InnoDB 10 Dynamic 15 1092 16384 0 16384 0 16 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_infopanels_blocktype InnoDB 10 Dynamic 15 1092 16384 0 0 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_thanks_button InnoDB 10 Dynamic 3 5461 16384 0 0 0 4 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_thanks_entry InnoDB 10 Dynamic 189 86 16384 0 98304 0 190 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_thanks_statistics InnoDB 10 Dynamic 6674 54 360448 0 0 0 2019-11-04 00:17:42 2019-11-18 16:58:19 utf8_unicode_ci 0 N
                    dbtech_vbshout_button InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_chatroom InnoDB 10 Dynamic 5 3276 16384 0 16384 0 6 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_chatroommember InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_command InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_deeplog InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_ignorelist InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_instance InnoDB 10 Dynamic 0 0 16384 0 0 0 2 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_log InnoDB 10 Dynamic 28 585 16384 0 0 0 29 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_report InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    dbtech_vbshout_shout InnoDB 10 Dynamic 713 229 163840 0 49152 0 740 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    deletionlog InnoDB 10 Dynamic 357 137 49152 0 16384 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    discussion InnoDB 10 Dynamic 2 8192 16384 0 16384 0 3 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    editlog InnoDB 10 Dynamic 236 69 16384 0 16384 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    event InnoDB 10 Dynamic 0 0 16384 0 32768 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    externalcache InnoDB 10 Dynamic 0 0 16384 0 32768 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    faq InnoDB 10 Dynamic 65 252 16384 0 16384 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    fcmessage InnoDB 10 Dynamic 0 0 16384 0 16384 0 187 2019-11-04 00:17:42 2019-11-19 13:24:46 utf8_unicode_ci 0 N
                    fcmessage_offload InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:42 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    fcmessage_queue InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:42 utf8_unicode_ci 0 N
                    filedata InnoDB 10 Dynamic 614 98223 60309504 0 98304 0 727 2019-11-04 00:17:42 2019-11-19 10:02:09 utf8_unicode_ci 0 N
                    filedataresize InnoDB 10 Dynamic 659 11958 7880704 0 16384 4194304 2019-11-04 00:17:44 2019-11-19 09:26:49 utf8_unicode_ci 0 N
                    forumpermission InnoDB 10 Dynamic 9 1820 16384 0 16384 0 11 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    forumrunner_attachment InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    forumrunner_push_data InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    forumrunner_push_users InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    gallery InnoDB 10 Dynamic 46 356 16384 0 0 0 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    groupintopic InnoDB 10 Dynamic 5 3276 16384 0 16384 0 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    holiday InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    hook InnoDB 10 Dynamic 31 528 16384 0 32768 0 163 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    humanverify InnoDB 10 Dynamic 0 0 16384 0 32768 0 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    hvanswer InnoDB 10 Dynamic 15 1092 16384 0 16384 0 28 2019-11-04 00:17:44 utf8_unicode_ci 0 N
                    hvquestion InnoDB 10 Dynamic 8 2048 16384 0 0 0 13 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    icon InnoDB 10 Dynamic 14 1170 16384 0 0 0 15 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    imagecategory InnoDB 10 Dynamic 5 3276 16384 0 0 0 6 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    imagecategorypermission InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    infraction InnoDB 10 Dynamic 28 585 16384 0 65536 0 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    infractionban InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    infractiongroup InnoDB 10 Dynamic 0 0 16384 0 16384 0 3 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    infractionlevel InnoDB 10 Dynamic 5 3276 16384 0 0 0 6 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    ipaddressinfo InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    itrader InnoDB 10 Dynamic 98 167 16384 0 49152 0 100 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    itrader_comments InnoDB 10 Dynamic 98 167 16384 0 32768 0 100 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    language MyISAM 10 Dynamic 1 743780 743780 281474976710655 2048 0 2 2019-11-04 00:17:45 2019-11-04 00:17:45 utf8_unicode_ci 1125899906841600 N
                    legacyevent InnoDB 10 Dynamic 0 0 16384 0 65536 0 1 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    link InnoDB 10 Dynamic 16 1024 16384 0 16384 0 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    loginlibrary InnoDB 10 Dynamic 2 8192 16384 0 16384 0 3 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    mailqueue InnoDB 10 Dynamic 0 0 16384 0 0 0 111 2019-11-04 00:17:45 2019-11-19 12:23:09 utf8_unicode_ci 0 N
                    mapiposthash InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    messagefolder InnoDB 10 Dynamic 32700 48 1589248 0 2129920 4194304 38110 2019-11-04 00:17:45 2019-11-19 10:57:20 utf8_unicode_ci 0 N
                    moderation InnoDB 10 Dynamic 74 221 16384 0 16384 0 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    moderator InnoDB 10 Dynamic 2 8192 16384 0 32768 0 3 2019-11-04 00:17:45 utf8_unicode_ci 0 N
                    moderatorlog InnoDB 10 Dynamic 5525 287 1589248 0 606208 4194304 5562 2019-11-04 00:17:45 2019-11-18 22:56:47 utf8_unicode_ci 0 N
                    node InnoDB 10 Dynamic 65197 314 20496384 0 59752448 4194304 91231 2019-11-04 00:17:45 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    nodehash InnoDB 10 Dynamic 43 381 16384 0 32768 0 2019-11-04 00:17:53 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    noderead InnoDB 10 Dynamic 187 87 16384 0 16384 0 2019-11-04 00:17:53 2019-11-19 14:31:39 utf8_unicode_ci 0 N
                    nodeview InnoDB 10 Dynamic 2252 43 98304 0 0 0 2019-11-04 00:17:53 2019-11-19 15:25:30 utf8_unicode_ci 0 N
                    notice InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    noticecriteria InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    noticedismissed InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    notification InnoDB 10 Dynamic 709 184 131072 0 180224 0 1396 2019-11-04 00:17:53 2019-11-18 19:59:38 utf8_unicode_ci 0 N
                    notificationevent InnoDB 10 Dynamic 16 1024 16384 0 16384 0 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    notificationtype InnoDB 10 Dynamic 12 1365 16384 0 32768 0 13 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    oasl_identity InnoDB 10 Dynamic 400 163 65536 0 16384 0 415 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    oasl_session InnoDB 10 Dynamic 1 16384 16384 0 32768 0 1515 2019-11-04 00:17:53 2019-11-19 14:31:07 utf8_unicode_ci 0 N
                    oasl_user InnoDB 10 Dynamic 398 164 65536 0 65536 0 413 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    package InnoDB 10 Dynamic 3 5461 16384 0 16384 0 4 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    page InnoDB 10 Dynamic 235 418 98304 0 0 0 238 2019-11-04 00:17:53 utf8_unicode_ci 0 N
                    pagetemplate InnoDB 10 Dynamic 45 364 16384 0 0 0 57 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    passwordhistory InnoDB 10 Dynamic 3352 122 409600 0 114688 0 2019-11-04 00:17:54 2019-11-19 10:57:19 utf8_unicode_ci 0 N
                    paymentapi InnoDB 10 Dynamic 8 2048 16384 0 0 0 9 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    paymentinfo InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    paymenttransaction InnoDB 10 Dynamic 0 0 16384 0 49152 0 1 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    permission InnoDB 10 Dynamic 130 126 16384 0 49152 0 161 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    photo InnoDB 10 Dynamic 94 174 16384 0 16384 0 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    phrase InnoDB 10 Dynamic 14247 258 3686400 0 3473408 4194304 543246 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    phrasetype InnoDB 10 Dynamic 70 234 16384 0 0 0 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    poll InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    polloption InnoDB 10 Dynamic 10 1638 16384 0 16384 0 11 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    pollvote InnoDB 10 Dynamic 24 682 16384 0 65536 0 25 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    post_thanks InnoDB 10 Dynamic 323 50 16384 0 16384 0 648 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    postedithistory InnoDB 10 Dynamic 483 3290 1589248 0 32768 4194304 635 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    postindex InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    prefix InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    prefixpermission InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    prefixset InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    privacyconsent InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:17:54 utf8_unicode_ci 0 N
                    privatemessage InnoDB 10 Dynamic 55648 47 2637824 0 0 4194304 2019-11-04 00:17:54 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    product InnoDB 10 Dynamic 14 1170 16384 0 16384 0 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    productcode InnoDB 10 Dynamic 32 512 16384 0 16384 0 235 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    productdependency InnoDB 10 Dynamic 13 1260 16384 0 0 0 81 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    profilefield InnoDB 10 Dynamic 5 3276 16384 0 32768 0 6 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    profilefieldcategory InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    profilevisitor InnoDB 10 Dynamic 1630 70 114688 0 65536 0 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    ranks InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    redirect InnoDB 10 Dynamic 4 4096 16384 0 16384 0 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    report InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    reputation InnoDB 10 Dynamic 129 127 16384 0 65536 0 133 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    reputationlevel InnoDB 10 Dynamic 15 1092 16384 0 16384 0 16 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    routenew InnoDB 10 Dynamic 277 650 180224 0 131072 0 287 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    rssfeed InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    rsslog InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    screenlayout InnoDB 10 Dynamic 11 1489 16384 0 32768 0 13 2019-11-04 00:17:55 utf8_unicode_ci 0 N
                    searchlog InnoDB 10 Dynamic 1 16384 16384 0 65536 5242880 7267373 2019-11-04 00:17:55 2019-11-19 15:52:41 utf8_unicode_ci 0 N
                    searchtowords_a InnoDB 10 Dynamic 121231 47 5783552 0 3686400 4194304 2019-11-04 00:17:55 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_b InnoDB 10 Dynamic 66222 39 2637824 0 1589248 4194304 2019-11-04 00:17:56 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_c InnoDB 10 Dynamic 160243 42 6832128 0 3686400 4194304 2019-11-04 00:17:57 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_d InnoDB 10 Dynamic 62809 41 2637824 0 1589248 4194304 2019-11-04 00:17:58 2019-11-19 10:02:10 utf8_unicode_ci 0 N
                    searchtowords_e InnoDB 10 Dynamic 101222 46 4734976 0 2637824 4194304 2019-11-04 00:17:59 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_f InnoDB 10 Dynamic 102974 45 4734976 0 2637824 4194304 2019-11-04 00:18:00 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_g InnoDB 10 Dynamic 52549 50 2637824 0 1589248 4194304 2019-11-04 00:18:01 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_h InnoDB 10 Dynamic 71355 51 3686400 0 2637824 4194304 2019-11-04 00:18:01 2019-11-19 00:55:14 utf8_unicode_ci 0 N
                    searchtowords_i InnoDB 10 Dynamic 82483 44 3686400 0 2637824 4194304 2019-11-04 00:18:02 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_j InnoDB 10 Dynamic 3991 45 180224 0 98304 0 2019-11-04 00:18:03 2019-11-19 05:35:29 utf8_unicode_ci 0 N
                    searchtowords_k InnoDB 10 Dynamic 8917 42 376832 0 212992 0 2019-11-04 00:18:03 2019-11-18 07:47:24 utf8_unicode_ci 0 N
                    searchtowords_l InnoDB 10 Dynamic 75179 49 3686400 0 2637824 4194304 2019-11-04 00:18:03 2019-11-19 00:55:34 utf8_unicode_ci 0 N
                    searchtowords_m InnoDB 10 Dynamic 113232 41 4734976 0 2637824 4194304 2019-11-04 00:18:03 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_n InnoDB 10 Dynamic 30764 51 1589248 0 1589248 4194304 2019-11-04 00:18:04 2019-11-19 00:07:56 utf8_unicode_ci 0 N
                    searchtowords_o InnoDB 10 Dynamic 30764 51 1589248 0 1589248 4194304 2019-11-04 00:18:05 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_other InnoDB 10 Dynamic 32912 48 1589248 0 1589248 4194304 2019-11-04 00:18:05 2019-11-19 00:55:14 utf8_unicode_ci 0 N
                    searchtowords_p InnoDB 10 Dynamic 175191 38 6832128 0 4734976 4194304 2019-11-04 00:18:05 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_q InnoDB 10 Dynamic 6771 43 294912 0 147456 0 2019-11-04 00:18:07 2019-11-18 15:05:37 utf8_unicode_ci 0 N
                    searchtowords_r InnoDB 10 Dynamic 104697 45 4734976 0 2637824 4194304 2019-11-04 00:18:07 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_s InnoDB 10 Dynamic 207652 43 8929280 0 4734976 4194304 2019-11-04 00:18:08 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_t InnoDB 10 Dynamic 85453 43 3686400 0 2637824 4194304 2019-11-04 00:18:10 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_u InnoDB 10 Dynamic 27347 58 1589248 0 1589248 4194304 2019-11-04 00:18:11 2019-11-19 00:55:14 utf8_unicode_ci 0 N
                    searchtowords_v InnoDB 10 Dynamic 20834 76 1589248 0 491520 4194304 2019-11-04 00:18:11 2019-11-19 00:55:14 utf8_unicode_ci 0 N
                    searchtowords_w InnoDB 10 Dynamic 49140 53 2637824 0 1589248 4194304 2019-11-04 00:18:11 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    searchtowords_x InnoDB 10 Dynamic 247 66 16384 0 16384 0 2019-11-04 00:18:12 utf8_unicode_ci 0 N
                    searchtowords_y InnoDB 10 Dynamic 6299 44 278528 0 147456 0 2019-11-04 00:18:12 2019-11-19 00:55:14 utf8_unicode_ci 0 N
                    searchtowords_z InnoDB 10 Dynamic 370 44 16384 0 16384 0 2019-11-04 00:18:12 2019-11-19 00:11:44 utf8_unicode_ci 0 N
                    sentto InnoDB 10 Dynamic 118825 92 11026432 0 12107776 4194304 2019-11-04 00:18:12 2019-11-19 12:19:11 utf8_unicode_ci 0 N
                    session InnoDB 10 Dynamic 99 10757 1064960 0 81920 7340032 2019-11-04 00:18:14 2019-11-19 15:52:41 utf8_unicode_ci 0 N
                    sessionauth InnoDB 10 Dynamic 3 5461 16384 0 16384 0 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    setting InnoDB 10 Dynamic 560 204 114688 0 16384 0 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    settinggroup InnoDB 10 Dynamic 67 244 16384 0 0 0 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    sigparsed InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    sigpic InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    sigpicnew InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    site InnoDB 10 Dynamic 0 0 16384 0 0 0 2 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    smilie InnoDB 10 Dynamic 307 373 114688 0 0 0 308 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    spamlog InnoDB 10 Dynamic 312 52 16384 0 0 0 2019-11-04 00:18:14 2019-11-18 16:58:16 utf8_unicode_ci 0 N
                    stats InnoDB 10 Dynamic 3277 44 147456 0 0 0 2019-11-04 00:18:14 2019-11-18 19:50:18 utf8_unicode_ci 0 N
                    strikes InnoDB 10 Dynamic 2 8192 16384 0 49152 0 2019-11-04 00:18:14 2019-11-19 15:51:47 utf8_unicode_ci 0 N
                    style InnoDB 10 Dynamic 36 218908 7880704 0 16384 0 56 2019-11-04 00:18:14 utf8_unicode_ci 0 N
                    stylevar InnoDB 10 Dynamic 1454 360 524288 0 0 0 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    stylevardfn InnoDB 10 Dynamic 464 176 81920 0 0 0 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    subscribediscussion InnoDB 10 Dynamic 471 104 49152 0 32768 0 514 2019-11-04 00:18:15 2019-11-17 03:02:17 utf8_unicode_ci 0 N
                    subscribeevent InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    subscription InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    subscriptionlog InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    subscriptionpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    tachyforumcounter InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    tachyforumpost InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    tachythreadcounter InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    tachythreadpost InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    tag InnoDB 10 Dynamic 2714 54 147456 0 147456 0 2763 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    tagnode InnoDB 10 Dynamic 6403 43 278528 0 851968 4194304 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    tagsearch InnoDB 10 Dynamic 11214 36 409600 0 475136 0 2019-11-04 00:18:15 2019-11-19 15:52:41 utf8_unicode_ci 0 N
                    template InnoDB 10 Dynamic 1143 19738 22560768 0 81920 4194304 26118 2019-11-04 00:18:15 utf8_unicode_ci 0 N
                    templatehistory InnoDB 10 Dynamic 6 13653 81920 0 16384 0 30 2019-11-04 00:18:16 utf8_unicode_ci 0 N
                    templatemerge InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:16 utf8_unicode_ci 0 N
                    text InnoDB 10 Dynamic 52351 2956 154796032 0 0 7340032 2019-11-04 00:18:16 2019-11-19 12:18:57 utf8_unicode_ci 0 N
                    thread_post InnoDB 10 Dynamic 1072 61 65536 0 81920 0 2019-11-04 00:18:20 utf8_unicode_ci 0 N
                    trending InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:18:20 2019-11-18 22:56:47 utf8_unicode_ci 0 N
                    upgradelog InnoDB 10 Dynamic 2181 60 131072 0 98304 0 3164 2019-11-04 00:18:20 utf8_unicode_ci 0 N
                    user InnoDB 10 Dynamic 7489 1892 14172160 0 2981888 4194304 8364 2019-11-04 00:18:20 2019-11-19 15:51:53 utf8_unicode_ci 0 N
                    useractivation InnoDB 10 Dynamic 99 165 16384 0 16384 0 8482 2019-11-04 00:18:21 2019-11-19 10:57:19 utf8_unicode_ci 0 N
                    userauth InnoDB 10 Dynamic 110 148 16384 0 32768 0 2019-11-04 00:18:21 utf8_unicode_ci 0 N
                    userban InnoDB 10 Dynamic 517 126 65536 0 16384 0 2019-11-04 00:18:21 2019-11-18 22:56:47 utf8_unicode_ci 0 N
                    userchangelog InnoDB 10 Dynamic 6894 230 1589248 0 1376256 4194304 7025 2019-11-04 00:18:21 2019-11-18 22:56:47 utf8_unicode_ci 0 N
                    userfield InnoDB 10 Dynamic 8309 39 327680 0 0 0 2019-11-04 00:18:21 2019-11-19 10:57:19 utf8_unicode_ci 0 N
                    usergroup InnoDB 10 Dynamic 19 862 16384 0 0 0 21 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    usergroupleader InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    usergrouprequest InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    userlist InnoDB 10 Dynamic 281 58 16384 0 32768 0 2019-11-04 00:18:22 2019-11-13 16:52:10 utf8_unicode_ci 0 N
                    userloginmfa InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    usernote InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    userpromotion InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    userstylevar InnoDB 10 Dynamic 18 910 16384 0 0 0 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    usertextfield InnoDB 10 Dynamic 8309 35 294912 0 0 0 2019-11-04 00:18:22 2019-11-19 10:57:19 utf8_unicode_ci 0 N
                    usertitle InnoDB 10 Dynamic 5 3276 16384 0 0 0 6 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    vbseo_blacklist InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    vbseo_linkback InnoDB 10 Dynamic 58 847 49152 0 65536 0 59 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    vbseo_serviceupdate InnoDB 10 Dynamic 348 47 16384 0 16384 0 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    video InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    videoitem InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    widget InnoDB 10 Dynamic 83 592 49152 0 32768 0 270 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    widgetchannelconfig InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    widgetdefinition InnoDB 10 Dynamic 486 235 114688 0 32768 0 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    widgetinstance InnoDB 10 Dynamic 202 486 98304 0 16384 0 210 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    widgetuserconfig InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-11-04 00:18:22 utf8_unicode_ci 0 N
                    words InnoDB 10 Dynamic 37420 70 2637824 0

                    Comment


                    • #11
                      On average your system is waiting 2 milliseconds before it gets a lock. This should be fast enough to prevent a deadlock. However, please set a innodb_lock_wait_timeout value in your database config file is should have a minimum value of 10 (seconds) but not exceed the wait_timeout value. Though, I don't see a wait_timeout defined and don't know what the default is on MariaDB.

                      Personally, I think the system should try to catch these errors and retry the transaction. I've created an improvement request to do that - https://tracker.vbulletin.com/vbulle...sues/VBV-19851
                      Last edited by Wayne Luke; Tue 19th Nov '19, 1:51pm.
                      Translations provided by Google.

                      Wayne Luke
                      The Rabid Badger - a vBulletin Cloud demonstration site.
                      vBulletin 5 API - Full / Mobile
                      Vote for your favorite feature requests and the bugs you want to see fixed.

                      Comment


                      • #12
                        My host took a look at those settings, and right now both are set to their defaults:
                        ---
                        https://mariadb.com/kb/en/library/in...k_wait_timeout
                        | innodb_lock_wait_timeout | 50

                        https://mariadb.com/kb/en/library/se.../#wait_timeout
                        | wait_timeout | 28800

                        Comment


                        • #13
                          This
                          Database error in vBulletin 5.5.5:

                          Invalid SQL:
                          /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
                          ('node_91396_lvl1data','nodeChg_91396'),
                          ('node_91345_lvl1data','nodeChg_91345'),

                          ('node_64249_lvl1data','nodeChg_64249'),
                          ('node_64229_lvl1data','nodeChg_64229');

                          MySQL Error : Deadlock found when trying to get lock; try restarting transaction
                          Error Number : 1213
                          Request Date : Friday, November 29th 2019 @ 12:40:07 AM
                          Error Date : Friday, November 29th 2019 @ 12:40:09 AM
                          Script :
                          Referrer :
                          IP Address : 64.91.XXX.XX
                          Username : Guest
                          Classname : vB_Database_MySQLi
                          MySQL Version :

                          Stack Trace:
                          #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
                          #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
                          #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 561
                          #3 vB_Database->query_write() called in [path]/vb/db/mysql/querydefs.php on line 7214
                          #4 vB_dB_MYSQL_QueryDefs->saveDbCache() called in [path]/vb/db/query/method.php on line 175
                          #5 vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 301
                          #6 vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 387
                          #7 vB_Cache_Db->shutdown() called in [path]/vb/shutdown.php on line 93
                          #8 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 483
                          #9 vB::shutdown() called in on line

                          database error is the only one I am still experiencing, do I just need to live with it?

                          Comment


                          • NumNum
                            NumNum commented
                            Editing a comment
                            Thanks for the info.

                        • #14
                          Until we catch it and retry the transaction per my bug report above, you would have to live with it. We don't experience this issue on this site. It doesn't occur on the vBulletin Cloud sites that we support. So I am not sure why you're experiencing it. It could be because we use Memcached for our primary caching. Errors that we cannot recreate on demand are the most difficult to fix.

                          You can try using Memcached to see if it that helps with the issue. If you're not using MYSQL 8.0, then you can switch this. If you're using MariaDB, you should know that we do not test on this server. I recommend using 10.3 at a minimum to make sure you have the best possible version.
                          Translations provided by Google.

                          Wayne Luke
                          The Rabid Badger - a vBulletin Cloud demonstration site.
                          vBulletin 5 API - Full / Mobile
                          Vote for your favorite feature requests and the bugs you want to see fixed.

                          Comment


                          • #15
                            Using mariadb 10.3 (the latest) because mySQL 8 not available on my server. Most cpanel servers don't include the latest mySQL anymore, just the latest mariaDB

                            The host had responded re: memcached:
                            * Memcached
                            That is already installed and running on the system, so it'd just be a matter of ensuring that you configure vBulletin to use it ***Is it configured to use it?

                            Comment

                            Related Topics

                            Collapse

                            Working...
                            X