← Back to team overview

maria-developers team mailing list archive

Re: MDEV-6714: A couple of questions


 I think:

1) case sensivity of tables and databases should always respect the setting
of lower_case_table_names variable (
Compromissing here in order to achive speed in completely unacceptable IMO.
and 2) triiggers are always case sensitive on case sensitive file systems
and non-sensitive on non-case-sensitive file systems. There is no setting
for this (and the lower_case_table_names variable does not control it
3) "I suppose it is safe to assume we will have these tables available when
running mysqldump". As safe any backup of any object.  A user can only
'mysqldump' objects he has privileges to access.

-- Peter
-- Webyog

On Mon, Mar 16, 2015 at 9:21 PM, Vicențiu Ciorbaru <vicentiu@xxxxxxxxxxx>

> Hi Sergei,
> I've achieved the desired performance speedup related to MDEV-6714. You
> can check the preliminary patch on the commits mailing-list. I'll clean up
> the code and then submit a final version for review. I do however have two
> concerns:
> * By using SHOW TABLES LIKE %s, we performed a case insensitive search to
> find the table's correct name case. This command takes a long time with a
> lot of tables. Using an equality operator in I_D speeds it up, but it no
> longer matches if we have a different case.
> Possible solution: Try to search for the table with the provided string
> via INFORMATION_SCHEMA using the equals operator. If we can not find the
> table, fall back to a case insensitive search that takes longer.
> * The I_S.triggers and I_S.tables are available since 5.5 and 5.1
> respectively. I suppose it is safe to assume we will have these tables
> available when running mysqldump. I can code all the changes to fall back
> to the previous query if the one that uses I_S tables fails.
> Regards,
> Vicentiu
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp

Follow ups