MySQL

MySQL (InnoDB) server recovery

Tags: innodbMySQLrecovery

Published on : July 18, 2014 by

MySQL (InnoDB) server recovery

InnoDB server rarely crashes. In majority of the cases, the corruption in the db can be fixed by repairing the table alone. Here we are discussing a severe table space corruption in ibdata1, ib_logfile0,ib_logfile1  files and the server fails to start even after multiple attempts. I shall try to explain the issue in view of […]

Continue Reading...


MySQL: Server Optimisation guide lines

Tags: MySQLmysql optimizationServer Management

Published on : October 7, 2012 by

MySQL: Server Optimisation guide lines

Mysql server optimization requires customization of various values based on the requirement and availability of resources. An admin needs to be shrewd while making a decision about the values to be placed for each variable to fine-tune it to provide excellent performance. To avoid the overhead of calculating each variable, most admins prefer to copy […]

Continue Reading...


MySQL & phpMyAdmin – Truncate didnt free the innoDB space

Tags: innodbMySQLphpmyadminTableTruncate

Published on : April 7, 2012 by

MySQL & phpMyAdmin – Truncate didnt free the innoDB space

Situation :In cPanel database management we have come across the issue that the truncate didn’t free the innoDB space. The issue is that we have Configured the MySQL server with innodb per table. There was a table comments having approximate 600+ MB size all because of comment spamming. I went to the table field in […]

Continue Reading...


Simple backup script for remotely backing up databases

Tags: backupbackupscPanelcpanel mysql backupdatabaseMySQLmysqldumpremoteremote mysql backupscript

Published on : May 25, 2011 by

Simple backup script for remotely backing up databases

This database backup script is actually a small modification of another backup script available in Google. I am not able to get that URL to mark/link reference. The only modification I added is a four liner to remove a week old backup automatically. You may also see https://www.supportsages.com/2011/05/applying-wildcards-in-grant-option-of-mysql/ as well. Indenting in python is lost, […]

Continue Reading...


Applying wildcards in GRANT option of MySQL

Tags: backupscPanelcPanel server backupdatabaseMySQLmysqldump

Published on : by

Applying wildcards in GRANT option of MySQL

In MySQL server support, We had this particular requirement of creating a database user to be used to backup only the cPanel databases. Only recently the database mapping has been introduced by cPanel which allows the clients to create databases without the _ . However on all our client servers, we insist to have the […]

Continue Reading...


Let's Connect

Categories

Your Cart

Cart is empty.

Subtotal
₹0.00
APPLY
0
Send this to a friend