It happened today… why? Well, I was testing parallel replication (slave_parallel_threads) and after setting the number of threads to zero and when started the slave I got this wonderful error message: MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: master.example.com Master_User: user Master_Port: 3306 Connect_Retry: 60 … Continue reading Relay log read failure: Could not parse relay log event entry→
Why?! To avoid a lengthy warmup period after restarting the server, particularly for instances with large InnoDB buffer pools. Things to be added to /etc/mysq/my.cnf: # Shortened warm-up times with a preloaded InnoDB buffer pool innodb_buffer_pool_dump_at_shutdown=ON innodb_buffer_pool_load_at_startup=ON Basically when MySQL receives the TERM signal will dump the InnoDB buffer pool /data/db/mysql/ib_buffer_pool and it will load it … Continue reading mysql: preload InnoDB buffer pool→
I won’t bore you with the details, so let’s just say that for some reason I don’t have the owncloud admin password anymore. I have spend lots of time on owncloud forum and found few more solution. In my point of view the below one is very simple and effective. Get the passwordsalt [codesyntax lang=”bash”] … Continue reading Owncloud: How to reset users’ password→