Announcement

Collapse
No announcement yet.

Performance help

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

  • lottidah
    replied
    Thanks, Wayne! Things slowed down again yesterday during our football game and I was lucky enough to get a helpful technician when I opened a ticket with the host. They found three IPs hitting the server pretty hard, some unneeded processes that were using up memory, and they added some swap memory they said. Things have been pretty good since blocking those IPs and since the host did their tweaks.

    Leave a comment:


  • Wayne Luke
    replied
    You would have to look in the configuration files for your web server. There should be handlers added that tell the system what application to run for specific requests. The PHP information provided tells me that you're using CGI/FastCGI but not how it is called by the system. You would need to research CGI/FastCGI optimization tutorials on the web to handle the processes.

    Leave a comment:


  • lottidah
    replied
    1. Install PHP Opcache. It will take effect immediately with the next process load. -- Done
    2. Install MemcacheD and use it. -- will consider if still needed
    3. Make sure CSS and SVG is stored in the File System (AdminCP -> Settings -> Options -> Style and Language Settings) -- Done
    4. Reduce the PHP memory_limit setting to 128MB. This should be sufficient for your site. -- Done
    5. Remove the Cache Delete Scheduled Task you have installed. -- Done
    I have questions about this comment:

    Make sure your php-cgi processes are getting killed efficiently. If you have too many processes sitting around and doing nothing, then they will quickly eat your resources. This is different from using mod_php as the PHP process is killed as soon as the page is rendered and sent to the user. They don't hang around and eat resources. If you're using mod_fcgid to spawn your PHP Processes, you should look for an optimization tutorial or three.
    How do I know what I'm using to spawn my PHP Processes? And what is recommended?

    Leave a comment:


  • lottidah
    replied
    Thank you, I will investigate each of those items. We have two custom usergroups. The majority of our users belong to one of the custom groups.

    Thanks

    Leave a comment:


  • Wayne Luke
    replied
    Make sure your php-cgi processes are getting killed efficiently. If you have too many processes sitting around and doing nothing, then they will quickly eat your resources. This is different from using mod_php as the PHP process is killed as soon as the page is rendered and sent to the user. They don't hang around and eat resources. If you're using mod_fcgid to spawn your PHP Processes, you should look for an optimization tutorial or three.

    For vBulletin configuration, try these steps:
    1. Install PHP Opcache. It will take effect immediately with the next process load.
    2. Install MemcacheD and use it.
    3. Make sure CSS and SVG is stored in the File System (AdminCP -> Settings -> Options -> Style and Language Settings)
    4. Reduce the PHP memory_limit setting to 128MB. This should be sufficient for your site.
    5. Remove the Cache Delete Scheduled Task you have installed.

    You should also consider breaking topics up into multiple forum channels instead of just the two you have. This will allow for smaller cache keys that need to be loaded on every page load. I also recommend at least 4 GB of RAM per core of CPU. This simply allows 64 Bit CPUs to operate more efficiently.

    Do you have custom usergroups? If so, how many?

    Leave a comment:


  • lottidah
    replied
    I'm on a managed VPS but of course they don't manage the forum itself. I appreciate the Cloud suggestion but we wanted the ability to customize the forum more than the Cloud solution allowed. I am able to handle tasks at the root as needed.

    Attached is a zip file containing the PHP info, the Table Status, and the Database Status information you requested. Would you mind reviewing them to see if anything sticks out?

    Thank you so much!
    Attached Files

    Leave a comment:


  • Wayne Luke
    replied
    Really not getting enough information to determine what the problem is. What is the entire contents of your PHP Info? You can see this in Maintenance -> View PHP Info. What is the entire table status of your database? You can see this under Maintenance -> Diagnostics -> System Variables. What are the settings for MariaDB? Again under Maintenance -> Diagnostics -> System Variables.

    Large sites usually use a Cloud based hosting system and have a Systems Administrator fluent in Linux and Apache configuration on hand to handle their sites. It seems you're on an unmanaged server but don't necessarily have the knowledge to manage the server yourself. It might be that vBulletin Cloud is the best solution for your site.

    Leave a comment:


  • lottidah
    replied
    Hi again. Our first NFL game of the season was Sunday and our forum was again pretty slow, eventually crashing as it ran out of memory.

    I've asked the host to investigate, here's their response:

    On checking, we could see that your server is currently single-core and has 3 GB of memory. From, previous memory and load information, we could see that almost whole memory is being used up on average. Please refer to the below snippet. (Removed since it didn't paste well.) We could also see that at the below mentioned time, the load was above the recommended value of 1 since you have a single-core server. So we would suggest upgrading your VPS server to higher specifications so that it meets your required criteria.
    We used up all of the memory and processing power with only about 100 users online at the time. Good lord, what do forums that are actually popular do?! I feel like there is totally a misconfiguration somewhere but I'm just not technical enough to know where. Last time I complained here was during the NFL draft. I upgraded vB versions (now at 5.5.2), updated PHP to 7.2.22, and moved to the MariaDB 10.3.17 at the time. The start of the NFL season was the first real stress test since then.

    Do we really need more cores and more memory? We were running good last year before our host was bought by another.

    Leave a comment:


  • Wayne Luke
    replied
    You might discuss Memcached with your hosting provider. If it is available, you can move some of the caching and datastore out of your database and gain some performance benefits.

    The OPcache library built into PHP does something different. What it does is store the compiled versions of the PHP files on your server in shared memory. This helps with reducing disk access on different page loads as well as reducing the time the PHP interpreter needs to spend compiling the files.

    Using both can boost your performance.

    Leave a comment:


  • lottidah
    replied
    I think I'm just using opcache.

    There isn't much appetite for breaking the channels into sub-topics.

    Leave a comment:


  • Wayne Luke
    replied
    Are you using Memcached or PHP's opcache?

    5.5.2 has a fix that should allow your channels to load quicker. You seem to have only two channels with a lot of topics in each. Breaking those up into different sections can also improve performance.

    Leave a comment:


  • lottidah
    replied
    I have updated my PHP version to 7.2 and upgraded the database to MariaDB 10.3. Next up is the vBulletin version upgrade to 5.5.1. Unfortunately, I can't really tell if anything I've done so far is helping since the draft is over and traffic has returned to normal. :/

    Leave a comment:


  • lottidah
    replied
    Originally posted by Wayne Luke View Post
    Please convert your MyISAM tables to INNODB. Do not convert language or phrase at this time.
    Done!
    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
    ad InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2018-10-12 04:31:00 latin1_swedish_ci
    adcriteria InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:48 latin1_swedish_ci
    adminhelp InnoDB 10 Dynamic 1484 88 131072 0 98304 0 23372 2018-10-12 04:28:21 latin1_swedish_ci
    administrator InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:27:57 latin1_swedish_ci
    adminlog InnoDB 10 Dynamic 15257 104 1589248 0 1589248 4194304 15671 2018-10-12 04:32:48 2019-04-29 19:00:53 latin1_swedish_ci
    adminmessage InnoDB 10 Dynamic 13 1260 16384 0 32768 0 14 2018-10-12 04:32:39 latin1_swedish_ci
    adminutil InnoDB 10 Dynamic 3 5461 16384 0 0 0 2018-10-12 04:31:11 latin1_swedish_ci
    album InnoDB 10 Dynamic 17 963 16384 0 16384 0 20 2019-04-29 18:26:48 2019-04-29 18:26:48 latin1_swedish_ci
    albumupdate InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-04-29 18:27:51 latin1_swedish_ci
    announcement InnoDB 10 Dynamic 7 2340 16384 0 49152 0 13 2018-10-12 04:30:20 latin1_swedish_ci
    announcementread InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:32:48 latin1_swedish_ci
    apiclient InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:31:15 latin1_swedish_ci
    apiclient_devicetoken InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:30:52 latin1_swedish_ci
    apilog InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:47 latin1_swedish_ci
    attach InnoDB 10 Dynamic 4450 73 327680 0 81920 0 2018-10-12 04:32:45 latin1_swedish_ci
    attachment InnoDB 10 Dynamic 4075 88 360448 0 589824 0 4819 2019-04-29 18:28:32 2019-04-29 18:28:32 latin1_swedish_ci
    attachmentcategory InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:47 latin1_swedish_ci
    attachmentcategoryuser InnoDB 10 Dynamic 4003 61 245760 0 212992 0 2018-10-12 04:32:48 latin1_swedish_ci
    attachmentpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:32:45 latin1_swedish_ci
    attachmenttype InnoDB 10 Dynamic 12 1365 16384 0 0 0 2018-10-12 04:32:39 latin1_swedish_ci
    attachmentviews InnoDB 10 Dynamic 2 8192 16384 0 16384 0 2018-10-12 04:32:13 latin1_swedish_ci
    automediaembed InnoDB 10 Dynamic 265 865 229376 0 0 0 487 2019-04-29 18:29:15 2019-04-29 18:29:15 latin1_swedish_ci
    autosavetext InnoDB 10 Dynamic 95 689 65536 0 49152 4194304 2018-10-12 04:32:48 2019-04-29 18:51:27 latin1_swedish_ci
    avatar InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:31:15 latin1_swedish_ci
    bbcode InnoDB 10 Dynamic 3 5461 16384 0 16384 0 9 2018-10-12 04:27:56 latin1_swedish_ci
    bbcode_video InnoDB 10 Dynamic 9 1820 16384 0 49152 0 10 2018-10-12 04:28:57 latin1_swedish_ci
    cache InnoDB 10 Dynamic 21376 5421 115900416 0 1376256 5242880 2018-10-12 04:32:46 2019-04-29 19:00:53 latin1_swedish_ci
    cacheevent InnoDB 10 Dynamic 30760 182 5603328 0 3457024 4194304 2018-10-12 04:31:21 2019-04-29 19:00:53 latin1_swedish_ci
    calendar InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2018-10-12 04:31:11 latin1_swedish_ci
    calendarcustomfield InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:29:15 latin1_swedish_ci
    calendarmoderator InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:31:16 latin1_swedish_ci
    calendarpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:28:53 latin1_swedish_ci
    channel InnoDB 10 Dynamic 23 712 16384 0 16384 0 2018-10-12 04:32:33 latin1_swedish_ci
    channelprefixset InnoDB 10 Dynamic 8 2048 16384 0 0 0 2018-10-12 04:32:14 latin1_swedish_ci
    closure InnoDB 10 Dynamic 6470476 39 252477440 0 473513984 6291456 2018-10-12 04:32:33 2019-04-29 18:52:41 latin1_swedish_ci
    contentpriority InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:41 latin1_swedish_ci
    contenttype InnoDB 10 Dynamic 32 512 16384 0 16384 0 33 2018-10-12 04:28:54 latin1_swedish_ci
    cpsession InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:28:53 2019-04-29 19:00:53 latin1_swedish_ci
    cron InnoDB 10 Dynamic 25 655 16384 0 32768 0 35 2018-10-12 04:30:47 2019-04-29 18:51:34 latin1_swedish_ci
    cronlog InnoDB 10 Dynamic 19985 79 1589248 0 1589248 4194304 36687 2018-10-12 04:28:56 2019-04-29 18:51:37 latin1_swedish_ci
    customavatar InnoDB 10 Dynamic 557 117 65536 0 0 0 2018-10-12 04:32:49 latin1_swedish_ci
    customprofile InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:28:53 latin1_swedish_ci
    customprofilepic InnoDB 10 Dynamic 265 185 49152 0 0 0 2018-10-12 04:31:21 latin1_swedish_ci
    datastore InnoDB 10 Dynamic 62 4756 294912 0 0 0 2018-10-12 04:32:14 2019-04-29 18:56:28 latin1_swedish_ci
    deletionlog InnoDB 10 Dynamic 7894 64 507904 0 212992 0 2018-10-12 04:32:46 latin1_swedish_ci
    discussion InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2018-10-12 04:32:33 latin1_swedish_ci
    editlog InnoDB 10 Dynamic 40322 91 3686400 0 1589248 4194304 2018-10-12 04:30:18 latin1_swedish_ci
    event InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:30:47 latin1_swedish_ci
    externalcache InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:31:26 latin1_swedish_ci
    faq InnoDB 10 Dynamic 64 256 16384 0 16384 0 2018-10-12 04:32:47 latin1_swedish_ci
    fcmessage InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:30:40 latin1_swedish_ci
    fcmessage_offload InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:41 latin1_swedish_ci
    fcmessage_queue InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:27:56 latin1_swedish_ci
    filedata InnoDB 10 Dynamic 4741 69562 329793536 0 688128 301989888 7063 2018-10-12 04:32:47 latin1_swedish_ci
    filedataresize InnoDB 10 Dynamic 5390 3018 16269312 0 98304 13631488 2018-10-12 04:32:45 latin1_swedish_ci
    forumpermission InnoDB 10 Dynamic 5 3276 16384 0 16384 0 6 2018-10-12 04:32:43 latin1_swedish_ci
    forumrunner_attachment InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-04-29 18:29:56 latin1_swedish_ci
    forumrunner_push_data InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-04-29 18:30:12 latin1_swedish_ci
    forumrunner_push_users InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2019-04-29 18:30:28 latin1_swedish_ci
    gallery InnoDB 10 Dynamic 26 630 16384 0 0 0 2018-10-12 04:32:48 latin1_swedish_ci
    groupintopic InnoDB 10 Dynamic 4 4096 16384 0 16384 0 2018-10-12 04:32:45 latin1_swedish_ci
    holiday InnoDB 10 Dynamic 5 3276 16384 0 0 0 6 2018-10-12 04:27:57 latin1_swedish_ci
    hook InnoDB 10 Dynamic 12 1365 16384 0 32768 0 34 2018-10-12 04:28:57 latin1_swedish_ci
    humanverify InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:32:45 latin1_swedish_ci
    hvanswer InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:43 latin1_swedish_ci
    hvquestion InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:28:53 latin1_swedish_ci
    icon InnoDB 10 Dynamic 14 1170 16384 0 0 0 16 2018-10-12 04:32:49 latin1_swedish_ci
    imagecategory InnoDB 10 Dynamic 3 5461 16384 0 0 0 4 2018-10-12 04:32:41 latin1_swedish_ci
    imagecategorypermission InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:31:00 latin1_swedish_ci
    infraction InnoDB 10 Dynamic 8 2048 16384 0 65536 0 2018-10-12 04:28:57 latin1_swedish_ci
    infractionban InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:48 latin1_swedish_ci
    infractiongroup InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:28:53 latin1_swedish_ci
    infractionlevel InnoDB 10 Dynamic 4 4096 16384 0 0 0 5 2018-10-12 04:32:40 latin1_swedish_ci
    ipaddressinfo InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:31:15 latin1_swedish_ci
    language MyISAM 10 Dynamic 1 650936 650936 281474976710655 2048 0 2 2018-05-30 10:11:05 2019-04-24 13:15:59 2018-06-12 17:20:12 latin1_swedish_ci
    legacyevent InnoDB 10 Dynamic 10 1638 16384 0 65536 0 12 2019-04-29 18:31:17 2019-04-29 18:31:17 latin1_swedish_ci
    link InnoDB 10 Dynamic 62 792 49152 0 16384 0 2018-10-12 04:32:49 latin1_swedish_ci
    loginlibrary InnoDB 10 Dynamic 1 16384 16384 0 16384 0 3 2018-10-12 04:32:46 latin1_swedish_ci
    mailqueue InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:32:14 latin1_swedish_ci
    mapiposthash InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:43 latin1_swedish_ci
    messagefolder InnoDB 10 Dynamic 1392 58 81920 0 98304 0 2871 2018-10-12 04:27:57 latin1_swedish_ci
    moderation InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:32:33 latin1_swedish_ci
    moderator InnoDB 10 Dynamic 26 630 16384 0 32768 0 53 2018-10-12 04:32:33 latin1_swedish_ci
    moderatorlog InnoDB 10 Dynamic 17413 151 2637824 0 1556480 4194304 27104 2018-10-12 04:32:33 latin1_swedish_ci
    node InnoDB 10 Dynamic 1105536 197 218857472 0 521388032 16777216 1637026 2018-10-12 04:32:33 2019-04-29 18:52:41 latin1_swedish_ci
    nodehash InnoDB 10 Dynamic 605 108 65536 0 81920 0 2018-10-12 04:28:56 2019-04-29 18:52:41 latin1_swedish_ci
    noderead InnoDB 10 Dynamic 3493 51 180224 0 114688 0 2018-10-12 04:30:38 2019-04-29 18:52:51 latin1_swedish_ci
    nodeview InnoDB 10 Dynamic 6237 31 196608 0 0 0 2018-10-12 04:29:15 2019-04-29 18:58:32 latin1_swedish_ci
    notice InnoDB 10 Dynamic 3 5461 16384 0 16384 0 4 2018-10-12 04:32:44 latin1_swedish_ci
    noticecriteria InnoDB 10 Dynamic 4 4096 16384 0 0 0 2018-10-12 04:32:32 latin1_swedish_ci
    noticedismissed InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:28:53 latin1_swedish_ci
    notification InnoDB 10 Dynamic 3047 349 1064960 0 655360 4194304 124995 2018-10-12 04:32:49 2019-04-29 18:52:51 latin1_swedish_ci
    notificationevent InnoDB 10 Dynamic 14 1170 16384 0 16384 0 2018-10-12 04:32:49 latin1_swedish_ci
    notificationtype InnoDB 10 Dynamic 11 1489 16384 0 32768 0 12 2018-10-12 04:30:19 latin1_swedish_ci
    package InnoDB 10 Dynamic 3 5461 16384 0 16384 0 4 2018-10-12 04:31:12 latin1_swedish_ci
    page InnoDB 10 Dynamic 66 248 16384 0 0 0 69 2018-10-12 04:32:40 latin1_swedish_ci
    pagetemplate InnoDB 10 Dynamic 43 381 16384 0 0 0 49 2018-10-12 04:32:47 latin1_swedish_ci
    passwordhistory InnoDB 10 Dynamic 205 239 49152 0 16384 0 2018-10-12 04:32:13 latin1_swedish_ci
    paymentapi InnoDB 10 Dynamic 8 2048 16384 0 0 0 9 2018-10-12 04:27:56 latin1_swedish_ci
    paymentinfo InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:44 latin1_swedish_ci
    paymenttransaction InnoDB 10 Dynamic 0 0 16384 0 49152 0 1 2018-10-12 04:32:33 latin1_swedish_ci
    permission InnoDB 10 Dynamic 170 96 16384 0 49152 0 173 2018-10-12 04:27:56 latin1_swedish_ci
    photo InnoDB 10 Dynamic 52 315 16384 0 16384 0 2018-10-12 04:30:20 latin1_swedish_ci
    phrase MyISAM 10 Dynamic 13035 191 3868048 281474976710655 3221504 1369920 194366 2018-05-30 10:07:33 2019-04-24 13:15:57 2018-06-12 17:21:43 latin1_swedish_ci
    phrasetype InnoDB 10 Dynamic 70 234 16384 0 0 0 2018-10-12 04:32:49 latin1_swedish_ci
    picturecomment InnoDB 10 Dynamic 0 0 16384 0 49152 0 1 2018-10-12 04:32:45 latin1_swedish_ci
    picturecomment_hash InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:31:10 latin1_swedish_ci
    poll InnoDB 10 Dynamic 154 1808 278528 0 0 0 2018-10-12 04:30:47 2019-04-29 18:20:05 latin1_swedish_ci
    polloption InnoDB 10 Dynamic 768 213 163840 0 16384 0 786 2018-10-12 04:29:15 2019-04-29 18:20:05 latin1_swedish_ci
    pollvote InnoDB 10 Dynamic 5313 61 327680 0 704512 4194304 5969 2018-10-12 04:32:33 2019-04-29 18:20:05 latin1_swedish_ci
    postedithistory InnoDB 10 Dynamic 84144 1678 141197312 0 9469952 6291456 110997 2018-10-12 04:28:21 latin1_swedish_ci
    postindex InnoDB 10 Dynamic 17361130 63 1096761344 0 0 6291456 2019-04-29 18:44:48 2019-04-29 18:44:47 latin1_swedish_ci
    prefix InnoDB 10 Dynamic 4 4096 16384 0 16384 0 2018-10-12 04:31:11 latin1_swedish_ci
    prefixpermission InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:30:40 latin1_swedish_ci
    prefixset InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:44 latin1_swedish_ci
    privacyconsent InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:32:41 latin1_swedish_ci
    privatemessage InnoDB 10 Dynamic 5009 35 180224 0 0 0 2018-10-12 04:32:46 latin1_swedish_ci
    product InnoDB 10 Dynamic 6 2730 16384 0 16384 0 2018-10-12 04:32:33 latin1_swedish_ci
    productcode InnoDB 10 Dynamic 4 4096 16384 0 16384 0 61 2018-10-12 04:32:41 latin1_swedish_ci
    productdependency InnoDB 10 Dynamic 5 3276 16384 0 0 0 13 2018-10-12 04:32:47 latin1_swedish_ci
    profilefield InnoDB 10 Dynamic 4 4096 16384 0 32768 0 5 2018-10-12 04:30:38 latin1_swedish_ci
    profilefieldcategory InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:32:44 latin1_swedish_ci
    profilevisitor InnoDB 10 Dynamic 5375 54 294912 0 163840 0 2018-10-12 04:32:14 latin1_swedish_ci
    ranks InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:30:47 latin1_swedish_ci
    redirect InnoDB 10 Dynamic 11 1489 16384 0 0 0 2018-10-12 04:32:33 latin1_swedish_ci
    report InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:29:15 latin1_swedish_ci
    reputation InnoDB 10 Dynamic 2129 69 147456 0 311296 4194304 6763 2018-10-12 04:30:40 latin1_swedish_ci
    reputationlevel InnoDB 10 Dynamic 15 1092 16384 0 16384 0 16 2018-10-12 04:32:43 latin1_swedish_ci
    routenew InnoDB 10 Dynamic 110 595 65536 0 65536 0 112 2018-10-12 04:28:54 latin1_swedish_ci
    rssfeed InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:48 latin1_swedish_ci
    rsslog InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:31:15 latin1_swedish_ci
    screenlayout InnoDB 10 Dynamic 11 1489 16384 0 32768 0 13 2018-10-12 04:32:45 latin1_swedish_ci
    searchlog InnoDB 10 Dynamic 2296 77645 178274304 0 458752 831520768 9892632 2018-10-12 04:30:47 2019-04-29 19:00:53 latin1_swedish_ci
    searchtowords_a InnoDB 10 Dynamic 201971 44 8929280 0 3686400 4194304 2018-10-12 04:32:43 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_b InnoDB 10 Dynamic 269864 44 12075008 0 4734976 7340032 2018-10-12 04:32:45 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_c InnoDB 10 Dynamic 359107 45 16269312 0 5783552 5242880 2018-10-12 04:28:54 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_d InnoDB 10 Dynamic 302316 46 14172160 0 4734976 7340032 2018-10-12 04:32:47 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_e InnoDB 10 Dynamic 123830 46 5783552 0 2637824 4194304 2018-10-12 04:32:44 2019-04-29 18:48:09 latin1_swedish_ci
    searchtowords_f InnoDB 10 Dynamic 236985 46 11026432 0 4734976 4194304 2018-10-12 04:28:56 2019-04-29 18:52:41 latin1_swedish_ci
    searchtowords_g InnoDB 10 Dynamic 204533 48 9977856 0 3686400 4194304 2018-10-12 04:32:48 2019-04-29 18:48:09 latin1_swedish_ci
    searchtowords_h InnoDB 10 Dynamic 201971 44 8929280 0 3686400 4194304 2018-10-12 04:30:38 2019-04-29 18:52:41 latin1_swedish_ci
    searchtowords_i InnoDB 10 Dynamic 115717 49 5783552 0 2637824 4194304 2018-10-12 04:32:44 2019-04-29 17:20:37 latin1_swedish_ci
    searchtowords_j InnoDB 10 Dynamic 66185 55 3686400 0 1589248 4194304 2018-10-12 04:30:19 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_k InnoDB 10 Dynamic 54656 48 2637824 0 1589248 4194304 2018-10-12 04:27:56 2019-04-29 18:27:43 latin1_swedish_ci
    searchtowords_l InnoDB 10 Dynamic 236985 46 11026432 0 4734976 4194304 2018-10-12 04:32:45 2019-04-29 18:27:43 latin1_swedish_ci
    searchtowords_m InnoDB 10 Dynamic 263032 45 12075008 0 4734976 7340032 2018-10-12 04:28:56 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_n InnoDB 10 Dynamic 83265 44 3686400 0 1589248 4194304 2018-10-12 04:32:48 2019-04-29 18:15:09 latin1_swedish_ci
    searchtowords_o InnoDB 10 Dynamic 84119 43 3686400 0 1589248 4194304 2018-10-12 04:32:47 2019-04-29 17:52:18 latin1_swedish_ci
    searchtowords_other InnoDB 10 Dynamic 70882 52 3686400 0 1589248 4194304 2018-10-12 04:32:14 2019-04-29 18:25:18 latin1_swedish_ci
    searchtowords_p InnoDB 10 Dynamic 391986 44 17350656 0 6832128 5242880 2018-10-12 04:30:40 2019-04-29 18:48:37 latin1_swedish_ci
    searchtowords_q InnoDB 10 Dynamic 23058 68 1589248 0 344064 4194304 2018-10-12 04:31:10 2019-04-29 18:48:37 latin1_swedish_ci
    searchtowords_r InnoDB 10 Dynamic 254065 47 12075008 0 4734976 7340032 2018-10-12 04:30:40 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_s InnoDB 10 Dynamic 460733 44 20496384 0 7880704 4194304 2018-10-12 04:29:15 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_t InnoDB 10 Dynamic 299327 43 13123584 0 4734976 5242880 2018-10-12 04:30:10 2019-04-29 18:52:41 latin1_swedish_ci
    searchtowords_u InnoDB 10 Dynamic 40565 65 2637824 0 1589248 4194304 2018-10-12 04:30:59 latin1_swedish_ci
    searchtowords_v InnoDB 10 Dynamic 34587 45 1589248 0 491520 4194304 2018-10-12 04:31:21 2019-04-29 18:48:09 latin1_swedish_ci
    searchtowords_w InnoDB 10 Dynamic 204960 48 9977856 0 3686400 4194304 2018-10-12 04:32:33 2019-04-29 18:51:26 latin1_swedish_ci
    searchtowords_x InnoDB 10 Dynamic 717 68 49152 0 16384 0 2018-10-12 04:28:21 latin1_swedish_ci
    searchtowords_y InnoDB 10 Dynamic 71309 51 3686400 0 1589248 4194304 2018-10-12 04:30:38 2019-04-29 18:48:37 latin1_swedish_ci
    searchtowords_z InnoDB 10 Dynamic 3703 44 163840 0 81920 0 2018-10-12 04:32:14 latin1_swedish_ci
    sentto InnoDB 10 Dynamic 10242 39 409600 0 671744 4194304 2018-10-12 04:32:47 latin1_swedish_ci
    session InnoDB 10 Dynamic 78 1470 114688 0 81920 5242880 2018-10-12 04:32:13 2019-04-29 19:00:53 latin1_swedish_ci
    sessionauth InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:32:43 latin1_swedish_ci
    setting InnoDB 10 Dynamic 436 263 114688 0 16384 0 2018-10-12 04:32:49 2019-04-29 17:17:41 latin1_swedish_ci
    settinggroup InnoDB 10 Dynamic 48 341 16384 0 0 0 2018-10-12 04:32:45 latin1_swedish_ci
    sigparsed InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:30:38 latin1_swedish_ci
    sigpic InnoDB 10 Dynamic 31 528 16384 0 0 0 2018-10-12 04:32:47 latin1_swedish_ci
    sigpicnew InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:31:15 latin1_swedish_ci
    site InnoDB 10 Dynamic 1 16384 16384 0 0 0 2 2018-10-12 04:28:57 latin1_swedish_ci
    smilie InnoDB 10 Dynamic 24 682 16384 0 0 0 47 2018-10-12 04:30:47 latin1_swedish_ci
    spamlog InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:30:51 latin1_swedish_ci
    stats InnoDB 10 Dynamic 5016 42 212992 0 0 0 2018-10-12 04:32:45 latin1_swedish_ci
    strikes InnoDB 10 Dynamic 2 8192 16384 0 49152 0 2018-10-12 04:29:15 2019-04-29 18:33:18 latin1_swedish_ci
    style InnoDB 10 Dynamic 37 212992 7880704 0 16384 4194304 45 2018-10-12 04:31:11 latin1_swedish_ci
    stylevar InnoDB 10 Dynamic 1299 1223 1589248 0 0 4194304 2018-10-12 04:28:56 latin1_swedish_ci
    stylevardfn InnoDB 10 Dynamic 457 179 81920 0 0 0 2018-10-12 04:28:53 latin1_swedish_ci
    subscribediscussion InnoDB 10 Dynamic 115537 50 5783552 0 9469952 4194304 120395 2018-10-12 04:32:33 latin1_swedish_ci
    subscribeevent InnoDB 10 Dynamic 0 0 16384 0 32768 0 2 2018-10-12 04:28:57 latin1_swedish_ci
    subscription InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:31:30 latin1_swedish_ci
    subscriptionlog InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:31:21 latin1_swedish_ci
    subscriptionpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:31:15 latin1_swedish_ci
    tachyforumcounter InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-04-29 18:45:33 latin1_swedish_ci
    tachyforumpost InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-04-29 18:45:44 latin1_swedish_ci
    tachythreadcounter InnoDB 10 Dynamic 0 0 16384 0 0 0 2019-04-29 18:45:57 latin1_swedish_ci
    tachythreadpost InnoDB 10 Dynamic 0 0 16384 0 16384 0 2019-04-29 18:46:07 latin1_swedish_ci
    tag InnoDB 10 Dynamic 222 73 16384 0 32768 0 229 2018-10-12 04:32:43 latin1_swedish_ci
    tagcontent InnoDB 10 Dynamic 241 67 16384 0 49152 0 2018-10-12 04:32:41 latin1_swedish_ci
    tagnode InnoDB 10 Dynamic 235 69 16384 0 81920 0 2018-10-12 04:31:11 latin1_swedish_ci
    tagsearch InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:28:57 latin1_swedish_ci
    tapatalk_push InnoDB 10 Dynamic 0 0 16384 0 32768 0 6 2019-04-29 18:46:30 2019-04-29 18:46:30 latin1_swedish_ci
    tapatalk_users InnoDB 10 Dynamic 32 512 16384 0 0 0 2019-04-29 18:46:45 2019-04-29 18:46:45 latin1_swedish_ci
    template InnoDB 10 Dynamic 1220 18465 22528000 0 98304 4194304 9801 2018-10-12 04:29:15 latin1_swedish_ci
    templatehistory InnoDB 10 Dynamic 4 4096 16384 0 16384 0 22 2018-10-12 04:32:45 latin1_swedish_ci
    templatemerge InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:45 latin1_swedish_ci
    text InnoDB 10 Dynamic 1070218 484 518979584 0 0 6291456 2018-10-12 04:30:20 2019-04-29 18:52:41 latin1_swedish_ci
    thread_post InnoDB 10 Dynamic 6384 35 229376 0 360448 0 2018-10-12 04:27:57 latin1_swedish_ci
    trending InnoDB 10 Dynamic 38 431 16384 0 16384 0 2018-10-12 04:28:57 2019-04-29 18:51:37 latin1_swedish_ci
    upgradelog InnoDB 10 Dynamic 2987 60 180224 0 114688 0 3093 2018-10-12 04:31:10 latin1_swedish_ci
    user InnoDB 10 Dynamic 2092 759 1589248 0 786432 4194304 3522 2019-04-29 18:56:51 2019-04-29 19:00:48 latin1_swedish_ci
    useractivation InnoDB 10 Dynamic 264 186 49152 0 16384 0 3748 2019-04-29 18:57:16 2019-04-29 18:57:16 latin1_swedish_ci
    userauth InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:28:53 latin1_swedish_ci
    userban InnoDB 10 Dynamic 182 90 16384 0 16384 0 2019-04-29 18:57:37 2019-04-29 18:57:37 latin1_swedish_ci
    userchangelog InnoDB 10 Dynamic 2713 108 294912 0 589824 0 2714 2019-04-29 18:58:00 2019-04-29 18:58:00 latin1_swedish_ci
    userfield InnoDB 10 Dynamic 2270 72 163840 0 0 0 2019-04-29 18:58:22 2019-04-29 18:58:22 latin1_swedish_ci
    usergroup InnoDB 10 Dynamic 17 963 16384 0 0 0 23 2019-04-29 18:58:40 2019-04-29 18:58:40 latin1_swedish_ci
    usergroupleader InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2019-04-29 18:58:58 latin1_swedish_ci
    usergrouprequest InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-04-29 18:59:08 latin1_swedish_ci
    userlist InnoDB 10 Dynamic 303 54 16384 0 32768 0 2019-04-29 18:59:26 2019-04-29 18:59:26 latin1_swedish_ci
    userloginmfa InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:46 latin1_swedish_ci
    usernote InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2019-04-29 18:59:36 latin1_swedish_ci
    userpromotion InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2019-04-29 18:59:52 2019-04-29 18:59:52 latin1_swedish_ci
    userstylevar InnoDB 10 Dynamic 43 381 16384 0 0 0 2018-10-12 04:28:53 latin1_swedish_ci
    usertextfield InnoDB 10 Dynamic 2270 108 245760 0 0 0 2019-04-29 19:00:08 2019-04-29 19:00:08 latin1_swedish_ci
    usertitle InnoDB 10 Dynamic 3 5461 16384 0 0 0 4 2019-04-29 19:00:17 2019-04-29 19:00:17 latin1_swedish_ci
    vbfields InnoDB 10 Dynamic 704 162 114688 0 0 0 705 2019-04-29 19:00:36 2019-04-29 19:00:36 latin1_swedish_ci
    video InnoDB 10 Dynamic 62 792 49152 0 0 0 2018-10-12 04:32:46 latin1_swedish_ci
    videoitem InnoDB 10 Dynamic 57 287 16384 0 16384 0 277 2018-10-12 04:28:54 latin1_swedish_ci
    widget InnoDB 10 Dynamic 76 646 49152 0 32768 0 79 2018-10-12 04:32:46 latin1_swedish_ci
    widgetchannelconfig InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:39 latin1_swedish_ci
    widgetdefinition InnoDB 10 Dynamic 469 209 98304 0 32768 0 2018-10-12 04:32:48 latin1_swedish_ci
    widgetinstance InnoDB 10 Dynamic 159 515 81920 0 16384 0 182 2018-10-12 04:32:43 latin1_swedish_ci
    widgetuserconfig InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:46 latin1_swedish_ci
    words InnoDB 10 Dynamic 124108 46 5783552 0 2637824 4194304 144320 2018-10-12 04:32:14 2019-04-29 18:15:09 latin1_swedish_ci

    Leave a comment:


  • Wayne Luke
    replied
    Please convert your MyISAM tables to INNODB. Do not convert language or phrase at this time.

    Leave a comment:


  • lottidah
    replied
    Table Status
    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
    ad InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2018-10-12 04:31:00 latin1_swedish_ci
    adcriteria InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:48 latin1_swedish_ci
    adminhelp InnoDB 10 Dynamic 1484 88 131072 0 98304 0 23372 2018-10-12 04:28:21 latin1_swedish_ci
    administrator InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:27:57 latin1_swedish_ci
    adminlog InnoDB 10 Dynamic 15257 104 1589248 0 1589248 4194304 15620 2018-10-12 04:32:48 2019-04-28 18:13:33 latin1_swedish_ci
    adminmessage InnoDB 10 Dynamic 13 1260 16384 0 32768 0 14 2018-10-12 04:32:39 latin1_swedish_ci
    adminutil InnoDB 10 Dynamic 3 5461 16384 0 0 0 2018-10-12 04:31:11 latin1_swedish_ci
    album MyISAM 10 Dynamic 17 41 708 281474976710655 3072 0 20 2018-05-30 09:29:36 2018-05-30 09:29:36 2018-06-19 16:16:48 latin1_swedish_ci
    albumupdate MyISAM 10 Fixed 0 0 0 2533274790395903 1024 0 2018-05-29 13:57:22 2018-05-29 13:57:22 2018-06-19 16:16:48 latin1_swedish_ci
    announcement InnoDB 10 Dynamic 7 2340 16384 0 49152 0 13 2018-10-12 04:30:20 latin1_swedish_ci
    announcementread InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:32:48 latin1_swedish_ci
    apiclient InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:31:15 latin1_swedish_ci
    apiclient_devicetoken InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:30:52 latin1_swedish_ci
    apilog InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:47 latin1_swedish_ci
    attach InnoDB 10 Dynamic 4450 73 327680 0 81920 0 2018-10-12 04:32:45 2019-04-28 14:48:47 latin1_swedish_ci
    attachment MyISAM 10 Dynamic 4009 59 240396 281474976710655 293888 0 4819 2018-05-30 09:29:29 2018-05-30 09:29:29 2018-06-19 16:16:48 latin1_swedish_ci
    attachmentcategory InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:47 latin1_swedish_ci
    attachmentcategoryuser InnoDB 10 Dynamic 4003 61 245760 0 212992 0 2018-10-12 04:32:48 latin1_swedish_ci
    attachmentpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:32:45 latin1_swedish_ci
    attachmenttype InnoDB 10 Dynamic 12 1365 16384 0 0 0 2018-10-12 04:32:39 latin1_swedish_ci
    attachmentviews InnoDB 10 Dynamic 2 8192 16384 0 16384 0 2018-10-12 04:32:13 latin1_swedish_ci
    automediaembed MyISAM 10 Dynamic 265 655 173800 281474976710655 5120 0 487 2018-05-29 13:57:32 2018-05-29 13:57:32 2018-06-19 16:16:48 latin1_swedish_ci
    autosavetext InnoDB 10 Dynamic 87 753 65536 0 49152 4194304 2018-10-12 04:32:48 2019-04-28 18:12:40 latin1_swedish_ci
    avatar InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:31:15 latin1_swedish_ci
    bbcode InnoDB 10 Dynamic 3 5461 16384 0 16384 0 9 2018-10-12 04:27:56 latin1_swedish_ci
    bbcode_video InnoDB 10 Dynamic 9 1820 16384 0 49152 0 10 2018-10-12 04:28:57 latin1_swedish_ci
    cache InnoDB 10 Dynamic 3319 11230 37273600 0 409600 4194304 2018-10-12 04:32:46 2019-04-28 18:13:33 latin1_swedish_ci
    cacheevent InnoDB 10 Dynamic 9960 159 1589248 0 1572864 4194304 2018-10-12 04:31:21 2019-04-28 18:13:33 latin1_swedish_ci
    calendar InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2018-10-12 04:31:11 latin1_swedish_ci
    calendarcustomfield InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:29:15 latin1_swedish_ci
    calendarmoderator InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:31:16 latin1_swedish_ci
    calendarpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:28:53 latin1_swedish_ci
    channel InnoDB 10 Dynamic 23 712 16384 0 16384 0 2018-10-12 04:32:33 latin1_swedish_ci
    channelprefixset InnoDB 10 Dynamic 8 2048 16384 0 0 0 2018-10-12 04:32:14 latin1_swedish_ci
    closure InnoDB 10 Dynamic 6477718 38 252477440 0 473513984 6291456 2018-10-12 04:32:33 2019-04-28 17:59:56 latin1_swedish_ci
    contentpriority InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:41 latin1_swedish_ci
    contenttype InnoDB 10 Dynamic 32 512 16384 0 16384 0 33 2018-10-12 04:28:54 latin1_swedish_ci
    cpsession InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:28:53 2019-04-28 18:13:33 latin1_swedish_ci
    cron InnoDB 10 Dynamic 25 655 16384 0 32768 0 35 2018-10-12 04:30:47 2019-04-28 18:11:02 latin1_swedish_ci
    cronlog InnoDB 10 Dynamic 19985 79 1589248 0 1589248 4194304 36608 2018-10-12 04:28:56 2019-04-28 18:06:25 latin1_swedish_ci
    customavatar InnoDB 10 Dynamic 557 117 65536 0 0 0 2018-10-12 04:32:49 latin1_swedish_ci
    customprofile InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:28:53 latin1_swedish_ci
    customprofilepic InnoDB 10 Dynamic 265 185 49152 0 0 0 2018-10-12 04:31:21 latin1_swedish_ci
    datastore InnoDB 10 Dynamic 62 4756 294912 0 0 0 2018-10-12 04:32:14 2019-04-28 18:11:02 latin1_swedish_ci
    deletionlog InnoDB 10 Dynamic 7894 64 507904 0 212992 0 2018-10-12 04:32:46 latin1_swedish_ci
    discussion InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2018-10-12 04:32:33 latin1_swedish_ci
    editlog InnoDB 10 Dynamic 40322 91 3686400 0 1589248 4194304 2018-10-12 04:30:18 2019-04-28 16:45:16 latin1_swedish_ci
    event InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:30:47 latin1_swedish_ci
    externalcache InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:31:26 latin1_swedish_ci
    faq InnoDB 10 Dynamic 64 256 16384 0 16384 0 2018-10-12 04:32:47 latin1_swedish_ci
    fcmessage InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:30:40 latin1_swedish_ci
    fcmessage_offload InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:41 latin1_swedish_ci
    fcmessage_queue InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:27:56 latin1_swedish_ci
    filedata InnoDB 10 Dynamic 4741 69562 329793536 0 688128 301989888 7060 2018-10-12 04:32:47 2019-04-28 14:49:02 latin1_swedish_ci
    filedataresize InnoDB 10 Dynamic 5390 3018 16269312 0 98304 13631488 2018-10-12 04:32:45 2019-04-28 14:49:02 latin1_swedish_ci
    forumpermission InnoDB 10 Dynamic 5 3276 16384 0 16384 0 6 2018-10-12 04:32:43 latin1_swedish_ci
    forumrunner_attachment MyISAM 10 Fixed 0 0 0 5910974510923775 1024 0 1 2018-05-30 10:13:57 2018-05-30 10:13:57 2018-06-12 17:08:37 latin1_swedish_ci
    forumrunner_push_data MyISAM 10 Fixed 0 0 0 6192449487634431 1024 0 1 2018-05-30 10:13:57 2018-05-30 10:13:57 2018-06-12 17:08:37 latin1_swedish_ci
    forumrunner_push_users MyISAM 10 Dynamic 0 0 0 281474976710655 1024 0 1 2018-05-30 10:13:57 2018-05-30 10:13:57 2018-06-12 17:08:37 latin1_swedish_ci
    gallery InnoDB 10 Dynamic 26 630 16384 0 0 0 2018-10-12 04:32:48 2019-04-27 10:18:16 latin1_swedish_ci
    groupintopic InnoDB 10 Dynamic 4 4096 16384 0 16384 0 2018-10-12 04:32:45 latin1_swedish_ci
    holiday InnoDB 10 Dynamic 5 3276 16384 0 0 0 6 2018-10-12 04:27:57 latin1_swedish_ci
    hook InnoDB 10 Dynamic 12 1365 16384 0 32768 0 34 2018-10-12 04:28:57 latin1_swedish_ci
    humanverify InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:32:45 latin1_swedish_ci
    hvanswer InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:43 latin1_swedish_ci
    hvquestion InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:28:53 latin1_swedish_ci
    icon InnoDB 10 Dynamic 14 1170 16384 0 0 0 16 2018-10-12 04:32:49 latin1_swedish_ci
    imagecategory InnoDB 10 Dynamic 3 5461 16384 0 0 0 4 2018-10-12 04:32:41 latin1_swedish_ci
    imagecategorypermission InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:31:00 latin1_swedish_ci
    infraction InnoDB 10 Dynamic 8 2048 16384 0 65536 0 2018-10-12 04:28:57 latin1_swedish_ci
    infractionban InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:48 latin1_swedish_ci
    infractiongroup InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:28:53 latin1_swedish_ci
    infractionlevel InnoDB 10 Dynamic 4 4096 16384 0 0 0 5 2018-10-12 04:32:40 latin1_swedish_ci
    ipaddressinfo InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:31:15 latin1_swedish_ci
    language MyISAM 10 Dynamic 1 650936 650936 281474976710655 2048 0 2 2018-05-30 10:11:05 2019-04-24 13:15:59 2018-06-12 17:20:12 latin1_swedish_ci
    legacyevent MyISAM 10 Dynamic 10 87 876 281474976710655 6144 0 12 2018-05-30 09:30:42 2018-05-30 09:30:42 2018-06-12 17:20:12 latin1_swedish_ci
    link InnoDB 10 Dynamic 62 792 49152 0 16384 0 2018-10-12 04:32:49 2019-04-28 14:49:02 latin1_swedish_ci
    loginlibrary InnoDB 10 Dynamic 1 16384 16384 0 16384 0 3 2018-10-12 04:32:46 latin1_swedish_ci
    mailqueue InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:32:14 latin1_swedish_ci
    mapiposthash InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:43 latin1_swedish_ci
    messagefolder InnoDB 10 Dynamic 1392 58 81920 0 98304 0 2871 2018-10-12 04:27:57 2019-04-27 09:57:08 latin1_swedish_ci
    moderation InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:32:33 latin1_swedish_ci
    moderator InnoDB 10 Dynamic 26 630 16384 0 32768 0 53 2018-10-12 04:32:33 latin1_swedish_ci
    moderatorlog InnoDB 10 Dynamic 17413 151 2637824 0 1556480 4194304 27061 2018-10-12 04:32:33 2019-04-28 17:46:31 latin1_swedish_ci
    node InnoDB 10 Dynamic 1106743 197 218857472 0 521388032 16777216 1636835 2018-10-12 04:32:33 2019-04-28 17:59:56 latin1_swedish_ci
    nodehash InnoDB 10 Dynamic 1147 99 114688 0 147456 0 2018-10-12 04:28:56 2019-04-28 17:59:56 latin1_swedish_ci
    noderead InnoDB 10 Dynamic 3493 51 180224 0 114688 0 2018-10-12 04:30:38 2019-04-28 18:11:02 latin1_swedish_ci
    nodeview InnoDB 10 Dynamic 6237 31 196608 0 0 0 2018-10-12 04:29:15 2019-04-28 18:13:01 latin1_swedish_ci
    notice InnoDB 10 Dynamic 3 5461 16384 0 16384 0 4 2018-10-12 04:32:44 latin1_swedish_ci
    noticecriteria InnoDB 10 Dynamic 4 4096 16384 0 0 0 2018-10-12 04:32:32 latin1_swedish_ci
    noticedismissed InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:28:53 latin1_swedish_ci
    notification InnoDB 10 Dynamic 2851 373 1064960 0 606208 4194304 124725 2018-10-12 04:32:49 2019-04-28 18:08:38 latin1_swedish_ci
    notificationevent InnoDB 10 Dynamic 14 1170 16384 0 16384 0 2018-10-12 04:32:49 latin1_swedish_ci
    notificationtype InnoDB 10 Dynamic 11 1489 16384 0 32768 0 12 2018-10-12 04:30:19 latin1_swedish_ci
    package InnoDB 10 Dynamic 3 5461 16384 0 16384 0 4 2018-10-12 04:31:12 latin1_swedish_ci
    page InnoDB 10 Dynamic 66 248 16384 0 0 0 69 2018-10-12 04:32:40 latin1_swedish_ci
    pagetemplate InnoDB 10 Dynamic 43 381 16384 0 0 0 49 2018-10-12 04:32:47 latin1_swedish_ci
    passwordhistory InnoDB 10 Dynamic 205 239 49152 0 16384 0 2018-10-12 04:32:13 2019-04-27 09:57:07 latin1_swedish_ci
    paymentapi InnoDB 10 Dynamic 8 2048 16384 0 0 0 9 2018-10-12 04:27:56 latin1_swedish_ci
    paymentinfo InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:44 latin1_swedish_ci
    paymenttransaction InnoDB 10 Dynamic 0 0 16384 0 49152 0 1 2018-10-12 04:32:33 latin1_swedish_ci
    permission InnoDB 10 Dynamic 170 96 16384 0 49152 0 173 2018-10-12 04:27:56 latin1_swedish_ci
    photo InnoDB 10 Dynamic 52 315 16384 0 16384 0 2018-10-12 04:30:20 2019-04-27 10:18:16 latin1_swedish_ci
    phrase MyISAM 10 Dynamic 13035 191 3868048 281474976710655 3221504 1369920 194366 2018-05-30 10:07:33 2019-04-24 13:15:57 2018-06-12 17:21:43 latin1_swedish_ci
    phrasetype InnoDB 10 Dynamic 70 234 16384 0 0 0 2018-10-12 04:32:49 latin1_swedish_ci
    picturecomment InnoDB 10 Dynamic 0 0 16384 0 49152 0 1 2018-10-12 04:32:45 latin1_swedish_ci
    picturecomment_hash InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:31:10 latin1_swedish_ci
    poll InnoDB 10 Dynamic 154 1808 278528 0 0 0 2018-10-12 04:30:47 2019-04-26 00:54:27 latin1_swedish_ci
    polloption InnoDB 10 Dynamic 768 213 163840 0 16384 0 781 2018-10-12 04:29:15 2019-04-26 00:54:27 latin1_swedish_ci
    pollvote InnoDB 10 Dynamic 5313 61 327680 0 704512 4194304 5950 2018-10-12 04:32:33 2019-04-26 00:54:27 latin1_swedish_ci
    postedithistory InnoDB 10 Dynamic 84144 1678 141197312 0 9469952 6291456 110981 2018-10-12 04:28:21 2019-04-28 16:45:16 latin1_swedish_ci
    postindex MyISAM 10 Fixed 19817593 13 257628709 3659174697238527 343044096 0 2018-05-29 13:58:26 2018-05-30 08:45:45 2018-06-12 17:21:51 latin1_swedish_ci
    prefix InnoDB 10 Dynamic 4 4096 16384 0 16384 0 2018-10-12 04:31:11 latin1_swedish_ci
    prefixpermission InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:30:40 latin1_swedish_ci
    prefixset InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:44 latin1_swedish_ci
    privacyconsent InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:32:41 latin1_swedish_ci
    privatemessage InnoDB 10 Dynamic 5009 35 180224 0 0 0 2018-10-12 04:32:46 latin1_swedish_ci
    product InnoDB 10 Dynamic 6 2730 16384 0 16384 0 2018-10-12 04:32:33 latin1_swedish_ci
    productcode InnoDB 10 Dynamic 4 4096 16384 0 16384 0 61 2018-10-12 04:32:41 latin1_swedish_ci
    productdependency InnoDB 10 Dynamic 5 3276 16384 0 0 0 13 2018-10-12 04:32:47 latin1_swedish_ci
    profilefield InnoDB 10 Dynamic 4 4096 16384 0 32768 0 5 2018-10-12 04:30:38 latin1_swedish_ci
    profilefieldcategory InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:32:44 latin1_swedish_ci
    profilevisitor InnoDB 10 Dynamic 5375 54 294912 0 163840 0 2018-10-12 04:32:14 latin1_swedish_ci
    ranks InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:30:47 latin1_swedish_ci
    redirect InnoDB 10 Dynamic 11 1489 16384 0 0 0 2018-10-12 04:32:33 latin1_swedish_ci
    report InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:29:15 latin1_swedish_ci
    reputation InnoDB 10 Dynamic 2129 69 147456 0 311296 4194304 6734 2018-10-12 04:30:40 2019-04-28 16:56:35 latin1_swedish_ci
    reputationlevel InnoDB 10 Dynamic 15 1092 16384 0 16384 0 16 2018-10-12 04:32:43 latin1_swedish_ci
    routenew InnoDB 10 Dynamic 110 595 65536 0 65536 0 112 2018-10-12 04:28:54 latin1_swedish_ci
    rssfeed InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2018-10-12 04:32:48 latin1_swedish_ci
    rsslog InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:31:15 latin1_swedish_ci
    screenlayout InnoDB 10 Dynamic 11 1489 16384 0 32768 0 13 2018-10-12 04:32:45 latin1_swedish_ci
    searchlog InnoDB 10 Dynamic 547 122715 67125248 0 114688 959447040 9850500 2018-10-12 04:30:47 2019-04-28 18:13:33 latin1_swedish_ci
    searchtowords_a InnoDB 10 Dynamic 201971 44 8929280 0 3686400 4194304 2018-10-12 04:32:43 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_b InnoDB 10 Dynamic 269864 44 12075008 0 4734976 7340032 2018-10-12 04:32:45 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_c InnoDB 10 Dynamic 359107 45 16269312 0 5783552 5242880 2018-10-12 04:28:54 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_d InnoDB 10 Dynamic 302316 46 14172160 0 4734976 7340032 2018-10-12 04:32:47 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_e InnoDB 10 Dynamic 123830 46 5783552 0 2637824 4194304 2018-10-12 04:32:44 2019-04-28 17:55:46 latin1_swedish_ci
    searchtowords_f InnoDB 10 Dynamic 236985 46 11026432 0 4734976 4194304 2018-10-12 04:28:56 2019-04-28 17:58:06 latin1_swedish_ci
    searchtowords_g InnoDB 10 Dynamic 204533 48 9977856 0 3686400 4194304 2018-10-12 04:32:48 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_h InnoDB 10 Dynamic 201971 44 8929280 0 3686400 4194304 2018-10-12 04:30:38 2019-04-28 17:58:06 latin1_swedish_ci
    searchtowords_i InnoDB 10 Dynamic 115717 49 5783552 0 2637824 4194304 2018-10-12 04:32:44 2019-04-28 17:56:37 latin1_swedish_ci
    searchtowords_j InnoDB 10 Dynamic 66185 55 3686400 0 1589248 4194304 2018-10-12 04:30:19 2019-04-28 17:52:50 latin1_swedish_ci
    searchtowords_k InnoDB 10 Dynamic 54656 48 2637824 0 1589248 4194304 2018-10-12 04:27:56 2019-04-28 17:52:50 latin1_swedish_ci
    searchtowords_l InnoDB 10 Dynamic 236985 46 11026432 0 4734976 4194304 2018-10-12 04:32:45 2019-04-28 17:58:06 latin1_swedish_ci
    searchtowords_m InnoDB 10 Dynamic 263032 45 12075008 0 4734976 7340032 2018-10-12 04:28:56 2019-04-28 17:58:06 latin1_swedish_ci
    searchtowords_n InnoDB 10 Dynamic 83265 44 3686400 0 1589248 4194304 2018-10-12 04:32:48 2019-04-28 17:58:06 latin1_swedish_ci
    searchtowords_o InnoDB 10 Dynamic 84119 43 3686400 0 1589248 4194304 2018-10-12 04:32:47 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_other InnoDB 10 Dynamic 70882 52 3686400 0 1589248 4194304 2018-10-12 04:32:14 2019-04-28 17:55:46 latin1_swedish_ci
    searchtowords_p InnoDB 10 Dynamic 391986 44 17350656 0 6832128 5242880 2018-10-12 04:30:40 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_q InnoDB 10 Dynamic 23058 68 1589248 0 344064 4194304 2018-10-12 04:31:10 2019-04-28 17:58:06 latin1_swedish_ci
    searchtowords_r InnoDB 10 Dynamic 254065 47 12075008 0 4734976 7340032 2018-10-12 04:30:40 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_s InnoDB 10 Dynamic 460733 44 20496384 0 7880704 4194304 2018-10-12 04:29:15 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_t InnoDB 10 Dynamic 299327 43 13123584 0 4734976 5242880 2018-10-12 04:30:10 2019-04-28 17:59:56 latin1_swedish_ci
    searchtowords_u InnoDB 10 Dynamic 40565 65 2637824 0 1589248 4194304 2018-10-12 04:30:59 2019-04-28 17:31:24 latin1_swedish_ci
    searchtowords_v InnoDB 10 Dynamic 34587 45 1589248 0 491520 4194304 2018-10-12 04:31:21 2019-04-28 17:22:21 latin1_swedish_ci
    searchtowords_w InnoDB 10 Dynamic 204960 48 9977856 0 3686400 4194304 2018-10-12 04:32:33 2019-04-28 17:58:06 latin1_swedish_ci
    searchtowords_x InnoDB 10 Dynamic 717 68 49152 0 16384 0 2018-10-12 04:28:21 2019-04-28 12:03:02 latin1_swedish_ci
    searchtowords_y InnoDB 10 Dynamic 71309 51 3686400 0 1589248 4194304 2018-10-12 04:30:38 2019-04-28 17:46:31 latin1_swedish_ci
    searchtowords_z InnoDB 10 Dynamic 3703 44 163840 0 81920 0 2018-10-12 04:32:14 2019-04-28 15:21:47 latin1_swedish_ci
    sentto InnoDB 10 Dynamic 10242 39 409600 0 671744 4194304 2018-10-12 04:32:47 latin1_swedish_ci
    session InnoDB 10 Dynamic 41 1998 81920 0 81920 5242880 2018-10-12 04:32:13 2019-04-28 18:13:33 latin1_swedish_ci
    sessionauth InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:32:43 latin1_swedish_ci
    setting InnoDB 10 Dynamic 436 263 114688 0 16384 0 2018-10-12 04:32:49 latin1_swedish_ci
    settinggroup InnoDB 10 Dynamic 48 341 16384 0 0 0 2018-10-12 04:32:45 latin1_swedish_ci
    sigparsed InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:30:38 latin1_swedish_ci
    sigpic InnoDB 10 Dynamic 31 528 16384 0 0 0 2018-10-12 04:32:47 latin1_swedish_ci
    sigpicnew InnoDB 10 Dynamic 0 0 16384 0 16384 0 2018-10-12 04:31:15 latin1_swedish_ci
    site InnoDB 10 Dynamic 1 16384 16384 0 0 0 2 2018-10-12 04:28:57 latin1_swedish_ci
    smilie InnoDB 10 Dynamic 24 682 16384 0 0 0 47 2018-10-12 04:30:47 latin1_swedish_ci
    spamlog InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:30:51 latin1_swedish_ci
    stats InnoDB 10 Dynamic 5016 42 212992 0 0 0 2018-10-12 04:32:45 2019-04-27 20:02:45 latin1_swedish_ci
    strikes InnoDB 10 Dynamic 1 16384 16384 0 49152 0 2018-10-12 04:29:15 2019-04-28 18:11:02 latin1_swedish_ci
    style InnoDB 10 Dynamic 37 212992 7880704 0 16384 4194304 45 2018-10-12 04:31:11 latin1_swedish_ci
    stylevar InnoDB 10 Dynamic 1299 1223 1589248 0 0 4194304 2018-10-12 04:28:56 latin1_swedish_ci
    stylevardfn InnoDB 10 Dynamic 457 179 81920 0 0 0 2018-10-12 04:28:53 latin1_swedish_ci
    subscribediscussion InnoDB 10 Dynamic 115537 50 5783552 0 9469952 4194304 120397 2018-10-12 04:32:33 2019-04-28 14:30:44 latin1_swedish_ci
    subscribeevent InnoDB 10 Dynamic 0 0 16384 0 32768 0 2 2018-10-12 04:28:57 latin1_swedish_ci
    subscription InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2018-10-12 04:31:30 latin1_swedish_ci
    subscriptionlog InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:31:21 latin1_swedish_ci
    subscriptionpermission InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2018-10-12 04:31:15 latin1_swedish_ci
    tachyforumcounter MyISAM 10 Fixed 0 0 0 3940649673949183 1024 0 2018-05-29 14:03:00 2018-05-29 14:03:00 2018-06-12 17:13:39 latin1_swedish_ci
    tachyforumpost MyISAM 10 Dynamic 0 0 0 281474976710655 1024 0 2018-05-30 09:27:13 2018-05-30 09:27:13 2018-06-12 17:22:35 latin1_swedish_ci
    tachythreadcounter MyISAM 10 Fixed 0 0 0 3659174697238527 1024 0 2018-05-29 14:03:00 2018-05-29 14:03:00 2018-06-12 17:13:39 latin1_swedish_ci
    tachythreadpost MyISAM 10 Dynamic 0 0 0 281474976710655 1024 0 2018-05-30 09:27:14 2018-05-30 09:27:14 2018-06-12 17:22:35 latin1_swedish_ci
    tag InnoDB 10 Dynamic 222 73 16384 0 32768 0 229 2018-10-12 04:32:43 latin1_swedish_ci
    tagcontent InnoDB 10 Dynamic 241 67 16384 0 49152 0 2018-10-12 04:32:41 latin1_swedish_ci
    tagnode InnoDB 10 Dynamic 235 69 16384 0 81920 0 2018-10-12 04:31:11 latin1_swedish_ci
    tagsearch InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:28:57 latin1_swedish_ci
    tapatalk_push MyISAM 10 Dynamic 1 108 108 281474976710655 4096 0 6 2018-05-29 14:03:00 2018-05-29 14:03:00 2018-06-12 17:22:35 latin1_swedish_ci
    tapatalk_users MyISAM 10 Fixed 32 21 672 5910974510923775 2048 0 2018-05-29 14:03:00 2018-05-30 08:06:31 2018-06-12 17:22:35 latin1_swedish_ci
    template InnoDB 10 Dynamic 1220 18465 22528000 0 98304 4194304 9801 2018-10-12 04:29:15 latin1_swedish_ci
    templatehistory InnoDB 10 Dynamic 4 4096 16384 0 16384 0 22 2018-10-12 04:32:45 latin1_swedish_ci
    templatemerge InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:45 latin1_swedish_ci
    text InnoDB 10 Dynamic 1070265 484 518979584 0 0 6291456 2018-10-12 04:30:20 2019-04-28 17:59:56 latin1_swedish_ci
    thread_post InnoDB 10 Dynamic 6384 35 229376 0 360448 0 2018-10-12 04:27:57 latin1_swedish_ci
    trending InnoDB 10 Dynamic 37 442 16384 0 16384 0 2018-10-12 04:28:57 2019-04-28 17:52:55 latin1_swedish_ci
    upgradelog InnoDB 10 Dynamic 2987 60 180224 0 114688 0 3093 2018-10-12 04:31:10 latin1_swedish_ci
    user MyISAM 10 Dynamic 2270 253 575776 281474976710655 363520 0 3522 2018-09-17 16:26:49 2019-04-28 18:13:31 2018-09-17 16:26:49 latin1_swedish_ci
    useractivation MyISAM 10 Dynamic 264 38 10232 281474976710655 10240 60 3748 2018-05-30 10:06:44 2019-04-27 20:04:58 2018-06-12 17:22:55 latin1_swedish_ci
    userauth InnoDB 10 Dynamic 0 0 16384 0 32768 0 2018-10-12 04:28:53 latin1_swedish_ci
    userban MyISAM 10 Dynamic 182 48 8880 281474976710655 7168 28 2018-05-29 14:03:01 2018-11-09 08:04:06 2018-06-12 17:22:55 latin1_swedish_ci
    userchangelog MyISAM 10 Dynamic 2713 71 194976 281474976710655 314368 0 2714 2018-05-30 09:29:34 2019-04-27 10:01:19 2018-06-12 17:22:55 latin1_swedish_ci
    userfield MyISAM 10 Dynamic 2270 31 71112 281474976710655 25600 0 2018-05-31 06:22:27 2019-04-27 09:57:07 2018-06-12 17:22:55 latin1_swedish_ci
    usergroup MyISAM 10 Dynamic 17 145 2472 281474976710655 2048 0 23 2018-05-30 10:03:36 2018-06-14 07:12:07 2018-06-12 17:22:55 latin1_swedish_ci
    usergroupleader MyISAM 10 Fixed 0 0 0 2533274790395903 1024 0 1 2018-05-29 14:03:01 2018-05-29 14:03:01 2018-06-12 17:22:55 latin1_swedish_ci
    usergrouprequest MyISAM 10 Dynamic 0 0 0 281474976710655 1024 0 1 2018-05-29 14:03:01 2018-05-29 14:03:01 2018-06-12 17:22:55 latin1_swedish_ci
    userlist MyISAM 10 Fixed 303 11 3465 3096224743817215 19456 132 2018-05-29 14:03:01 2019-04-26 07:00:52 2018-06-12 17:22:55 latin1_swedish_ci
    userloginmfa InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:46 latin1_swedish_ci
    usernote MyISAM 10 Dynamic 0 0 0 281474976710655 1024 0 1 2018-05-29 14:03:01 2018-05-29 14:03:01 2018-06-12 17:22:55 latin1_swedish_ci
    userpromotion MyISAM 10 Fixed 1 29 29 8162774324609023 3072 0 2 2018-05-29 14:03:01 2018-05-29 14:03:01 2018-06-12 17:22:55 latin1_swedish_ci
    userstylevar InnoDB 10 Dynamic 43 381 16384 0 0 0 2018-10-12 04:28:53 latin1_swedish_ci
    usertextfield MyISAM 10 Dynamic 2270 38 87516 281474976710655 25600 0 2018-05-29 14:03:01 2019-04-27 09:57:07 2018-06-12 17:22:55 latin1_swedish_ci
    usertitle MyISAM 10 Fixed 3 259 777 72902018968059903 2048 0 4 2018-05-30 09:29:36 2018-05-30 09:29:36 2018-06-12 17:22:55 latin1_swedish_ci
    vbfields MyISAM 10 Dynamic 704 102 72240 281474976710655 8192 0 705 2018-05-29 14:03:01 2018-05-29 14:03:01 2018-06-12 17:22:55 latin1_swedish_ci
    video InnoDB 10 Dynamic 62 792 49152 0 0 0 2018-10-12 04:32:46 2019-04-28 14:43:01 latin1_swedish_ci
    videoitem InnoDB 10 Dynamic 57 287 16384 0 16384 0 277 2018-10-12 04:28:54 2019-04-28 14:42:59 latin1_swedish_ci
    widget InnoDB 10 Dynamic 76 646 49152 0 32768 0 79 2018-10-12 04:32:46 latin1_swedish_ci
    widgetchannelconfig InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:39 latin1_swedish_ci
    widgetdefinition InnoDB 10 Dynamic 469 209 98304 0 32768 0 2018-10-12 04:32:48 latin1_swedish_ci
    widgetinstance InnoDB 10 Dynamic 159 515 81920 0 16384 0 182 2018-10-12 04:32:43 latin1_swedish_ci
    widgetuserconfig InnoDB 10 Dynamic 0 0 16384 0 0 0 2018-10-12 04:32:46 latin1_swedish_ci
    words InnoDB 10 Dynamic 124108 46 5783552 0 2637824 4194304 144284 2018-10-12 04:32:14 2019-04-28 15:49:17 latin1_swedish_ci

    Leave a comment:

Related Topics

Collapse

  • lottidah
    Performance tuning?
    by lottidah
    Good morning. I run an NFL-related forum. I upgraded from our beloved vB 3.8x to 5.4 back in May. This weekend, we had our first NFL game since the upgrade and the forum was unusable during this high...
    Wed 12th Sep '18, 2:54am
Working...
X