MySQL Architecture When a query comes to MySQL from Client program it will go to Query parsing (hear it will check for SQL syntax by checking every character in SQL query and generate SQL_ID for each SQL query.) then it will sent to Optimization … Read More
MySQL Database Client programs & MySQL Workbench Below are few MySQL DB client programs MySQL – Mysql is a program actually connects to database. Most MySQL distributions include all of these programs, except for those programs that are platform-specific. (For example, the server startup scripts… Read More
Client/Server architecture of MySQL Networked environment using a client/server model. -central acts as server -Various client programs connects to the server and make requests. Components Of MySQL Installations : The MySQL Database also follows the client and server model architecture and following are the components… Read More
Introduction to MySQL Database Administration. What is MySQL? MySQL is the most popular open source SQL database management system and it is developed, distributed and supported by Oracle Corporation. Initially MySQL was introduced by MySQLAB organization and acquired by SUN MICRO SYSTEMS then MySQL acquired… Read More
reference of this article from : www.orskl.com CONDITIONS & INTERACTIVE SCRIPTS IF clause Advanced IF usage CASE statements Display user messages User input 1.IF clause General At times you need to specify different courses of action to be taken in a shell script, depending on the… Read More
Unix Shell Scripting For DBA’s (PART – 08) Continuing from previous article. Unix Shell Scripting For DBA’s (PART – 07) 3.AWK programming This filter is among the most powerful filter which in itself a scripting language this filter was invented by three authors A-aho W-whenenberg… Read More
Unix Shell Scripting For DBA’s (PART – 07) GNU GNU stand for “GNU’s Not Unix!” reference of this article from : www.orskl.com It is a recursive acronym chosen because GNU’s design is Unix-like, but differs from Unix by being free software and containing no Unix code. Here we… Read More
Creation of Directories in Unix file system. What exactly is a directory ? we can say a directory is collection of files where files can be stored which will be helpful for the user to search the file Directory name Typical contents… Read More
Unix Shell Scripting For DBA’s (PART – 06) reference of this article from : www.orskl.com refer previous article https://www.ktexperts.com/unix-shell-scripting-for-dbas-part-05/ Regular expressions What are regular expressions? A regular expression is a pattern that describes a set of strings. Regular expressions are constructed analogously to arithmetic expressions… Read More
Unix Shell Scripting For DBA’s (PART – 05) reference of this article from : www.orskl.com Expansions and aliases General After the command has been split into tokens (see Section 1.4.1.1), these tokens or words are expanded or resolved. There are eight kinds of expansion performed, which… Read More
