Contents tagged with MySQL
today I want to describe how to point to non standard port in My SQL for Acumatica.
Below goes fragment from my Web.config
<remove name="ProjectX" />
<add name="ProjectX" providerName="System.Data.SqlClient" connectionString="Server=localhost;Port=4040;Database=PXProjectionMySql2;Uid
you can use this knowledge for having multiple MySQL instances on the same machine and for catching generated SQL queries. more
quick post on how to install MySQL proxy. You may be puzzled why it is needed? Because MySQL proxy allows you to track all generated SQL by MySQL. As of now, you can catch generated SQL for SQL server with SQL Server Request Profiler. But in order to achieve it for MySQL, you'll need to use MySQL proxy.
So, first step will be download MySQL proxy archive and unzip it to some folder on your drive.
Then in command prompt ( not in powershell ) execute something like this:
sc create "Proxy" DisplayName="MySQL Proxy" start="auto" binPath="d:\Install\mysql-proxy-0.8.5-windows-x86-32bit\bin\mysql-proxy-svc.exe"
And then this:
net start proxy
Those two commands will allow … more
today I want to write a few words about performance difference between MySQL and MS SQL in Acumatica.
Relatively recently Acumatica provided possibility to use MySQL as it's database. For some unknown reason
I didn't notice anybody who decided to use MySQL as their database solution. If you know any, please let me know,
how they like their experience.
For me as developer it become interesting to check performance of MySQL vs MS SQL. Especially from standpoint of servers.
Take note on how one of mine task managers look like:
as you can see I have 40 logical cores or 20 physical cores. Try to guess what is price of license for MS SQL for using at such a computer? … more