We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Help me. STOP mysql auto service
Help me. STOP mysql auto service
My VPS setup STOP Mysqld Vestacp often for unknown reasons. I use the VPS Digitalocean
We wish ADMIN and support you in my forum fixing
This is the error I get every time services are Mysqld STOP " Error establishing a database connection "
This is my site https://sharelachuan.com
Regards !
We wish ADMIN and support you in my forum fixing
This is the error I get every time services are Mysqld STOP " Error establishing a database connection "
This is my site https://sharelachuan.com
Regards !
Re: Help me. STOP mysql auto service
What OS on your server?
Write more about problem
Write more about problem
Re: Help me. STOP mysql auto service
Screenshot images errorimperio wrote:What OS on your server?
Write more about problem
http://i783.photobucket.com/albums/yy11 ... dlep2w.png
Mysqld restart Failed
Commandline SSH
http://i783.photobucket.com/albums/yy11 ... o22k7p.png
Vestacp
http://i783.photobucket.com/albums/yy11 ... qe7xnv.png
I'm using Centos 6.7 x32
It is frequently also the error is about 1-2 days
Regards.
Toi Duy
Re: Help me. STOP mysql auto service
What's mysql error log say? -> /var/log/mysqld.log
https://vestacp.com/docs/#config-log-lo ... hel-centos
https://vestacp.com/docs/#config-log-lo ... hel-centos
Re: Help me. STOP mysql auto service
My log mysqlskurudo wrote:What's mysql error log say? -> /var/log/mysqld.log
https://vestacp.com/docs/#config-log-lo ... hel-centos
160623 21:53:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160623 21:53:22 [Note] /usr/libexec/mysqld (mysqld 5.5.50) starting as process 13496 ...
160623 21:53:22 [Note] Plugin 'FEDERATED' is disabled.
160623 21:53:22 InnoDB: The InnoDB memory heap is disabled
160623 21:53:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160623 21:53:22 InnoDB: Compressed tables use zlib 1.2.3
160623 21:53:22 InnoDB: Using Linux native AIO
160623 21:53:22 InnoDB: Initializing buffer pool, size = 128.0M
160623 21:53:22 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
160623 21:53:22 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160623 21:53:22 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
160623 21:53:22 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
160623 21:53:22 InnoDB: Waiting for the background threads to start
160623 21:53:23 InnoDB: 5.5.50 started; log sequence number 0
160623 21:53:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160623 21:53:23 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160623 21:53:23 [Note] Server socket created on IP: '0.0.0.0'.
160623 21:53:23 [Note] Event Scheduler: Loaded 0 events
160623 21:53:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.50' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
160623 23:20:28 [Warning] IP address '103.200.116.232' could not be resolved: Name or service not known
160624 1:03:00 [Warning] IP address '58.221.44.81' could not be resolved: Name or service not known
160624 3:24:13 [Warning] IP address '113.108.21.16' could not be resolved: Name or service not known
160624 3:24:15 [Warning] IP address '113.108.21.16' could not be resolved: Name or service not known
160624 3:49:37 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:49:47 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:49:58 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:10 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:14 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:26 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:29 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:44 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:59 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 8:10:45 [Warning] IP address '222.174.5.42' could not be resolved: Name or service not known
160624 9:08:23 [Warning] IP address '218.244.254.49' could not be resolved: Name or service not known
160624 13:17:42 [Warning] IP address '119.147.115.12' could not be resolved: Name or service not known
160624 19:23:57 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 19:23:58 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 19:24:00 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
Re: Help me. STOP mysql auto service
It's all nothing more?duytoi wrote:My log mysqlskurudo wrote:What's mysql error log say? -> /var/log/mysqld.log
https://vestacp.com/docs/#config-log-lo ... hel-centos
Re: Help me. STOP mysql auto service
exactly. That is all the logskurudo wrote:It's all nothing more?duytoi wrote:My log mysqlskurudo wrote:What's mysql error log say? -> /var/log/mysqld.log
https://vestacp.com/docs/#config-log-lo ... hel-centos
You need to provide more information ?
Re: Help me. STOP mysql auto service
You can make changes in my.cnf file and reload MySQL.
I think mysql eat too much.
I think mysql eat too much.
Code: Select all
wait_timeout=10
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log
key_buffer_size = 64M
myisam_sort_buffer_size = 32M
join_buffer_size=1M
read_buffer_size=1M
sort_buffer_size=2M
table_cache=512
thread_cache_size=8
interactive_timeout=25
connect_timeout=5
max_allowed_packet=1M
max_connect_errors=1000
query_cache_limit=2M
query_cache_size=128M
query_cache_type=1
tmp_table_size=16M
#innodb_use_native_aio = 0
innodb_file_per_table
Re: Help me. STOP mysql auto service
Thank you for your support . Let me change the my.cnf configuration file with the information you provide.skurudo wrote:You can make changes in my.cnf file and reload MySQL.
I think mysql eat too much.
Code: Select all
wait_timeout=10 interactive_timeout=50 long_query_time=5 #log-queries-not-using-indexes #log-slow-queries=/var/log/mysql/log-slow-queries.log key_buffer_size = 64M myisam_sort_buffer_size = 32M join_buffer_size=1M read_buffer_size=1M sort_buffer_size=2M table_cache=512 thread_cache_size=8 interactive_timeout=25 connect_timeout=5 max_allowed_packet=1M max_connect_errors=1000 query_cache_limit=2M query_cache_size=128M query_cache_type=1 tmp_table_size=16M #innodb_use_native_aio = 0 innodb_file_per_table
I have not found a place to my.cnf file, my.cnf file path to where? ^_^
Re: Help me. STOP mysql auto service
/etc/my.cnfduytoi wrote: I have not found a place to my.cnf file, my.cnf file path to where? ^_^
https://vestacp.com/docs/#config-log-lo ... hel-centos