I recently ran into an issue while updating my copy of Owncloud from version 6.0.1 to 6.0.3 and while the error occured while this specific update the error is common to MySQL so I figured why not share the love.
So in a nutshell when I tried to update the application I received the following error; read more
Handy tip for enabling the slow query log for MySQL for Centos / Redhat linux.
Stop MySQL by typing either “service mysqld stop” or “/etc/init.d/mysqld stop”
Edit the my.cnf file, usually found at “/etc/my.cnf”
Under [mysqld] add the following line;
Save the updated my.cnf file.
Do not start MySQL yet. We need to add the slow log file and location. To do this tpye the following into the command prompt;
chmod 660 /var/lib/mysql/slow.log
chown mysql:mysql /var/lib/mysql/slow.log
With the slow log file and location created with the proper permissions, now you can restart MySQL with “service mysqld start” or “/etc/init.d/mysqld start”
After some time review the log you created at “/var/lib/mysql/slow.log” using a text editor (Nano, Pico,Vi / VIM).
There you go! Hopefully this helps you drill down if you’re noticing slow performance due to MySQL. read more
Having changing my environment I found my self moving from iSCSI to NFS and of course since NFS is a mapped drive, I found that Crashplan doesn’t support mapped drives out of the box. To get around this I had to implement the fix below. This was something I found on the Crashplan website and wasn’t easily accessible via a google search, so I’m re-posting it for anyone else who finds themselves in the same situation. read more
Just a handy list of useful VMware PowerCLI commands. Keep in mind that many of these are examples and can be tweaked / adjusted as needed. This is just for your benefit and mine
Connect-viserver – This will connect you to the ESX / ESXi server. An example would be Connect-viserver 192.168.1.1 -user myname -password mypassword read more
If you’re wondering where the unmount option is to detach a datastore / LUN in VMware ESX / ESXi 4 I hate to be the one to break it to you but there isn’t one. Sadly the only way to remove a datastore / LUN in ESX / ESXi 4 is to delete the datastore / LUN , unlike with ESXi 5 where you actually have an unmount option. However it is possible to remove it using the delete option. read more