lp:~maria-captains/maria/maria-5.2-merge-5.1

Branch merges

Propose for merging

No branches dependent on this one.

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

2735. By Oleksandr "Sanja" Byelkin on 2009-12-09

merge

2734. By Oleksandr "Sanja" Byelkin on 2009-12-09

auto-merge

2733. By Oleksandr "Sanja" Byelkin on 2009-12-08

merge 5.1-> 5.2

2732. By Igor Babaev on 2009-11-12

Merge of the patch introducing virtual columns into maria-5.2

2731. By Sergey Petrunia on 2009-11-04

MWL#36: Add a mysqlbinlog option to change the used database
- Merge to MariaDB 5.2

2730. By Michael Widenius on 2009-10-28

Merge with 5.1 (Faster test cases)

2729. By Michael Widenius on 2009-10-28

Automatic merge with 5.1

2728. By Michael Widenius on 2009-10-26

Updated test suite results with new information schemas

2727. By Michael Widenius on 2009-10-23

Fixed version number

2726. By Michael Widenius on 2009-10-19

This is based on the userstatv2 patch from Percona and OurDelta.
The original code comes, as far as I know, from Google (Mark Callaghan's team) with additional work from Percona, Ourdelta and Weldon Whipple.

This code provides the same functionallity, but with a lot of changes to make it faster and better fit the MariaDB infrastucture.

Added new status variables:
- Com_show_client_statistics, Com_show_index_statistics, Com_show_table_statistics, Com_show_user_statistics
- Access_denied_errors, Busy_time (clock time), Binlog_bytes_written, Cpu_time, Empty_queries, Rows_sent, Rows_read

Added new variable / startup option 'userstat' to control if user statistics should be enabled or not

Added my_getcputime(); Returns cpu time used by this thread.
New FLUSH commands:
- FLUSH SLOW QUERY LOG
- FLUSH TABLE_STATISTICS
- FLUSH INDEX_STATISTICS
- FLUSH USER_STATISTICS
- FLUSH CLIENT_STATISTICS

New SHOW commands:
- SHOW CLIENT_STATISTICS
- SHOW USER_STATISTICS
- SHOW TABLE_STATISTICS
- SHOW INDEX_STATISTICS

New Information schemas:
- CLIENT_STATISTICS
- USER_STATISTICS
- INDEX_STATISTICS
- TABLE_STATISTICS

Added support for all new flush commands to mysqladmin

Added handler::ha_... wrappers for all handler read calls to do statistics counting
- Changed all code to use new ha_... calls
- Count number of read rows, changed rows and rows read trough an index

Added counting of number of bytes sent to binary log (status variable Binlog_bytes_written)
Added counting of access denied errors (status variable Access_denied_erors)

Bugs fixed:
- Fixed bug in add_to_status() and add_diff_to_status() where longlong variables where threated as long
- CLOCK_GETTIME was not propely working on Linuxm