Clota Blog

Category: My SQL

  • MySQL master – slave replication setup

     Hi guys, I hope you are doing great. Today here I am going to explain about MySQL master – slave replication setup. For the setup I have two servers clota-labl01 and clota-labl02. Here on clota-labl01 I am going to setup master and clota-labl02 as slave DB. Connect master server… ++++++++++++++++++++ clota-labl01 ++++++++++++++++++++ my.cnf configuration… =================…

  • Pages and Extent in SQL Server

     Hey guys, In this blog I am going to explain you about Pages and Extent in SQL Server and also different types of pages in SQL Server Pages – A page is a unit of data storage in SQL. The size of a page is 8Kb. The data rows are put on the page serially after…

  • SQL Server Network Configuration

    Hey guys, hope you are doing great. In this blog I am going to explain you about SQL Server Network Configuration and enabling/disabling different protocols. SQL Server Network Configuration – SQL Server Network Configuration involves enabling the protocols that manage the connection to the SQL Server and configuring the available options for these network protocols. It…

  • Database Maintenance Plan

    Hii guys, I hope you are doing great, today here I am going to explain you about the Database Maintenance Plan.  Database Maintenance Plan- A database maintenance plan is a set of specific, proactive tasks that need to be performed regularly on databases to ensure their adequate performance and availability. Uses of Maintenance plan– The…

  • Enabled DAC to connect remotely

    Hello there, everyone! I hope everything is going well for you. Today, I’ll show you how to use the DAC and how to enable it for remote connections. DAC- The dedicated admin connection (DAC) can assist you in getting out of a bind. This was created to assist you in connecting to SQL Server and…

  • Out of Memory Killer in Linux OS

    In Linux systems, MySQL generally has a concept called Out of Memory killer OOM controlled by the kernel. This is to prevent the possible runaway process in OS to avoid race conditions and a server crash.  Since MySQL and its optimized memory buffers are memory hogs, the OS may often kill the mysqld process to…

  • Deterministic and Nondeterministic Functions

    Deterministic functions: Deterministic functions always result in the same output every time they are called with a fixed set of input values and given the same condition of the database.  For example, AVG() function always results the same result given the qualifications stated above. Nondeterministic functions: Nondeterministic functions result in different output each time they…

  • Page Life Expectancy (PLE) in SQL Server

    Hey guys, In this blog I am going to explain you about Page Life Expectancy and How to monitor it. Page Life Expectancy (PLE)- Page Life Expectancy (PLE) is an age of a data page in seconds in the buffer cache or buffer memory after querying the tables with the loading data page into the buffer memory.…

  • Detach and Attach in SQL Server

    Hello there, everyone! I hope everything is going well for you. Today, I’ll show you about Detach and Attach Detach SQL Server Database- A SQL Server database is made up of at least two files: a data file (mdf) and a log file (ldf), though there may be additional data files in some circumstances. Since…