[phpMyAdmin Developers] MySQL 5.7 Features

Madhura Jayaratne madhura.cj at gmail.com
Thu Sep 3 13:26:18 CEST 2015


On Thu, Aug 27, 2015 at 3:18 AM, Morgan Tocker <morgan.tocker at oracle.com>
wrote:

> Hi phpmyadmin developers,
>
> I just downloaded 4.5.0-beta1.  I love that you are using the ALTER USER
> command from 5.7!
>
> I have some specific 5.7 features to mention that you may be able to make
> use of:
>
> 1) The server now supports a list of disabled_storage_engines (these still
> “work” but no new tables can be created).
> It might make sense to remove them from the drop-down-list or make them
> appear greyed out.
> They also appear under “ENGINES” the same as others currently.
>

https://github.com/phpmyadmin/phpmyadmin/issues/11456

>
> 2) The STATUS > PROCESSLIST is currently using SHOW PROCESSLIST.  In MySQL
> 5.7, there will be SELECT * FROM sys.x$processlist or SELECT * FROM
> sys.x$sessions (user connections only).  This has some added context
> (transactions open,  memory usage etc) and the command itself uses fewer
> locks than SHOW PROCESSLIST.  Here is an example of output:
>
>
> https://github.com/MarkLeith/mysql-sys/blob/development/views/p_s/sessions.sql
>
> 3) The datatype JSON does not appear to be added yet.  5.7.8 added this
> native type with ~20 JSON manipulation functions.
>
> - Morgan
>
>
>
> --
> Morgan Tocker
> MySQL Community Manager
> Oracle Canada - Hardware and Software, Engineered to Work Together.
> Office: Toronto, Canada
>
>
> _______________________________________________
> Developers mailing list
> Developers at phpmyadmin.net
> https://lists.phpmyadmin.net/mailman/listinfo/developers
>



-- 
Thanks and Regards,

Madhura Jayaratne
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.phpmyadmin.net/pipermail/developers/attachments/20150903/21b3ef4a/attachment.html>


More information about the Developers mailing list