Server Startup programs in MySQL

Startup programs 


                           mysqld

                        mysqld_safe

                        mysql.server

                        mysqld_multi


mysqld :

                  mysqld is the server daemon.
                mysqld must be started and be running at all the times expect for maintenance.
                mysqld is a single multithreaded program 
                All data insert in to the database  using server program

mysqld_safe :

                  mysqld_safe is one of the server startup program script
                Many options are used for mysqld and mysqld_safe 

mysql.server :

                Another server startup program script, used for V-style run directories containing script
                It start system service at particular run level
                It can able to use on OS such as linux and solaris


mysql_mult :         

                 This is a startup program script to start or stop multiple MySQL server 
                Processes that list to connections on different unix socket files and TCP/IP ports
                

Comments

Post a Comment

Popular posts from this blog

Python if....elif....else statements

Image
python if... Statements:                python if..  statement is used for decision making operation.      It contains the body of code which will run only when the conditions given in the if statement is true if only ---- when condition True : if.. flowchart Example: #if only ------ condition true x = 100 y = 50 if x > y: print ( "greater then y" ) print ( "condition true" ) Output: greater then y condition true                In this example we have two variable x=100,y=50 and we create if expression [if x > y:] then we give statement [print("greater then y")]    if condition expression is true then statement is pass .then outside of if statement print will be execute. if only ---- when condition False:               I n this example we have two variable x=100,y=50 and we create if expression [if x < ...
Read more

What is InnoDB - Why InnoDB use - ACID properties

InnoDB innodb is a storage engine database management system (DBMS) MySQL and MariaDB InnoDB release on MySQL 5.5.5 in 2010 its provide ACID-compliant transaction features what is InnoDB in MySQL InnoDB has evolved from being a storage subsystem to a general-purpose storage engine for MySQL.                  Its combination of high performance and high reliability,                  It was made the default storage engine from Version 5.6 onwards.                MySQL can handle large volumes of reads and writes                A DBMS is a tool that allows you to store, index, and retrieve data in a table ACID:                  Atomicity, consistency, isolation, durability is a set of properties of data...
Read more

Inheritance-Object Oriented Programming (OOPs) concept in python

Image
  Inheritance                       Inheritance is the most important aspect of object-oriented programming.  It provides the re-usability of the code.                     Parent class :It is base class  , child class :another class and also called child class Types of Inheritance:                    Single inheritance                     Multilevel inheritance                     Multiple inheritance                     Hierarchical inheritance                     Hybrid inheritance The Single Inheritance            ...
Read more