Showing entries 1 to 4
Displaying posts with tag: union all (reset)
Jan
17
2015
MariaDB 10.1.2 Overview and Highlights
Posted by Chris Calender on Sat 17 Jan 2015 17:03 UTC
Tags:
webscale, xtradb, mariadb, union all, MySQL, mariadb changelogs, mariadb downloads, MariaDB 10.1, webscalesql, ANALYZE statement, atomic writes, download mariadb 10.1, download MariaDB 10.1.0, Force PK option, FusionIO and MySQL MariaDB, mariadb 10.1 alpha, mariadb 10.1 download, GET_LOCK(), compound statements, CLIENT_STATISTICS, default roles, defrag innodb, defrag innodb tablespace, defragment innodb, defragment innodb tablespace, engine_condition_pushdown optimizer_switch flag, FLUSH QUERY_RESPONSE_TIME, Kakao patch, out parameters, SHOW LOCALES, SHOW QUERY_RESPONSE_TIME, Statements that exceed a certain execution time, triggers can be run on slave, USER_STATISTICS, Boundary, ConvexHull, CrackLib, cracklib_password_check password, domain_id based replication filters, EXPLAIN FORMAT=JSON, innodb_log_compressed_pages, Innodb_secondary_index_triggered_cluster_reads, Innodb_secondary_index_triggered_cluster_reads_avoided, IsRing, MariaDB 10.1.2, number of rows affected by a slow UPDATE or DELETE is now recorded, Out parameters in PREPARE, Password validation plugin API, Per-query variables, PointOnSurface, query_alloc_block_size, query_prealloc_size, Scalability fixes, simple_password_check password, Spatial Reference systems for the GIS data, ST_Boundary, ST_ConvexHull, ST_IsRing, ST_PointOnSurface, ST_Relate, Webscale patches, WSREP_MEMBERSHIP, WSREP_STATUS

MariaDB 10.1.2 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.1.2/

This is the third alpha release of MariaDB 10.1, so there are still a lot of new changes, functionalities added, defaults changed, and many bugs fixed (I counted 117, which is *way* down from the 637 fixed in 10.1.1). Since it’s alpha, I’ll only cover the major changes and additions, and omit covering general bug fixes (feel free to browse them all here).

To me, these are the highlights of the new features:

[Read more]
Oct
25
2014
MariaDB 10.1.1 Overview and Highlights
Posted by Chris Calender on Sat 25 Oct 2014 13:15 UTC
Tags:

MariaDB 10.1.1 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.1.1/

This is the second alpha release of MariaDB 10.1, so there are a lot of new changes and functionalities added, and many, many bugs fixed (I counted 637). Since it’s alpha, I’ll only cover the major changes and additions, as there are a lot of great new features, and omit covering any of the bug fixes (feel free to browse them all here).

To me, these are the highlights of the new features:

  • InnoDB: You can now use OPTIMIZE TABLE to defragment InnoDB tablespaces (merged the Facebook/Kakao defragmentation patch). (Good blog post …
[Read more]
Jun
13
2013
How to Optimize MySQL UNION For High Speed
Posted by Sean Hull on Thu 13 Jun 2013 20:08 UTC
Tags:

Join 6100 others and follow Sean Hull on twitter @hullsean. There are two ways to speedup UNIONs in a MySQL database. First use UNION ALL if at all possible, and second try to push down your conditions. [mytweetlinks] 1. UNION ALL is much faster than UNION How does a UNION work? Imagine you have two [...]

Oct
07
2010
Optimizing the MySQL IN() Comparison Operations Which Include the Indexed Field
Posted by Ilan Hazan on Thu 07 Oct 2010 12:06 UTC
Tags:

The MySQL IN() Comparison Operator is said to be very quick if all the values are constants (the values are then evaluated and sorted first, and the search is done using a binary search). However, what if the field which the IN clause refers to, is part of the index used to execute the query? […]

Showing entries 1 to 4