Re: [Maria-developers] GSoC weekly reports (Unique indexes for blobs)

2016-08-03 Thread Shubham Barai
GSoC (week 10) 1.solved the problem which was causing a crash for the optimized version. 2.modified some functions for renaming a column using alter table. 3.At first,the server crashed for queries like "select column_name from table_name " if the column was present in the hash index. The probl

Re: [Maria-developers] bdef42c: MDEV-10365 - Race condition in error handling of INSERT DELAYED

2016-08-03 Thread Sergei Golubchik
Hi, Sergey! On Aug 03, Sergey Vojtovich wrote: > revision-id: bdef42c54f8938d28d9a421271b11e09e88735a4 > (mariadb-5.5.50-19-gbdef42c) > parent(s): 45ec5d673a1f5c736baec8ea9e2065bca4350324 > committer: Sergey Vojtovich > timestamp: 2016-08-03 11:49:35 +0400 > message: > > MDEV-10365 - Race condit

Re: [Maria-developers] fc42991: MDEV-7901: re-implement analyze table for low impact

2016-08-03 Thread Oleksandr Byelkin
Hi, Sergei! On 03.08.2016 12:30, Sergei Golubchik wrote: Hi, Oleksandr! Looks mostly ok, see few comments below On Aug 01, Oleksandr Byelkin wrote: revision-id: fc42991720838e165ad448b6707602cded92faa4 (mariadb-10.2.1-9-gfc42991) parent(s): 08683a726773f8cdf16a4a3dfb3920e5f7842481 committer:

[Maria-developers] Please review MDEV-10468 Assertion `nr >= 0.0' failed in Item_sum_std::val_real()

2016-08-03 Thread Alexander Barkov
Hello Alexey, Can you please review a patch for MDEV-10468? Thanks! diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index ac076ec..ae16eb7 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -2270,3 +2270,15 @@ t2_id GROUP_CONCAT(IF (

Re: [Maria-developers] MariaDB memory usage when rebuilding a large table

2016-08-03 Thread Mark Wadham
On 3 Aug 2016, at 11:30, Mark Wadham wrote: Our test case is a 3-node galera cluster on which we want to alter a ~160GB table that has . Oops, that's 1347066922 rows. Mark ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria

Re: [Maria-developers] fc42991: MDEV-7901: re-implement analyze table for low impact

2016-08-03 Thread Sergei Golubchik
Hi, Oleksandr! Looks mostly ok, see few comments below On Aug 01, Oleksandr Byelkin wrote: > revision-id: fc42991720838e165ad448b6707602cded92faa4 > (mariadb-10.2.1-9-gfc42991) > parent(s): 08683a726773f8cdf16a4a3dfb3920e5f7842481 > committer: Oleksandr Byelkin > timestamp: 2016-08-01 19:25:45 +

[Maria-developers] MariaDB memory usage when rebuilding a large table

2016-08-03 Thread Mark Wadham
Hi, Apologies if this is the wrong place to ask this question but it seemed like the most apt. We are working on operational processes for online schema changes with MariaDB 10.1.16 and have encountered memory issues which are proving difficult to reliably solve. If anyone on this list cou

Re: [Maria-developers] 48d1ba6: MDEV-10296 - Multi-instance table cache

2016-08-03 Thread Sergey Vojtovich
Hi Sergei, On Tue, Aug 02, 2016 at 06:54:16PM +0200, Sergei Golubchik wrote: > Hi, Sergey! > > Ok, see comments below. > > But why is this supposed to improve scalability? > Are you talking about the use case of one table being access by multiple > threads? Or this helps in other cases too? Aim