Jump to content

Chad

Level 2 Member
  • Content count

    190
  • Joined

  • Last visited

Community Reputation

10 Good

About Chad

  • Rank
    Level 2 Member
  1. Agreed and their support denies any slowness. Liars.
  2. Let me re-summarize: Slowness happened immediately after upgrading to 7.6. Prior on 7.5 and before, any page load in admin panel was lightning fast. Now, 2 seconds average any page at all in admin panel. Client side remains normal otherwise. Using default Blend theme. Already ran database repair, optimize via phpMyAdmin. Already ran "empty template cache" and cleared browser cache as well. Problem replicated in Firefox on Windows 10 and Safari on iPhone. Same slowness in admin panel. Adding below line to config file did not fix the problem at all. $disable_admin_ticket_page_counts = true; Server specs: 2 x Hex Core with 72GB RAM, SSD drives and only 2 domains hosted on the box. PHP 7.2 with MySQL/MariaDB 10.2 MySQL settings: [root@server ~]# cat /etc/my.cnf [mysqld] performance-schema=0 # GENERAL # local-infile=0 default-storage-engine = MyISAM # MyISAM # key-buffer-size = 16G myisam-recover = FORCE,BACKUP # SAFETY # max-allowed-packet = 16M max-connect-errors = 1000000 max_connections = 300 #sql-mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GR$ sysdate-is-now = 1 # BINARY LOGGING # #log-bin = /var/lib/mysql/mysql-bin expire-logs-days = 14 sync-binlog = 1 # CACHES AND LIMITS # tmp-table-size = 512M max-heap-table-size = 512M query_cache_type = 0 query-cache-size = 0 query_cache_limit = 0 join_buffer_size = 1M max-connections = 500 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 10240 wait_timeout = 600 sort_buffer = 8M read_buffer = 8M # INNODB # innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 1G innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 8G innodb_buffer_pool_instances = 8 performance_schema = ON # LOGGING # log-error = /var/lib/mysql/mysql-error.log slow_query_log = 1 long_query_time = 1 slow_query_log_file = /var/lib/mysql/mysql-slow.log log-queries-not-using-indexes = 1 max_allowed_packet=268435456 open_files_limit = 50000 bind-address=127.0.0.1 MySQL Slow Query Logs: # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.000140 Lock_time: 0.000031 Rows_sent: 5 Rows_examined: 5 # Rows_affected: 0 use user_billing; SET timestamp=1533245423; select 0, `title` from `tblticketstatuses`; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.000131 Lock_time: 0.000026 Rows_sent: 5 Rows_examined: 10 # Rows_affected: 0 SET timestamp=1533245423; select `title` from `tblticketstatuses` order by `sortorder` asc; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.000137 Lock_time: 0.000020 Rows_sent: 5 Rows_examined: 10 # Rows_affected: 0 SET timestamp=1533245423; select `id`, `name` from `tblticketdepartments` where `id` in ('6', '3', '12', '4', '2') order by `order` asc, `order` asc; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.000078 Lock_time: 0.000015 Rows_sent: 1 Rows_examined: 4 # Rows_affected: 0 SET timestamp=1533245423; select `title` from `tblorderstatuses` where `showpending` = '1'; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.003381 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 3968 # Rows_affected: 0 SET timestamp=1533245423; select count(*) as aggregate from `tblorders` inner join `tblclients` on `tblclients`.`id` = `tblorders`.`userid` where `tblorders`.`status` in ('Pending'); # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.009275 Lock_time: 0.000022 Rows_sent: 3 Rows_examined: 3950 # Rows_affected: 0 SET timestamp=1533245423; select count(id) as count, status from `tblclients` group by `status`; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.009296 Lock_time: 0.000029 Rows_sent: 6 Rows_examined: 5110 # Rows_affected: 0 SET timestamp=1533245423; select count(id) as count, domainstatus from `tblhosting` group by `domainstatus`; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.001413 Lock_time: 0.000025 Rows_sent: 8 Rows_examined: 800 # Rows_affected: 0 SET timestamp=1533245423; select count(id) as count, status from `tbldomains` group by `status`;
  3. @yggdrasil As I already stated, only admin side.
  4. No help from support in my case. They deny the slowness despite the obvious that others replicated this and it happened immediately after upgrading to 7.6 The server I'm running on has 2x Hex-Core with 72GB RAM, SSD and Mariadb 10.2. Sure isn't a server or hardware issue at all. It's their bugs.
  5. After upgrading to 7.6, I utilized the Maxmind features added. I added my license key, which matches my email/key in my Maxmind account. I get this error on new orders, attached. My settings are also attached. Any changes, recommendations for Maxmind settings at least?
  6. Didn't solve for me. Only happens on admin side, not client side. Takes 2 seconds to load pages.
  7. You mean it should look like this? $disable_admin_ticket_page_counts = 'true;' Anyway, both formats didn't do it for me.
  8. I just upgraded to 7.6 now and everything now loads very slowly, even using default Blend theme. This is not normal. I emptied template cache, optimized database via phpMyAdmin. Same thing.
  9. Curious if someone can explain how to apply some CSS to a custom field (dedicated server) order page. I want the description to have some basic CSS style applied. The custom field ID is: customfield283 The specific line: <span class="field-help-text"> Right below this line: <input name="customfield[283]" id="customfield283" value="" size="30" class="form-control" type="text">
  10. Can someone please explain an easy way to apply 3% credit card / PayPal convenience fee on select customers that have invoices above $2,000 (for example)? Thank you.
  11. Chad

    Update 7.5.0

    First enabled Ioncube Loader 10x per WHMCS update instructions. Updated WHMCS to 7.5.0. Now, WHMCS admin panel shows just this: Starting Loaded English Language File Loaded Other Language Files Updated arabic Updated czech Updated dutch Updated farsi Updated french Updated hebrew Updated hungarian Updated italian Updated portugues Updated russian Updated spanish Updated turkish Updated portugues-br Cleared cache, retried. Same thing. Also emptied templates_c cache files.
  12. Chad

    Domain Transfer Notice?

    The hook? Please explain how I can create a basic hook that only appears if they're ordering a domain transfer. As for the template, the closest and only template would be the domain transfer initiated one, which gets sent after they pay and initiate the transfer. Doesn't make sense, since they need to be warned prior to initiating the transfer to unlock their domain and remove the privacy (if there).
  13. Chad

    Domain Transfer Notice?

    Due to end user / customer confusion and lack of knowledge, I'd like to put a notice for ALL domain transfer attempts (to and from my company) when they order such service that: Domain must be unlocked first Privacy protection must be removed first Using ENOM module here. How can we put this global notice for such service (transfers in/out)?
  14. I tried that, gives no additional info at all. What vendor folder are you referring to?
×

Important Information

By using this site, you agree to our Terms of Use & Guidelines