[MySQL]: Long running query stopper shell script & alerting mechanism
#!/bin/bash > /home/srinivas/MySQL_Long_Query_Kill.log RECIPIENT=srinivas@dbversity.com,santhosh@dbversity.com RECIPIENTCC=test@dbversity.com RECIPIENTBCC=dbversity@gmail.com SEC=700 IFS=’|’ if [[ $SEC -lt 700 ]]; then echo “Usage: All the MySQL queries are less than $SEC seconds, So no MySQL process to Kill ….” exit 1 fi mysqladmin proc -v|grep Query|grep…
Difference between MySQL INT(1) or INT(10) .. etc
I know im not alone in thinking that it affected the size of the data field. An unsigned int has the max value of 4294967295 no matter if its INT(1) or int(10) and will use 4 bytes of data. …
[MySQL]: Top MySQL DBA Interview questions
The first questions I would ask when interviewing a potential DBA would be one that would help me find out about his/her skills and in particular if they are aware of MySQL specific idiosyncrasies. Instead of asking about specific query,…
Enabling GTIDs for server replication in MariaDB 10.0
Replication has been one of the most popular MySQL features since it made its way into the application more than a decade ago. However, as replication implementations became more complex over time, some limitations of MySQL’s original replication mechanisms started…
MySQL to MariaDB Migration in 5 steps
How to migrate from MySQL to MariaDB on Linux in five steps You’ve decided to move from MySQL to MariaDB, but you’re a little nervous. The last thing you want is to become mired in a slough of brokenness. Don’t…
[MariaDB]: Four key client commands
It’s time to get to know four of the most commonly used administration commands for your MariaDB server: mysql,mysqladmin, mysqldump, and mysqlimport. The examples run these commands on the server rather than over the network. You’ll be prompted for your…
How to get rid of orphaned InnoDB temporary tables
If InnoDB or XtraDB in MySQL or MariaDB are interrupted while performing an ALTER TABLE, they’ll leave a temporary table sitting in your data directory. This thing will be taking up space, which is no good. If you’re usinginnodb-file-per-table, or…
MySQL MariaDB version 10.0.10 Installation
I needed to test the new SkySQL server audit plug-in 1.1.7 on latest MariaDB 10.0.10 More info about that handy plug in you may find here : http://www.skysql.com/downloads/mariadb-audit-plugin Take a moment to read the info, along with that nice…
[ RDBMS to MongoDB ] Best practices for Migration
Relational databases are being pushed beyond their limits because of the way we build and run applications today, coupled with growth in data sources and user loads. To address these challenges, many companies, such as MTV and Cisco have migrated…
[MySQL]: Load data infile
[root@dbversity tmp]# ll -lhtr CSV_* -rw-r–r– 1 oracle dba 298K Nov 26 02:39 CSV_DBV_HLDNGS.csv -rw-r–r– 1 oracle dba 489K Nov 26 02:40 CSV_DBV_DATA.csv -rw-r–r– 1 oracle dba 86K Nov 26 02:40 CSV_PS_RELN_BSNL.csv [root@dbversity tmp]# [root@dbversity tmp]# dos2unix CSV_* dos2unix: converting…