Recent content by Ghan_04

  1. Ghan_04

    Query Performance Profiling

    I'm not sure that will help much as the list is rather long, but I've added it to the first post.
  2. Ghan_04

    Query Performance Profiling

    I've noticed lately that our board is pushing about 6,000 queries per second and the database is taking up around 50-60% of the CPU (there are 2 cores on this VM). We typically have somewhere between 500 and 1000 users online at a time so it's consistent traffic, but this seems high. I've looked...
  3. Ghan_04

    Opcache enabled on Wordpress, disabled on XenForo

    What .ini file is being loaded for each site? At the top of the PHP config page, there will be a line for "Loaded Configuration File" - is this different between the two sites?
  4. Ghan_04

    Opcache enabled on Wordpress, disabled on XenForo

    Check the PHP configuration for the source php.ini file that is loaded for each site. It sounds like they may be different. With Litespeed, you should be able to control this via the External App configuration for your vhosts if I recall correctly.
  5. Ghan_04

    help nginx: [emerg] "location" directive is not allowed here in /www/server/nginx/conf/nginx.conf:96

    Location directives need to be inside a server block. Your server block is closed at line 89, which is probably where your issue is.
  6. Ghan_04

    XF 2.1 Auditing Attachments

    Is there any good way to audit which attachments are still valid on the board compared with what is in the filesystem? When I query for the sum of attachments sizes of all entries in the database and compare that to what is in the attachments folder on the filesystem, I'm seeing about a 60 GB...
  7. Ghan_04

    Question about MySQL / MariaDB

    I ran MariaDB for quite a while and it was great. Not running it now only because I've upgraded to MariaDB 10.3. :)
  8. Ghan_04

    Fixed Infinite HTTP requests : running AJAX job.php

    We're also having this issue again. Other than once again purging the jobs table in the database, I don't know what to do about it. I know very little about the inner workings of xenForo, and there is no documentation on how the jobs manager works, so I would have an incredibly difficult time...
  9. Ghan_04

    XF 2.0 Job Manager Gone Crazy

    I did not find the cause, but removing the entries from the xf_job table appears to have cleared up the huge performance problem. Seems like this has cropped up a few more times and the discussion continues: https://xenforo.com/community/threads/infinite-http-requests-running-ajax-job-php.147830
  10. Ghan_04

    XF 2.0 Job Manager Gone Crazy

    I have done this, and these look like the queries I'm seeing that stack up on the database constantly. Looking through the includes, it seems to have all the addons listed. Page times bounce around anywhere between 0.08 and 0.5 seconds depending on how busy the server is at that moment. It...
  11. Ghan_04

    XF 2.0 Job Manager Gone Crazy

    We're using SMTP via Amazon to send emails. This does seem to be something to do with alerts (the xf_user_alert table has 186,000 entries). We have the Alert Improvements addon, but like I mentioned, I disabled all addons while troubleshooting this and it is still doing what is shown in the...
  12. Ghan_04

    XF 2.0 Job Manager Gone Crazy

    When I was watching xf_job before, I noticed that the last_run_date field was being updated every second on I think 11 of the entries. After renaming deferred.php, it looks like only a couple of them are updating now. But I'm not sure what I'm supposed to be looking for here.
  13. Ghan_04

    XF 2.0 Job Manager Gone Crazy

    For some reason, my database has been getting slammed recently by something to do with the xf_job table and scheduled jobs. The cron jobs themselves don't seem to be the source of the problem. What I see is this kind of thing filling up my database process list: I see queries like this...
  14. Ghan_04

    Need hosting advice

    It's tough to get good managed services with a low budget. You might want to take a look at getting an unmanaged VPS and just installing a decent control panel on it. There are some threads around here discussing control panel options if you're interested...
  15. Ghan_04

    Need hosting advice

    For unmanaged VPS, Linode or Digital Ocean would be the way to go here. $5 plan should be plenty to handle a site like that. Shared hosting is a bit more hit and miss depending on the provider. I'd hit up Web Hosting Talk for recommendations on that.
Top