Well, I am not a DBA and I don’t know something like this very much. But my company encourage me to take a course on DB2 V.9. And I have one command that I wanted to remember and I know that it will benefit me later on. MERGE So, basically, you have to table and [...]
1. Open the MySQL options file, the file is called my.cnf (Linux) – are in the / etc / my.cnf – or my.ini (Windows) – the path c: / windows / my.ini – 2. Find Education skip-InnoDB and comment # before adding it 3. E ‘recommended increasing the max_allowed_packet value to make sure you can [...]
Tech Guild This is some other ways to improve performance of you famous Database MySQL Tuner
Twitter
Facebook