… my complete answers: Q: Can you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, it… rule, because there are different types of subqueries (correlated, non-correlated, derived tables, scalar subqueries) and we saw in my presentation that…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…linux-glibc2. | | MAX_ALLOWED_PACKET | 1048576 | 4194304 | | JOIN_BUFFER_SIZE | 131072 | 262144 | | TMPDIR | /mnt/data…_files_limit is 5000 by default now vs 1024. innodb_auto_extend_increment is now…=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
…. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show… example it happens with many types of subqueries, cases when hash or sort merge join is needed and in many other advanced… everything, for example if I would do benchmarked of MySQL vs PostgreSQL and try my best to get best performance out…
