Hi Krydos, thanks for explaining. I altered my tables to MyISAM. Then I restarted my application and now the server is off again. Slowly I am afraid that I am causing these crashes... How can we figure it out? How can I improve my application? It works perfectly on a local mariaDB.
I'm reading and caring, but I don't understand ;-) What is Innodb, how can I stop using it and are there alternatives? I would like to send some few bytes to a MySQL database every 15 minutes. I use nodered for this task. Does nodered use innodb? At least I can stop my flows pushing the data to johnny...
Hey everybody, I'm quite new to this. I signed up yesterday to Johnny and started to send some data to a MySQL database. That worked quite good but since 3.5 hours the server seems not accessible and in the cpanel I get a message that the server is down. The MySQL server is currently offline. Error while connecting to MySQL: (XID 8f868x) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) Error while connecting to MySQL: (XID 8f868x) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1. Is there something wrong in my application posting the data or is the server really down? I'm quite confused... Thomas