Forum Activity for @brian

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

OK yeah - then I'm not sure why that would be so slow - the system load appears fine (based on your screenshot). It could just be that the HOST your VM is on has a high load due to other VM's on the same server. Did your integrity check when you did the table optimization finish successfully?

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

It's hard to tell - what you want to look at is the value for "jrCore_db_host" in your data/config/config.php file.

Also - I would _highly_ recommend you get APCu installed on your server - it's almost a requirement in Jamroom 7 and will make your site faster.

I know I probably already asked you this but have you thought about coming back to JR hosting? . We moved to new servers that are really, really fast.
updated by @brian: 04/26/24 09:43:51AM

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

No - repair tables or optimize tables are not going to help. You really don't ever need to run optimize/repair, since that mainly affects MyISAM tables, which JR has not use in a long time (some really old installs may still be using them however). My guess is that your MySQL server is not actually ON your server - since you're only using ~1G RAM, that would mean your InnoDB settings would be set for a very, very small server - I have a feeling your database server is not on the same physical server as your webhosting, and that the DB server is over loaded. Maybe give it some time and see if it improves?

Mailgun Now Bouncing

Using Jamroom

Hi Ken - there's nothing we've changed that would affect delivery - you'll want to work with Mailgun to figure out what's going on.

Congratulations and thanks

Off Topic

Awesome this went well Mick - glad things went smooth and easy for you

Unable to remove text field options in config of module.

Design and Skin Customization

If you no longer need a setting, at the bottom of your _init() function you can delete it - i.e.

URL from button in ACP

Jamroom Developers

You can't have a URL on an admin tab, since it does not make sense from a UI perspective. A "tab" flips between sections in the current page. What you want to do instead is register it as a TOOL - then you can have a URL that goes offsite if you want - i.e. from the Developer tools module:

Unable to find the .htaccess file

Installation and Configuration


Excellent - glad that is working.

Thanks!

Unable to find the .htaccess file

Installation and Configuration

Make sure you can see "hidden" files where you are unzipping the ZIP file - files that start with a "." are considered "hidden". The file is there you just probably can't see it. Most FTP programs have a setting to "show hidden files".

Let me know if that helps.

mysql 8 support

Using Jamroom

Jamroom should run no problem on MySQL 8 - I develop on it and don't see any issues (currently on 8.0.35). Are you sure it is fully installed correctly and that it's not trying to bring in any of the previous Percona install? One thing that might be worth a shot is add this line to your data/config/config.php file:


Just in case it was installed with the sql mode set to something weird - this will disable it. Not sure if that will help or not but worth a try. Let me know if that helps.