Blogspot - adminlinux.blogspot.com - Admin Linux ... MySQL DBA
General Information:
Latest News:
MySQL : Altering Huge Tables 7 Dec 2010 | 11:31 pm
You have a huge mysql table - maybe 100 GB. And you need to run alter on it - to either add an index, drop an index, add a column or drop a column. If you run the simple mysql "alter table" command, y...
mysql-packages 13 Sep 2010 | 09:13 pm
The RPM packages usages and details: Ø MySQL-server-VERSION.glibc23.i386.rpm - The MySQL server. You need this unless you only want to connect to a MySQL server running on another machine. Ø MySQL-c...
Security Issues with MySQL ROOT Access 28 Jun 2010 | 12:48 am
Security Issues with MySQL ROOT Access MySQL offers simple but very effective security mechanisms. Unfortunately, the default installation of MySQL, and in particular the empty root password and the ...
MySQL Development History 25 Jun 2010 | 07:05 pm
MySQL Development History - MySQL was first released internally on 23 May 1995 - Windows version was released on January 8, 1998 for Windows 95 and NT - Version 3.23: beta from June 2000, production ...
Display Information About File - Stat 14 Jun 2010 | 06:51 am
In Unix/Linux world everything is treated as files. whether it is a devices, directories and sockets — all of these are files. Stat command displays file or file system status. [Prabhat@Server1 Arch...
MySQL : About LIMIT 0 , 30 3 Jun 2010 | 07:28 pm
Limit is used to limit your MySQL query results to those that fall within a specified range. You can use it to show the first X number of results, or to show a range from X - Y results. It is phrased ...
MySQL : Allocating memory for caches 28 May 2010 | 05:21 pm
Allocating memory for caches in MySQL If the server is dedicated to MySQL, any memory you don’t reserve for the operating system or for query processing is available for caches. MySQL needs more memo...
MYSQL : Checking and Reparing tables 26 May 2010 | 04:05 am
If your database is MySQL, though, there's still hope. Over the course of this article, I will show you how to use MySQL's built-in crash recovery tools to check your database, and hopefully recover a...
MySQL : Calculate Query Executed per second 9 May 2010 | 02:39 am
Here is a way to calculate Query Executed per second : time=10 begin=`mysql -e "show status" | awk '{if ($1 == "Questions") print $2}'` sleep $time end=`mysql -e "show status" | awk '{if ($1 == "Ques...
Problem : CTRL+S in Putty 7 Apr 2010 | 07:30 pm
Over the years, we all have habit of using CTRL+S every few minutes during working on a document, because we all had too much work lost from stupid errors; In the Windows world, CTRL+S is used as the ...
