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 […]

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 […]

MySQL server has gone away, Issue & Solution [drupal]

MySQL server has gone away, issue on drupal, drupal ecommerce kickstart gives me alot of headache since I do not first aware that the issue because of there are so many packets execution on mysql with drupal. The full error is (or similar): Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error: […]

MySQL Workbench 6.x Preview

MySQL Workbench, a visual editor for MySQL database, one of the free and popular tool to manage database and modeling. MySQL Workbench version 6.x has been release since July 2013 after a long running of version 5.x. Here are some screenshot of MySQL Workbench 6.0.8 that I just installed: Learn more.

A recommandation or a Free GUI Tool for ER Diagram for PostgreSQL

pgAdmin3 which is coming by default when we install PostgreSQL but there is no GUI data modeling. Found from following list, there are some GUI tool but don’t know which one should be taking into account. – http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools – http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools Is there any recommended tool for GUI database modeling with ER Diagram like we have […]

MySQL issue & Solution: Illegal mix of collations for operation ‘=’

MySQL Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Overview I have two databases in mysql, I have written a sql to compare two table (dbA.contact & dbB.actor). Example: SELECT dbB.* FROM dbA.contact co, dbB.actor ac WHERE co.name = ac.name When I execute the request, I will get above error, why it […]