by admin | Dec 6, 2018 | C# .Net, MySQL, Software
[:en]AutoMapper is not only a useful tool for mapping e.g. DB model classes to flatter ViewModels, it can also simplify and optimize SQL queries / expressions generated by LINQ. You can get it via NuGet for any .NET framework type. Example Let’s suppose we have...
by admin | Apr 29, 2017 | Administration, Linux, MySQL
[:en] Upgrading Ubuntu from v14 to 16 LTS can lead to MySQL server issues (MySQL is upgraded from v5.6 to 5.7 during the upgrade process). E.g. if you use deprecated variables in /etc/mysql/my.cnf, MySQL server will fail to start after the upgrade is finished....
by admin | Jul 12, 2016 | ASP.Net, C# .Net, MySQL
[:en]Databases like MySQL do not allow any special characters in table column names, so most developers use camelcase or underscores. To make it readable for the end user in your software, you often have to manually type a friendly description. As there is no way to...
by admin | Jun 22, 2016 | MySQL
[:en]Open your MySQL client or phpMyAdmin etc. Execute query: select concat(‘KILL ‘,id,’;’) from information_schema.processlist where user=’yourUser’ Copy the result lines and execute them, it should look like: kill 12345; kill...
by admin | Jan 19, 2016 | Administration, Linux, MySQL
Log in to MySQL via console: mysql -u root -p Run: SET global log_output = ‘table’; SET global general_log = 1; View table mysql.general_log e.g. with phpMyAdmin or command: select * from mysql.general_log Do not forget to disable logging again: SET global...
by admin | Nov 4, 2015 | MySQL
Problem An SQL query containing multiple table joins, functions etc. is too slow, but necessary. Solution approaches Indexes created on single or multiple MySQL table columns can increase performance in a significant way if they are used correctly. First, have a look...
