1.
~jk MySQL Proxy: Query Stats
MySQL Proxy: Query Stats. The idea is simple and already implemented in mysqldumpslow : /* login.php:37 */SELECT * FROM tbl WHERE id = 1243 AND name = "jan" ...
2.
~jk Analyzing complex queries
Analyzing complex queries. I picked a query from the ORDER BY RAND article as they .... MySQL Proxy: Tracking Parallel Queries · MySQL Proxy: 0.6.0 released ...
3.
~jk ORDER BY RAND()
The row_id is now free of holes again and we can run our random query again: .... As you can see the plain ORDER BY RAND() is already behind the optimized query at ... MySQL Proxy and a Global Transaction ID · MySQL Proxy: Query Stats ...
4.
~jk MySQL Proxy
Load Balancing isn't implemented yet, but will allow to all applications to utilize a connection pool which is maintained by the mysql-proxy. ...
5.
~jk MySQL Proxy
Load Balancing isn't implemented yet, but will allow to all applications to utilize a connection pool which is maintained by the mysql-proxy. ...
6.
~jk MySQL Proxy: Adaptive Slow Query Log
Sep 14, 2007 ... MySQL Proxy: Adaptive Slow Query Log. First we want to find the average query time over all queries and they standard deviation: ...
7.
~jk MySQL Proxy: Query Stats
As side-effect of this query-stats I started to write some lua-libraries which will make handling the packets a lot easier. But that's for another article. ...
8.
~jk pxtools
The pxtools are a set of tools to convert a Paradox-database into a SQL-database (MySQL, PostgreSQL), CSV or XML. It is written from scratch and has no ...
9.
~jk ORDER BY RAND()
And we read the rows according to the index ( ORDER BY id ASC ). .... MySQL Proxy: debug plugin · MySQL Proxy: what should be on the road-map · MySQL Proxy: ...
10.
~jk MySQL Proxy learns R/W Splitting
August 1st, 2007. The trunk version of the MySQL Proxy 0.6.0 just learnt about ... The whole connect_servers() function is only to create new connections for all pools. .... It keeps your site up and running even if your master is gone. ...
