June 19, 2013

Comment: Percona Server 5.5.8 Beta Release

Why my comment got deleted don’t know. But i have tried to make Percona-server-server 5.5.8 pakage from source for my Ubuntu Lucid and the good thing is that this build is really fast as compared to original mysql5.5 build. But will wait for stable release from percona for our website server.

Comment: Percona Server 5.5.8 Beta Release

Why my comment got deleted don’t know. But i have tried to make Percona-server-server 5.5.8 pakage from source for my Ubuntu Lucid and the good thing is that this build is really fast as compared to original mysql5.5 build. But will wait for stable release from percona for our website server.

Comment: Impact of the number of idle connections in MySQL

… two 8-core Nehalem E5540 boxes, Gigabit Ethernet, CentOS5.5, MySQL5.1.latest), I didn’t find noticeable performance difference. What…

Comment: MySQL 5.5.4 in tpcc-like workload

I am still using MySQL5.0.x

Comment: Air traffic queries in InfiniDB: early alpha

… this is meaningful information for folks. subselects: Yes, you are correct, we currently do not support subselect. As Robin mentioned in a…

Post: Air traffic queries in InfiniDB: early alpha

…_vtable_mode). mysql> show warnings; +——-+——+————————————————————+ | Level | Code | Message | +——-+——+————————————————————+ | Error | 9999 | Subselect in From clause is not supported in this release…

Comment: 7 Reasons why MySQL Quality will never be the same

… Web applications. And the good development would be to have Subselects and prepared statements fixed for next release rather than adding… baked features. The manor features in MySQL 4.1 were Subselects, Prepared Statements and Character Sets. All they were not done…

Post: MySQL Optimizer team comments on TPC-H Results

… to be done first. Another reason is “Derived Tables” AKA “Subselects in FROM Clause” are not optimized yet even though some…

Comment: What to tune in MySQL Server after installation

Hi friends,iam using MySQL5.0. I have a database with 2mb size.There are more than 30 tables. In a query, iam using joins to retrieve records from db.which joins 10 tables.Iam using windows 2003 server with 1GB RAM.Please specify the optimum settings for this hardware.Data will be bulk.

Comment: MyISAM Scalability and Innodb, Falcon Benchmarks

… is the temp table workaround. Might be able to use subselects to avoid the huge data load as well. In my…