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
MySQL

How to fix “Current Profile Has no WMI enable” – MySQL Workbench

On My SQL Workbench 5.x or 6.x, to manage the administration stuff such as import/export. Somehow, you could face an error when click on those admin tool: Current Profile Has no WMI enable Solution To solve this, it’s simply :   On MySQL Workbench: Server Administration (on the right column) Click Manage Server Instances Select […]

Categories
PostgreSQL

Please set binary path for PostgreSQL Server from preferences. [pgAdmin 4-rc1]

pgAdmin 4 is a new version of PostgreSQL administration tool. It’s interface looks so cool and of course, more features would come with that. Any way, here is the first error I faced and I think people might need to know it when such as we try to backup/restore from the pgAdmin 4 (rc1) received […]

Categories
MySQL

[MySQL] Illegal mix of collations – Solved in direct request

In case, you have executed some request as following example UPDATE `td_invoice_zzz` zi, ts_zone zo SET `zzz_com_zon_id` = zo.zon_id WHERE zzz_com_zon_code = zo.zon_code; And you receive the error about illegal mix of collations as: Error Code: 1267. Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' You are trying to compare two fields that […]

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
MySQL

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

Categories
MySQL

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.

Categories
PostgreSQL

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

Categories
MySQL

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