Categories
MySQL

Import file size limit in PHPMyAdmin

Performance tuning is very important and there are still a lot of question around, here our tips to help base on our experience. Import file size limit in PHPMyAdmin For uploading large files through PHPMyAdmin, follow these steps: Step 1: Open your php.ini file. Step 2: Upgrading Memory Limit: memory_limit = 750M Step 3: Upgrading…

Categories
General

Tomcat 8 Performance Setting

Tomcat 8 comes with more performance features comparing to previous version, this version, Tomcat is using NIO2 according to Jboss’s blog. You might interesting to read Tomcat 8 overview at this slideshare by SpringIO. The performance setting of tomcat is similar to other previous version of tomcat as I already stated in my previous post…

Categories
Java

Monitor Java Application with JConsole

You might need to monitor your java application in order to examine the memory or CPU usage. JConsole is free and available in your JDK from version JDK 5 up. About JConsole Jconsole is a JMX-compliant monitoring tool.  It uses the extensive JMX instrumentation of the Java virtual machine to provide information on performance and…

Categories
Drupal MySQL PHP

My Recommendation Performance Settings [Drupal]

I posted some posts about drupal since I started to implement things with drupal. Issue with “Maximum execution time“ Issue with “MySQL server has gone away“ And still with memory “The InnoDB memory heap“ Here is my own recommendation for Drupal or some heavy PHP/MySQL application. php.ini max_execution_time=5000 memory_limit=1024M my.ini [mysqld] max_allowed_packet = 128m sort_buffer_size…

Categories
MySQL

MySQL: The InnoDB memory heap is disabled

When you start your MySQL server, check in the log, you might found this warning message: [Note] InnoDB: The InnoDB memory heap is disabled The memory heap is related to performance of the MySQL with engine of InnoDB Solutions The issue would be solved by provide the setting in my.cnf/my.ini as [mysqld] # Comment the…

Categories
Apache Tomcat

GZip Compression on Web App Deployed with Tomcat

Performance is very important to save resource for visitors using our website. If you deploy your Java Web Application on Apache Tomcat and you feel it’s a bit slow, please check it out my experience on solving issue of gzip compression by changing configuration of Apache Tomcat. Result: Before/After Correction Solutions Edit file: apache-tomcat-xx\conf\server.xml change…