Viorel-Cosmin Miron uhlhosting
🏠
uhlhosting
/ All STatus variables, filtered erros
Created
February 8, 2016 12:50
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Aborted clientsDocumentation 10 The number of connections that were aborted because the client died without closing the connection properly. | |
| Aborted connectsDocumentation 1 The number of failed attempts to connect to the MySQL server. | |
| Created tmp disk tablesDocumentation 2.8 k The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based. | |
| Handler read rndDocumentation 186.5 k The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly. | |
| Handler read rnd nextDocumentation 10.7 M The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. |
uhlhosting
/ Engintron log
Created
February 9, 2016 15:28
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@panel [/]# bash engintron.sh install | |
| ************************************** | |
| * Installing Engintron * | |
| ************************************** | |
| --2016-02-09 17:20:58-- https://github.com/nuevvo/engintron/archive/master.zip | |
| Resolving github.com (github.com)... 192.30.252.131 | |
| Connecting to github.com (github.com)|192.30.252.131|:443... connected. | |
| HTTP request sent, awaiting response... 301 Moved Permanently | |
| Location: https://github.com/engintron/engintron/archive/master.zip [following] | |
| --2016-02-09 17:20:58-- https://github.com/engintron/engintron/archive/master.zip |
uhlhosting
/ Slow-query-analyzed
Created
March 4, 2016 11:18
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@panel [~]# pt-query-digest /var/log/mariadb/slow_query.log | |
| /var/log/mariadb/slow_query.log: 17% 02:19 remain | |
| /var/log/mariadb/slow_query.log: 36% 01:42 remain | |
| /var/log/mariadb/slow_query.log: 55% 01:12 remain | |
| /var/log/mariadb/slow_query.log: 74% 00:40 remain | |
| /var/log/mariadb/slow_query.log: 92% 00:11 remain | |
| # 162.4s user time, 1s system time, 93.74M rss, 291.91M vsz | |
| # Current date: Fri Mar 4 12:17:24 2016 | |
| # Hostname: panel.uhlhosting.ch |
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 160114 18:00:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql | |
| 160114 18:00:03 [Note] /usr/sbin/mysqld (mysqld 10.0.23-MariaDB) starting as process 23065 ... | |
| 160114 18:00:03 [Note] InnoDB: Using mutexes to ref count buffer pool pages | |
| 160114 18:00:03 [Note] InnoDB: The InnoDB memory heap is disabled | |
| 160114 18:00:03 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| 160114 18:00:03 [Note] InnoDB: Memory barrier is not used | |
| 160114 18:00:03 [Note] InnoDB: Compressed tables use zlib 1.2.7 | |
| 160114 18:00:03 [Note] InnoDB: Using Linux native AIO | |
| 160114 18:00:03 [Note] InnoDB: Not using CPU crc32 instructions | |
| 160114 18:00:03 [Note] InnoDB: Initializing buffer pool, size = 128.0M |
uhlhosting
/ my2.cfg
Created
March 6, 2016 08:49
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysqld] | |
| default-storage-engine=MyISAM | |
| default-tmp-storage-engine=MyISAM | |
| innodb=OFF | |
| innodb_fast_shutdown=0 | |
| innodb_force_recovery = 1 | |
| myisam-recover-options = FORCE,BACKUP |
uhlhosting
/ IBD files
Created
March 6, 2016 09:12
Notice these are 2 different backup locations - One is /innodb.bak and second /root/uhlhosting/back
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@panel [~]# find ./ -name *.ibd | |
| ./uhlhosting/mysql/back/mysql/mysql/gtid_slave_pos.ibd | |
| ./uhlhosting/mysql/back/mysql/mysql/innodb_index_stats.ibd | |
| ./uhlhosting/mysql/back/mysql/mysql/slave_worker_info.ibd | |
| ./uhlhosting/mysql/back/mysql/mysql/slave_master_info.ibd | |
| ./uhlhosting/mysql/back/mysql/mysql/innodb_table_stats.ibd | |
| ./uhlhosting/mysql/back/mysql/mysql/slave_relay_log_info.ibd | |
| ./uhlhosting/mysql/back/mysql/roundcube/contactgroups.ibd | |
| ./uhlhosting/mysql/back/mysql/roundcube/dictionary.ibd | |
| ./uhlhosting/mysql/back/mysql/roundcube/identities.ibd |
uhlhosting
/ cpanel analyst reply
Created
March 6, 2016 09:57
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Please disregard Terrance's reply above. He replied to the wrong ticket by mistake. | |
| I am sorry to hear about the problems that you are having. I do see that Jesse was able to help and get MySQL back online for you. Your ticket was brought to my attention by one of our Level 1's on shift who has been monitoring the ticket at Jesse's request. | |
| Please note as both Jesse and Kaden stated repairing corruption is not something cPanel can do because we are not experts in database corruption repair and would not want to cause any more damage to your data. | |
| I see that you are still seeking some guidance on where to go from here in getting your sites back online and databases working. Since Jesse got MySQL/MariaDB reinstalled via our RPMs the database system itself is operational so this is good. | |
| The problem is that the current databases are likely still corrupted beyond repair and if the guide to repairing InnoDB issues by forcing InnoDB recovery did not work, there is not much else that can be done. Have you tr |
uhlhosting
/ my.cfg
Created
March 3, 2016 14:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [mysqld] | |
| innodb_read_io_threads = 2 | |
| innodb_write_io_threads = 4 | |
| innodb_buffer_pool_size = 1G | |
| innodb_buffer_pool_load_abort =ON | |
| #innodb_buffer_pool_load_at_startup =1 | |
| #innodb_buffer_pool_dump_at_shutdown =1 | |
| innodb_buffer_pool_instances = 1 | |
| innodb_log_file_size = 256M | |
| innodb_log_files_in_group = 2 |
uhlhosting
/ gist:a42872b00522602b7ecd
Created
March 6, 2016 11:19
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Could not restore account “highacid”: Failed to execute sql method do: (XID rwa3av) DBD::mysql::db do failed: Can't create table `whmxfer`.`queue_paneluhlhostinbacku20160306121853BsO` (errno: 165 "Table is read only") at /usr/local/cpanel/Cpanel/DBBackend.pm line 157. | |
| Cpanel::DBBackend::_retried_sql(Whostmgr::Transfers::Session=HASH(0x54d59b0), "do", "\x{a}--\x{a}-- Table structure for table `queue_paneluhlhostinbacku20"...) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 95 | |
| Cpanel::DBBackend::_retried_do(Whostmgr::Transfers::Session=HASH(0x54d59b0), "\x{a}--\x{a}-- Table structure for table `queue_paneluhlhostinbacku20"...) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1449 | |
| Whostmgr::Transfers::Session::_create_new_session(Whostmgr::Transfers::Session=HASH(0x54d59b0), "paneluhlhostinbacku20160306121853BsO") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1119 | |
| Whostmgr::Transfers::Session::_set_session_id(Whostmgr::Transfers::Session=HASH(0x54d59b0), "paneluhlhostinbac |
uhlhosting
/ gist:48c7a67d1b8c608e5683
Created
March 6, 2016 11:33
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Could not restore account “highacid”: Failed to execute sql method do: (XID cu3jmn) DBD::mysql::db do failed: Can't create table `whmxfer`.`queue_paneluhlhostinbacku20160306123158jt3` (errno: 165 "Table is read only") at /usr/local/cpanel/Cpanel/DBBackend.pm line 157. | |
| Cpanel::DBBackend::_retried_sql(Whostmgr::Transfers::Session=HASH(0x54d78e0), "do", "\x{a}--\x{a}-- Table structure for table `queue_paneluhlhostinbacku20"...) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 95 | |
| Cpanel::DBBackend::_retried_do(Whostmgr::Transfers::Session=HASH(0x54d78e0), "\x{a}--\x{a}-- Table structure for table `queue_paneluhlhostinbacku20"...) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1449 | |
| Whostmgr::Transfers::Session::_create_new_session(Whostmgr::Transfers::Session=HASH(0x54d78e0), "paneluhlhostinbacku20160306123158jt3") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1119 | |
| Whostmgr::Transfers::Session::_set_session_id(Whostmgr::Transfers::Session=HASH(0x54d78e0), "paneluhlhostinbac |