zfs Snapshot Commands Example

As i have already discussed in my previous post zfs filesystem and MySQL about zfs overview and two most important command zpool and zfs. I am going to continue with usage of zfs snapshots. It includes create a pool, Create file system, Taking a snapshot, Renaming Snapshots, Listing all snapshots, restoring from snapshot and Moving the snapshot to other location. A snapshot is a read-only copy of a file system...

Continue Reading →

zfs FileSystem and MySQL

ZFS is a new kind of 128-bit file system that provides simple administration, transactional semantics, end-to-end data integrity, and immense scalability. ZFS is not an incremental improvement to existing technology; it is a fundamentally new approach to data management. ZFS was first introduced in Solaris in 2004 and it is a default filesystem in OpenSolaris, but Linux ports are underway, Apple is shipping it in OS X 10.5...

Continue Reading →

MySQL Cluster Webinar: Best practices in scaling Web databases with Auto-Partitioning and SQL/noSQL Access

Register yourself here...

Continue Reading →

MySQL 5.6.3 Performance improvements

 Mark Callaghan at facebook tested the test release of MySQL 5.6.3 and he has found some performance improvement with InoDB feature. Read below... Mark tried two of the previews for MySQL 5.6.3 at http://labs.mysql.com/. His first attempt with the multi-threaded slave preview was not successful. Parallel apply on the slave is serial when the master does not also run 5.6.3. He said (I hope this changes as a typical upgrade is first done on the slave.) He was more successful with the InnoDB...

Continue Reading →

Reduced contention during datafile extension

Another performance problem found by PoorMansProfiler Innam rana said in his blog post on innodb blog: InnoDB has an internal file system management module that primarily manages the space in the data files. One of the pain points was the coarse level of locking used when a data file has to be extended. More about this issue can be found here. In the latest labs release we have fixed this problem. When we need to extend a data file inside InnoDB we write zero filled pages synchronously to the file. The user thread...

Continue Reading →

When does InnoDB compress and decompress pages?

There are two sections for rows in the page format for InnoDB compressed tables. The compressed section has one or more rows and must be decompressed to access individual rows. The modification log has uncompressed rows and rows can be accessed without decompressing. The modification log is used to avoid decompressing and then possibly recompressing the compressed section on every row change. The buffer pool also has separate uncompressed copies of some pages so that every row read does not require a page decompression. I...

Continue Reading →

MySQL Cluster Architecture

Introduction: MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, combining 99.999% availability with the low TCO of open source. Designed around a distributed, multi-master architecture with no single point of failure, MySQL Cluster scales horizontally on commodity hardware to serve read and write intensive workloads, accessed via SQL and NoSQL interfaces. MySQL Cluster's real-time design delivers...

Continue Reading →

getopts in shell script

getopts The getopts command simplifies the task of validating and parsing command line options and arguments for your shell scripts. Syntax: getopts <optstring name> [arg...] Example: Step1: First I define all my option holding variables. ListFiles=0 MoveFiles=0 email="" Step2: While loop. The following while statement loops through all the options and sets them to the corresponding variable. getopts returns true while there are options to be processed. The argument string, here "lme:h", specifies which...

Continue Reading →

GET SIZE OF DIRECTORY (EXCLUDE SUBDIRECTORY) IN UNIX

We all know du command to get the size of a directory. But the problem is when you use "du <directory name>" it will give you the list of all subdirectory including the directory you want with size. Bt what if i only want the size of directory which i have passed as an argument and not all the subdirectory? In that senario we can use: du -sh <directory name>                              ...

Continue Reading →

Turn on or off color syntax highlighting in vi or vim editor

Vim or vi is a text editor. It can be used to edit all kinds of plain text. It is especially useful for editing programs or UNIX/Linux configuration files.Turn on syntax highlighting: Open file (for example test.sh):$ vi test.shNow press ESC key to enter into command mode then type  ” : syntax on OR syn on”:syntax onOR:syn onThat’s it.. the color syntax highlighting will be enabled until you close that file (useful when you working on server where you can’t enable it permanently because of restriction and not...

Continue Reading →

mysql optimizer Index strategy

If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3). MySQL cannot use an index if the columns do not form a leftmost prefix of the index. Suppose that you have the SELECT statements shown here: SELECT * FROM tbl_name WHERE col1=val1;SELECT * FROM tbl_name WHERE col1=val1 AND col2=val2; SELECT * FROM...

Continue Reading →

Innodb plugin 1.0.4 fine tune for performance

SERVER SETTINGS (my.cnf)==========================================================================================================#The MySQL server always must be started with the option ignore_builtin_innodb, as long as you want to use the InnoDB Plugin as a shared library.ignore_builtin_innodb#load the InnoDB Plugin and all Information Schema tables implemented in the InnoDB Plugin when the server starts:plugin-load = innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so; innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset= ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so#To...

Continue Reading →

Linux Administration

Check out this SlideShare Presentation: Linux AdministrationView more presentations from Harish19...

Continue Reading →

Linux Introduction (Commands)

Check out this SlideShare Presentation: Linux Introduction (Commands)View more presentations from anandvaid...

Continue Reading →

Inno Db Internals Inno Db File Formats And Source Code Structure

Check out this SlideShare Presentation: Inno Db Internals Inno Db File Formats And Source Code StructureView more presentations from MySQLConferen...

Continue Reading →

Mastering InnoDB Diagnostics

Check out this SlideShare Presentation: Mastering InnoDB DiagnosticsView more presentations from guest8212...

Continue Reading →

Partitions Performance with MySQL 5.1 and 5.5

Check out this SlideShare Presentation: Partitions Performance with MySQL 5.1 and 5.5View more presentations from Giuseppe Max...

Continue Reading →

Linux performance tuning & stabilization tips (mysqlconf2010)

Check out this SlideShare Presentation: Linux performance tuning & stabilization tips (mysqlconf2010)View more presentations from Yoshinori Matsuno...

Continue Reading →

10x Performance Improvements

Check out this SlideShare Presentation: 10x Performance ImprovementsView more presentations from Ronald Bradfo...

Continue Reading →