- XFS wasn’t *really* being formatted optimally for the RAID stripe size
- XFS wasn’t being mounted with the …
Following my previous post, I got some excellent feedback in the forms of comments, tweets and other chat. In no particular order:
In my last post, I learned in disappointing fashion that sometimes you need to start small and work your way up, rather than trying to put together a finished product. This go-round, I’ll talk about my investigation into disk IO.
In an effort to better understand the hardware I have and it’s capacities, I started off by just trying to get some basic info about the RAID controller and the disks. This hardware in particular is a Supermicro, with a yet unknown RAID controller and 16 4TB disks arranged in RAID 6. Finding out more …[Read more...]
As many learning experiences do, this one also starts out “So I was working on a project at work and…”. In this case, the end result is to try to run as many concurrent copies of MySQL on a single server as possible, maintaining real time replication each running differing data sets. To help with this, I sent out to do this on a server with 36 7200rpm 4GB SATA disks, giving me roughly 120TB of available space to work with.
This isn’t an abnormal type of machine for us. Sometimes you simply need a ton of disk space. There is a quirk with this particular machine that I’ve been told: the RAID controller has some …[Read more...]
Normally, when we want to start PXC (Percona XtraDB Cluster) on RHEL/CentOS 6 or older then that, we can simply start with init.d script or service command. i.e
shell> /etc/init.d/mysql start OR shell> /etc/init.d/mysql bootstrap-pxc
shell> service mysql start.
So now, we have to start mysql with systemctl command …[Read more...]
Join 27,000 others and follow Sean Hull on twitter @hullsean. I was shocked to find this article on ReadWrite: The Truth About DevOps: IT Isn’t Dead; It’s not even Dying. Wait a second, do people really think this? Truth is I have heard whispers of this before. I was at a meetup recently where the […]
After mysql installation, To make mysql server production ready we have to tune default mysql variables considering the hardware, production load, performance, durability etc.
But What about the optimizing Linux OS settings with mysql ?
Here it is, i encountered an issue once when i was checking TOP output for mysqld process and found that the mysqld memory continuously increasing. Also there was one more thing that it was using swap memory even if there was enough RAM memory available. we have monitored …[Read more...]
Normally, sysbench 0.4.12 version can be installed from repositories like “apt-get install sysbench” but the newer version 0.5 is not added in any repo yet (AFAIK) so, it’s bit difficult to install it.
1. Install bzr package if it’s not installed. (i.e apt-get install bzr)
2. Download the code from branch. (i.e bzr branch lp:sysbench) https://code.launchpad.net/~sysbench-developers/sysbench/0.5
root@deb-pxc56-2:~# bzr branch lp:sysbench You have not informed bzr of your Launchpad ID, and you must do this to write to Launchpad or access private data. See …[Read more...]
It is sometimes required to get the result of a stored procedure
in a variable which can be used later or to output the
To do so, we can use the "OUT" parameter mode while defining stored procedures.
In the below section, we will be writing a stored procedure to get the square root of a number returned in an output variable provided by us.
Stored Procedure Definition:
Store the below stored procedure in a file named …
Actually, I found this error many times, while installing MySQL/Percona servers with MySQL Sandbox.
To resolve this issue, first, you have to make sure that, SSL is installed /update properly.
sudo apt-get update sudo apt-get install libssl1.0.0 libssl-dev
After installing this you have to create appropriate link to make it work.
For 32 bit
cd /usr/lib/ sudo ln -s libssl.so.1.0.0 libssl.so.6 sudo ln -s libcrypto.so.1.0.0 libcrypto.so.6
For 64 bit:
cd /usr/lib/x86_64-linux-gnu sudo ln -s libssl.so.1.0.0 libssl.so.6 sudo ln -s libcrypto.so.1.0.0 libcrypto.so.6
Normally this should work for CentOS …[Read more...]