I sometimes really hate Windows. When you do obligatory updates sometimes it takes hours for operating system to settle down and stop using CPU and memory like crazy.
One of these processes are mscorsvw.exe and ngen.exe which do some .NET assemblies optimization. I read about a lot of angry posts about these processes and that it takes hours “to optimize” and during these hours your server and services on it are suffering (and you need to be clever when finding explanations to your clients).
Follow these steps:
Navigate to the following location in Windows Explorer: C:\Windows\Microsoft.NET\Framework\v4.0.30319
Run an elevated command prompt and change the current directory to the following directory
Type ngen.exe executequeueditems, and press ENTER
Wait until you receive the following message at the command prompt: All compilation targets are up to date.
This annoying processes stopped but now TiWorker.exe is taking his time and eating the CPU and Memory and it looks like it will take 3-4 hours. Yikes! I really hate Windows programmers for this hidden background CPU and Memory eaters.
If you have faced a problem when importing your data to MySQL from a large file and it said: ERROR 1118 (42000) at line xxx: Row size too large (> 8126)
This is a known bug for MySQL versions 22.214.171.124, 126.96.36.199 and I noticed that I didn’t have this problem at version 5.6.24.
In order to make it work also on MySQL 188.8.131.52 edit your “my.ini” configuration file and increase the innodb log size like this: innodb_log_file_size = 256M
Hope it solves you the problem, like it helped me, one beer is always welcomed :-).
You know at tinymce(1) field in MySQL database will be converted to boolean type in C#. Sometimes you don’t want this because you just want to read the integer value from MySQL in this field (it can be any from 0-255 if unsigned or -127-127 if signed) – one byte.
In order to do so you need to do two things:
Add TreatTinyAsBoolean=false to your connection string
Edit the database edmx file and in SSDL content section change bool to tinyint, and in CSDL content section change Boolean into SByte.
Be careful if you update edmx file because changes you have made will be lost. This is the bad thing about this, but it is working solution.