I tried to modify datadir where at /usr/local/etc/mysql/my.cnf to new path and restarted MySQL.
But when I showed variable of datadir, It was still at original path.
I tried those steps
1. stop MySQL
1. ee /usr/local/etc/mysql/my.cnf
2. datadir=/var/db/mysql ====> datadir=/newdir
3. cp -r...
I want create a zvol for DB Host , can you help me for below question,Please?
1. what is different between Thin and reserve Zvol, in get to high performance? which is preference for performance and IOPS?
Not real good with scripting. But, I through my hat in the ring.
I was in dire need of a DB backup script that wrote to an inserted, but mostly unmounted rdx drive, regardless of mount situation. I also needed it to keep sanity in that backups older than 30 days needed to be pruned. Logs needed...
So, I'm writing a little database server/manager (I know, don't reinvent the wheel, but is a research project and I got a good idea, innovative, I hope) and from the beginning I thought to write it in Java, but after some researching about "performance and memory issues" I'm not...