Tag Archives: General

Day 9 Variables

In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing on other variables, there are Global Variables and Session/Local Variables which reflects the state of the MySQL and we can … Continue reading

Posted in Basic, MySQL, Others, What I learned today | Tagged , , , | Leave a comment

Day 8 Configuration- Command-line

Yesterday we discuss about different ways of options and configuring with environment variable which will place MySQL locate for values for parameters used during related program execution if it is not specified elsewhere, Today we will discuss about  Command-line options. … Continue reading

Posted in MySQL, Others, What I learned today | Tagged , | Leave a comment

Day 7 Configuration – Environmental Variable

On day 6 we discussed about Programs. today  is very important day, we will discussing about Configuration options or parameters. All the program requires options/parameters accordingly it works differently. as MySQL is an open source and everyone want to use its … Continue reading

Posted in MySQL, Others, What I learned today | Tagged , | Leave a comment

Day 6: MySQL Programs

On day 5 we understand how to install MySQL or upgrade to latest version. Today we will discuss once installation is done we will be having multiple executable programs by which MySQL Runs, every RDBMS has its executable. MySQL programs are … Continue reading

Posted in General, Installation, MySQL, Others | Tagged , | Leave a comment

Day 4: MySQL Architecture Continue…

MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL works on following options: Option/configuration file (my.cnf) System variables (Local /Global) Status variables My.cnf option file will have various Groups and … Continue reading

Posted in Basic, DB Design, High Avaliability, MySQL, Others, RDBMS, Replication, What I learned today | Tagged , | Leave a comment

Day 3: MySQL Architecture

Like other RDBMS MySQL also has similar architecture: Connection Layer/Application Layer Logical Layer (Processing) Storage Engine Layer (Physical) – special Connection layer responsible for connecting to RDBMS, there could be multiple protocol (TCP majorly used). It uses many drivers like … Continue reading

Posted in Internal, MySQL, Others, What I learned today | Tagged , | Leave a comment

Day 2: Introduction to MySQL

Story of MySQL is very interesting and involved emotions in it. This is my understanding and my though on Journey of MySQL. MySQL AB is (“My”) in 1995 by Michael Widenius (Monty) and team, as an open source by community … Continue reading

Posted in History, MySQL, Others, RDBMS | Tagged , | Leave a comment

HA between Windows and Linux

If you ask before couple of years about Microsoft and Linux can be compatible was a dream. now Microsoft has made SQL Server to work on Linux we have accepted that. It has some Middle OS to interact with Linux … Continue reading

Posted in Azure, High Avaliability, Others, SQLonLinux, What I learned today, Whats New | Tagged , , , , | Leave a comment

Count_Big() function

Learned new function for count while going through the channel 9 video for salva. where for a very big table count it gave an error :   Count_Big() – BOL: Returns the number of items in a group. COUNT_BIG works … Continue reading

Posted in BIGDATA, General, Others, What I learned today | Tagged , | Leave a comment

Happy New Year… Late:)

Yeah I know its new year and i am back from quite some time. during these days i was learning things but could not able to make time to blog about it. This year would like to write more on … Continue reading

Posted in Future DBA, General, Others | Tagged , | Leave a comment