Web Performance Optimization

Web performance Optimization

We optimize your website by analyzing the pattern of the website. By using improved methods of optimization we makes your web pages fly while rendering.

Some of the points from our checklist are:

  • By improving your code, optimizing JS for non-blocking while rendering.
  • Sharing the web page load(I/O) by using a CDN and Seprate Session and Caching servers.
  • By Using Caching technology like Varnish, aiCache.
  • Using shared network caching like Memcached, Redis.
  • Optimizing the structure of your website for faster rendering in browsers like IE.
  • Optimizing Database Servers like Mysql, PostgreSQL for dynamic websites.
  • Web Server Optimization for web servers like Nginx, Apache, IIS, Tomcat, IBM Http Server, JBOSS, Express.
  • Using right Headers for Cache Control.
  • Image Optimization and Compression.

 

Read More...

MySql

Set timezone of Mysql Server

Many times timezone issues with your database server causes wrong information to be entered in reports, transaction tables etc.

To fix timezone issues with your mysql server, just login to your mysql and execute following query:

SET GLOBAL time_zone = ‘<REQUIRED TIMZONE>;

E.g. SET GLOBAL time_zone = ‘+5:30’;

If you have to get the  current timezone, use this- SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);

Read More...

MySql

Import a CSV File to Mysql Database

To Import a CSV File in MySQL Database execute this query with path to the csv file you need to import:

LOAD DATA LOCAL INFILE ‘filetoimport.csv’

INTO TABLE <tablename>

FIELDS TERMINATED BY ‘,’

LINES TERMINATED BY ‘\n’

(field1, field2, field3….,field-n);

[box type=”info”] Remember to match the columns in your csv and MySQL table.[/box]

Read More...

MySql

Check Database size in Mysql

Use this Query to check the Database size in Mysql:

[box] SELECT table_schema “database_name”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB” FROM information_schema.TABLES GROUP BY table_schema;[/box]

Read More...

Linux, MySql

Mysql Socket issue

Sometimes mysql gives an error while starting/opening mysql service for the socket, It happens when your mysql socket get corrupted.
To create a new socket you just need to:
Comment the socket settings in /etc/my.cf
Restart mysqld and httpd 🙂

Read More...