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 Prepare the … Continue reading Owncloud: How to reset users’ password→