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 demand period. I'm guessing there are some settings on the server that need to be tuned in order to handle all of the requests during popular times? Where should I start?
Performance tuning?
Collapse
X
-
There is no straightforward answer to this question and the information provided doesn't allow us to provide any sort of answer at all. Server optimisation is a complex science dependent on a whole host of factors and there is no 'press this button' type of answer I'm afraid.
As a bare minimum, we need to know the exact server specifications, including OS, version, RAM, php version, MySQL version, current settings, etc such as php memory limit, mysql wait_timeout, and a whole host of others.
It should be noted that server optimisation isn't actually part of the support we provide and we will try to help on a 'best endeavour' basis only.MARK.B
vBulletin Support
------------
My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
My Unofficial vBulletin Cloud Demo: https://www.adminammo.comComment
-
The first thing we need to know (other than the technical data Mark mentioned above) is how much traffic you have.Comment
-
https://www.vbulletin.com/forum/foru...sues-questions
First place to start is to make sure you're using PHP 7.2 and MySQL 5.7 or 8.
Then make sure that all tables except language, phrase, and userfield are INNODB.
Last edited by Wayne Luke; Thu 13 Sep '18, 10:32am.Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 APIComment
-
I realize my question was general and not too specific but I am just getting started and hoped there was a reference document to review. I will look for the info Mark mentions. As for traffic, it's really not a lot, it's probably 100-200 folks clicking into the same conversation at the same time during the game.
Wayne, can you explain how I would check this?Then make sure that all tables except language, phrase, and userfield are INNODB.Comment
-
You can look at the database in phpMyAdmin, HeidiSQL or other MySQL GUI and it will tell you what the Table Type is. Or you can run this query:
Code:show table status;
Code:ALTER TABLE [B]my_table[/B] ENGINE = InnoDB;
- Unzip the file.
- Rename vbutil_config.php.new to vbutil_config.php.
- Edit the file.
- Update the Database information at the top of the file.
- Upload the two files to your forum directory on the server.
- Create a database backup.
- From the command line use this command 'php myisamfix.phar -dofix'.
- Delete the two files from your server when it has completed.
Attached FilesLast edited by Wayne Luke; Fri 14 Sep '18, 8:44am.Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 APIComment
-
I see a number of tables that are not set to INNODB so I will need to work on that. Meanwhile, today was another game and performance was again terrible. We had about 100 users attempting to discuss the game in one particular topic. The topic would frequently take a minute or more to load.
Is there anything in this list below that pops out as our obvious problem? Something I should address first?
Thank you.
Comment
-
Wayne has already mentioned that you should upgrade to php 7.2 as a starting point. Looking at anything else is pointless until this is done.MARK.B
vBulletin Support
------------
My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
My Unofficial vBulletin Cloud Demo: https://www.adminammo.comComment
-
Are you on a Shared, VPS, or Dedicated Plan with your hosting? I'm guessing you're on a Shared Plan.Comment
-
After getting the PHP upgraded there are a couple of ways to go depending on your server configuration. Your PHP memory is a little high and this won't actually help performance very much. Lowering this to 256 MB will probably help the server run more processes overall. Once you've upgrade PHP you should see a significant performance boost from that alone. This is in the range of being able to generate 2-3 times the number of pages in the same resources. See this link as an example: https://kinsta.com/blog/php-7-hhvm-benchmarks/
Once that is done and you have converted to INNODB, there are a few things you can do on a shared server.- If your hosting provider allows Crontab, upload the file vbcron.php from your do_not_upload directory and set it up to run as often as provided by the hosting provider.
- Ask if your hosting provider has memcached installed? If they do, then get the IP Address and connection information. You can configure this in the /core/includes/config.php file.
- Breaking your topics up into multiple forums (you have two now) will help with the database queries and processing information. This will result in lower page load times.
If you're on a VPS with command line access or a dedicated server, you have other options.
Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 APIComment
-
I'm on a VPS with command line access.
I've updated to PHP 7.2, updated vBulletin from 5.4.1 to 5.4.3, and then ran the INNODB fix Wayne provided. I did notice that several tables remained as the previous status but I figured that was by design and the script changed the tables it needed to.
I've updated the PHP memory to 256 as recommended.
I will look into the bulleted items you provided. Please feel free to list the other options you had in mind for command line access.
Thank you all again for your help!!Comment
-
Make sure your attachments are stored in the file system. In the AdminCP go to Attachments -> Attachment Storage Type.
Make sure your Custom Avatars are stored in the file system. In the AdminCP go to Avatars -> User Picture Storage Type.
If your host doesn't provide memcached, then you can install it on your VM. This would allow you to move the datastore and long term cache from MySQL to memory. This would probably be your largest performance increase.
The other option that could improve performance is to switch to Sphinx for your search. This would require installing Sphinx on the server and building a word index for vBulletin. Your would move the search out of MySQL and distribute the load more.
Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 API👍 1Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment