Showing entries 11 to 18
« 10 Newer Entries
Displaying posts with tag: MySQL-Scripts (reset)
Stored procedure to Find database objects

This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables. It uses information schema database to gather information and storing in a temporary table. Usage: call xplore(database-name); – Procedure will search through information schema for […]

The post Stored procedure to Find database objects first appeared on ..::CHANGE is INEVITABLE::...

MySQL master master replication monitor with php code

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for monitoring a master master replication setup. It requires a single shared login id available on both MySQL servers. It will display in tabular format following […]

The post MySQL master master replication monitor with php code first appeared on ..::CHANGE is INEVITABLE::...

Calculate Mysql Memory Usage – Quick Stored Procedure

In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory usage estimation for the present MySQL instance. We have global buffers which are allocated irrespective of connections as and when mysql server is started. Along with […]

The post Calculate Mysql Memory Usage – Quick Stored Procedure first appeared on ..::CHANGE is INEVITABLE::...

Monitor multiple mysql replication using php: Updated

Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication we know commands like: Show slave status; Show master status; Refer: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-replication.html But when it comes to non-gui interface, it becomes little tedious. With some […]

The post Monitor multiple mysql replication using php: Updated first appeared on ..::CHANGE is INEVITABLE::...

Replication slave lag monitoring using heartbeat and windows batch scripts

“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter in monitoring and maintaining replication. This article explains us a way to monitor replication slave lag time. It also includes a sample batch scripts to […]

The post Replication slave lag monitoring using heartbeat and windows batch scripts first appeared on ..::CHANGE is INEVITABLE::...

Search / find through all databases, tables, columns in MySQL

What will you do if one day some one ask you to find single string in all databases, all tables and in all columns, In MySQL Database? I just read such question and tried to find a “ready made” solution. Reusability is Key Concept 😉 !! But I ended up finding no “copy-paste” material. Some of the posts […]

The post Search / find through all databases, tables, columns in MySQL first appeared on ..::CHANGE is INEVITABLE::...

Upload Image to MySQL using PHP

Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite simple code with two php files one to display and one to upload. For Image Upload code, I’ve added code download link upload-image-mysql-demo.zip at the […]

The post Upload Image to MySQL using PHP first appeared on ..::CHANGE is INEVITABLE::...

Perl Script for Analyze – Optimize – Repair Mysql Databases

The perl script is mainly created to avoid manual Mysql Server Maintenance. The script uses Perl module DBI. You need to provide access credentials and database name(optional). Regarding Analyse, Optimize and Repair you may ofcourse refer dev.mysql.com. OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you […]

The post Perl Script for Analyze – Optimize – Repair Mysql Databases first appeared on ..::CHANGE is INEVITABLE::...

Showing entries 11 to 18
« 10 Newer Entries