Hello all, Today I will tell you about the top 5 inspiring movies for Programmers that inspired me to get more into programming. These movies are my personal choice and our interest may differ, I’ll not talk about the movies where some random guy sitting on multiple screens is hacking the whole world. I prefer […]
Difference between Application Software and System Software
Today we’ll talk about the difference between Application Software and System Software with the help of examples. System Software: System software is general purpose software which is used to operate computer hardware. It provides platform to run application software. For example operating systems like windows, linux. Application Software: Application software is specific purpose software which is […]
What’s new in MySQL 8.0?
So, a good news for all MySQL fans that the world’s most famous RDBMS is releasing it’s new version MySQL 8.0. The official release date is not declared yet but this is going to be exciting as they have added some really useful new features. So, why waste any time let’s see what’s new […]
Understanding MySQL Slow Query Logs
Hello all, here we are going to discuss about one of best performance problem solving method i.e. to understand the MySQL slow query logs and take important measures to ensure peak server performance. Let’s take an example of Slow Query Log:
|
1 2 3 4 5 6 7 8 9 10 |
root@server#tail -f /var/log/mysql_slow_query.log # Time: 2017-04-09T20:10:09.472872Z # User@Host: db_user[db_name] @ [x.x.x.125] # Query_time: 3.776369 Lock_time: 0.000269 Rows_sent: 0 Rows_examined: 308448 SET timestamp=1491768609; insert into tempo_table select * from tempo_table_tmp; |
Now let’s understand what each line indicates: The first line shows […]
MySQL DBA Interview Question Answers
Hello all, with my 5+ years of experience as MySQL DBA, I’ll share some of the most common MySQL DBA Interview Question Answers which I’ve faced in almost every interview, I’ll keep on adding more, hope this will help you: Read this post to get the overview of MySQL: MySQL Basics 1.Describe MySQL […]
Simplest way to Reset MySQL Root Password
Forgot your MySQL root password? Don’t worry I’ll tell you the simplest way to reset MySQL root password. This guide will work for Linux and Windows OS as well. So without wasting any valuable time lets start with the: Steps to reset MySQL Root Password: Step 1: Stop MySQL service: You can do this […]