May 23, 2012

Post: Testing Fusion-io ioDrive2 Duo

… be challenge for some servers: some models may not have connector for external power, and for some you may need special…

Comment: mysql-proxy, urgh performance and scalability ?

Look also at Tungsten Enterprise from Continuent. Its Connector has strong failover and query routing capabilities. I do not …

Post: Upcoming webinar on Hibernate and Connector/J

… be giving a webinar about performance implications for Hibernate and Connector/J. If you cannot attend at this time, a recorded… a MySQL backend, and also some more broad implications for Connector/J that will apply for anyone using MySQL from Java… * Lazyness * Manually written SQL * Concurrency * Concurrency-related config options for Connector/J You may register here.

Comment: Logging MySQL queries from the client instead of the server

I suppose you could also use MySQL Proxy to do the logging. This is like how MySQL Enterprise does the query capturing for the Query Analyzer. The Query Analyzer also uses hooks in the JDBC connector for an interceptor plugin, so you could also write a plugin for Connector/J.

Comment: mysql-proxy, urgh performance and scalability ?

Hi Vadim, Try Tungsten Connector. (http://www.continuent.com/community/tungsten-connector) It’s written in Java and schedules threads efficiently across…

Comment: Alternatives of PHP ?

… them pretty for my taste. – Too much standardization. For example Connector/J has to be JDBC complaint which means it has… can take a look at any stack trace posted for Connector/J bugs… it is rarely less than 20 levels. – Too…

Comment: Alternatives of PHP ?

you’re right, python’s connector does not support server-side prepared statements yet. neither does the pure ruby connector (ruby/mysql), but the one built on top of libmysql (mysql/ruby) does. jim

Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December

… Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when they set up connection. Sphinx…

Post: Logging MySQL queries from the client instead of the server

… superfluous ‘ping’ commands. Another option is to make the client connector log the queries. For example, if you are using PHP…

Comment: Is your server's performance about to degrade?

… such as with NDB or replication setups that flaky Ethernet connectors or bad wiring can also cause non-deterministic lag. Definitely…