Posted in MySQL, SQL Server on February 23rd, 2009 4 Comments »
I found a lot of posts on the internet regarding how to set up a MSSQL link server to MySQL server. I didn’t find any of them gave a complete picture. So I wrote my own post and hope it can help.
The first thing need to do
when setting up a link server to […]
Posted in MySQL on January 24th, 2008 5 Comments »
Yesterday I needed to write an update statement
to update records in a table that met conditions defined with two other tables. I always thought the select, update, insert and delete syntax are universal regardless of database vendors. So I wrote the script. It was like the following
Update C
Set C.status=’Active’
From tableA A
Join tableB […]
Posted in MySQL on January 18th, 2008 4 Comments »
I believe one of the areas MySQL server need to improve when competing with other database software is that it needs to provide an easy way to release not used space of the innodb file. MS SQL server is far more superior in that regards.
In MySQL the default setting is to have only one […]
Posted in MySQL on January 17th, 2008 2 Comments »
I mentioned in my previous post that MySQL server has replication feature. It is a very useful feature but from time to time I experience problems with it.
One problem I experienced with MySQL replication was that it stopped by itself after replicating for a while. I could not re-start replication by running command “start […]
Posted in MySQL on January 8th, 2008 No Comments »
I mentioned in my previous post “MySQL Bugs” that I observed a bug in its NT version 5.0.41. The bug limited the number of concurrent connections to MySQL server to a very small number between 15 to 60 depending on innodb_buffer_pool_size. When you try to open additional connection to MySQL server you […]
