By Sumit Gupta on April 25, 2011
Just saw the release note of MySql 5.5. Looks exciting upgrade, but what looks most funny about the software is the fact that they claim to improve performance by 1500% on windows [some 372% on linux]. Looks great work by them. But I found this information funny, as my some Open source lover friends always [...]
Posted in Joyous, MySQL, Operating System | Tagged Mysql, Open source, Windows |
By Sumit Gupta on December 13, 2010
Today, I face a new problem with MySQL. I got the database to crash quite a few times since morning. Event logs shows that there is a fault in mysqld.exe, but that error was not very clear on specific reason of fault. After searching for articles and forums, I got a hint that in past [...]
Posted in MySQL, Server Configuration | Tagged crash, Mysql, Upgrade |
By Sumit Gupta on March 10, 2010
I was looking at MySQL.com and found a new GUI, which came as replacement of old MYSQL administrative GUI. My impression was not good to learn that they have something new, as I thought it might be just that they get their old interface opensourced or something. But when I install this application, hmm .. [...]
Posted in Database, MySQL | Tagged GUI, Mysql, SQL, WorkBench |
By Sumit Gupta on July 4, 2008
A useful like to know the reason of “Server has gone away” error of MySQL. http://blog.taragana.com/index.php/archive/mysql-tip-mysql-server-has-gone-away-or-lost-connection-to-server-during-query-fix/ It has very good information on why it happens, so you can check and correct the error.
Posted in Server Configuration, SQL | Tagged Database, Mysql, SQL |
By Sumit Gupta on April 16, 2008
As title says, I was looking to compare User give date range with date range saved in mysql Database. I search internet and found a great small function that solve this problem for me, though they create a function for some programming language but I use same function in mysql (as per mysql syntax) and [...]
Posted in Links, Programming, SQL | Tagged date collision, Date range, Intersection of dates, Mysql |
Recent Comments