ThinkPart http://hristov.com/oblog/ Andrey's blog Thu, 18 Mar 2010 22:07:45 +0200

A PHP Error was encountered

Severity: Notice

Message: Undefined index: language

Filename: feed/rss_posts.php

Line Number: 14

 http://blogs.law.harvard.edu/tech/rss Copyright 2010 My NAS - QNAP TS 119 Turbo NAS http://hristov.com/oblog/blog/post/2010/03/07/my-nas-qnap-ts-119-turbo-nas/ http://hristov.com/oblog/blog/post/2010/03/07/my-nas-qnap-ts-119-turbo-nas/ Few weeks ago I got new hardware for my home network, a QNAP TS 119 Turbo NAS.

]]> Sun, 07 Mar 2010 00:00:00 +0200 mysqlnd and the compressed protocol, again http://hristov.com/oblog/blog/post/2009/09/07/mysqlnd-and-the-compressed-protocol-again/ http://hristov.com/oblog/blog/post/2009/09/07/mysqlnd-and-the-compressed-protocol-again/ mysqlnd patched for compressed protocol passes almost all tests, but all of the most relevant and those who test with big result sets. I have a few failures due to "Packet out of order" which is due to the crippled packet numbering when com...pressed is turned on-the outter layer has different counter than the inner, compressed one, and it is unknown how the server resets them (for example in the COM_CHANGE_USER tests).

 

]]> Mon, 07 Sep 2009 00:00:00 +0300 The MySQL compressed protocol http://hristov.com/oblog/blog/post/2009/09/04/the-mysql-compressed-protocol/ http://hristov.com/oblog/blog/post/2009/09/04/the-mysql-compressed-protocol/ MySQL's compressed protocol is not so widely used, but there are still users that use it. Thus, the need to implement it in mysqlnd.

Unfortunately the compressed protocol is full of landmines, a lot of them, exploding one by one.

]]> Fri, 04 Sep 2009 00:00:00 +0300 Compressed protocol for mysqlnd http://hristov.com/oblog/blog/post/2009/09/03/compressed-protocol-for-mysqlnd/ http://hristov.com/oblog/blog/post/2009/09/03/compressed-protocol-for-mysqlnd/ Compressed protocol support for mysqlnd has ready alpha patch. Tested with simple queries, not tested against the test suite or big packets.

]]> Thu, 03 Sep 2009 00:00:00 +0300 100 000 queries per second against MySQL http://hristov.com/oblog/blog/post/2009/06/05/100-000-queries-per-second-against-mysql/ http://hristov.com/oblog/blog/post/2009/06/05/100-000-queries-per-second-against-mysql/ No! There is no error in the topic. You can see yourself:

]]> Fri, 05 Jun 2009 00:00:00 +0300 Where is the problem in the following code? http://hristov.com/oblog/blog/post/2009/05/29/where-is-the-problem-in-the-following-code/ http://hristov.com/oblog/blog/post/2009/05/29/where-is-the-problem-in-the-following-code/ #define MYSQLND_INC_GLOBAL_STATISTIC(statistic) \ { \ if (MYSQLND_G(collect_statistics) && statistic != STAT_LAST) { \ mysqlnd_global_stats->values[statistic]++; \ } \ }

I usually don't make this mistake, but in this particular case I did. Can you spot it?

]]> Fri, 29 May 2009 00:00:00 +0300 Query caching in PHP/mysqlnd - Reloaded http://hristov.com/oblog/blog/post/2009/04/26/query-caching-in-phpmysqlnd-reloaded/ http://hristov.com/oblog/blog/post/2009/04/26/query-caching-in-phpmysqlnd-reloaded/ The MySQL UC 2009 is over and I got bored in the evening before I had to leave Santa Clara and decided to play again with query caching in mysqlnd. I have always said that mysqlnd is ready for it, the infrastructure is there and that we need just few changes to make it work. Well, I decided to bite the bullet and do it. Spent about 4h in the evening and on the next day 2h while waiting on the San Jose (SJC) airport and continued on the flight to Denver, where I am having vacation. On the plane I was almost ready and today I made the final changes to the preliminary patch, that seems to work :)

I did a small benchmark, a microbenchmark.

]]> Sun, 26 Apr 2009 00:00:00 +0300 mysqlnd talk this afternoon http://hristov.com/oblog/blog/post/2009/04/22/mysqlnd-talk-this-afternoon/ http://hristov.com/oblog/blog/post/2009/04/22/mysqlnd-talk-this-afternoon/ In a few hours I will give my talk on mysqlnd. Well, the talk is not mine but we wrote it together with Ulf Wendel, of the MySQL Connectors Team fame. Although we haven't added much functionality to mysqlnd in the recent months mysqlnd is still pretty advanced and started to mature. I will talk about why mysqlnd is unique, why is it cool, why is it fast, and why you should use it!

]]> Wed, 22 Apr 2009 00:00:00 +0300 Connector/C++ talk already in the history http://hristov.com/oblog/blog/post/2009/04/22/connectorc-talk-already-in-the-history/ http://hristov.com/oblog/blog/post/2009/04/22/connectorc-talk-already-in-the-history/ Yesterday I gave my talk, in front of not that many people, about Connector/C++ at the MySQL UC 2009. Not too many questions came from the public, but this is a new product which very specific target group. You know, almost nobody writes Web applications in C++. And Java is the server language for the Enterprise. So I should have expected not many people in the room.

If you have missed the talk, don't worry. In May there will be a webinar which you can attend and if you miss it, you can just watch it at later time. The webinars are recorded and offered freely.

Yesterday the Connector/C++ got the GA stamp and we officially support it. Although we are going to make changes, mostly backward compatible, because this GA, 1.0.5, added the basic functionality the people need to use MySQL with C++ without using the weird libmysql API, which makes your life hard, if you don't use boost and start to get exceptions - you are gonna leak big time.

]]> Wed, 22 Apr 2009 00:00:00 +0300 Connector/C++ @ MySQL UC 2009 http://hristov.com/oblog/blog/post/2009/04/15/connectorc-mysql-uc-2009/ http://hristov.com/oblog/blog/post/2009/04/15/connectorc-mysql-uc-2009/ I will give a talk about Connector/C++ (and mysqlnd in another slot) next week at the MySQL UC 2009. We had to fit the presentation in about 20 slides to be able to fit in the small timeframe of 45 mins. So far I have given only presentations of about 90 minutes, incl. the shoot me with your questions part. I rehearsed today, both talks. Everything seems fine and I will fit. So, if you are an ISV that uses MySQL and use C++ come to see my presentation, there is something to learn. If you are open source developer, who uses C++, come to the room and allow me to introduce MySQL Connector/C++ to you. I am sure you will never get back to libmysql and MySQL Connector/C Wink

]]> Wed, 15 Apr 2009 00:00:00 +0300