Activities

January 2019
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

MySQL : Improving performance through thread_cache_size

We can improve the MySQL server performance at the best level if it is being used for read operations most of the time. Based of the Database server analysis, it is observed that more than 70% of traffic is being used “select” statements ie read operations. So I increased the “query_cache_size” and found faster throughput […]

How do I enable huge TLB on MySQL server

To get maximum hardware acceleration via reducing Tranaction Lockside Buffer (TLB) ie Applications that perform a lot of memory accesses may obtain performance improvements by using large pages due to reduced Translation Lookaside Buffer (TLB) misses.

Here is the quick guide to setup this one for a single core 3.7G RAM AWS instance for […]

RDS- MySQL : How do I find the database size and bigger tables

I have to know the disk consumed by the MySQL data on a RDS server hosted in Amazon cloud. One of the easy thing which I used was PhpMyAdmin UI and check the tables brief list. Unfortunately this database has more than 500 tables. So I feel it’s a lazy approach.

When I started […]

How do I convert all MyISAM tables to InnoDB storage engine

One of my client needs to improve the sql query performance as well as to gain better performance on his platform. So I’m planning to convert all the 543 tables to convert InnodDB storage engines to use the 15GB RAM added to the server. It’s very hard to execute the “ALTER TABLE <table _name> ENGINE […]

InnoDB: The error means mysqld does not have the access rights to

I’m migrating my CentOS 6.4 Desktop to Ubuntu 14.04 LTS on this week as I found that CentOS 7 was not much Great that I expected. It does not support aged hardwares.

While I’m changing MySQL data directory to a different location and initializing the server. I got a strange error like this “InnoDB: […]

MySQL : How do I store Slow sql queries in to a Table

One of the Dev. find difficulties to populate the large slow queries file which he ask to fix the Application performance issue. After few checking he informed me we can log slow queries on one the system table in MySQL version 5.5. So that we can pragmatically manipulate and explore it easily.

But I do […]