Greetings,
I don't know if i'm inside the good list to post my request, but i would
like that a developer add a new parameter inside the configuration. I
explain you my reason why this option could help me :
We have for the moment the option : $cfg['ShowCreateDb']
I have set false to this option inside my configuration because my users
don't have the privilege to create new database (they need to use my
panel admin instead).
But inside PhpMyAdmin, they can find inside the Operation page, a window
to rename a database. The option $cfg['ShowCreateDb'] don't apply to
this (and it's correct).
But as they don't have the right inside the privilege of MySQL to create
one, i would like hide this window too.
For the moment, i have modified the file : db_operations.php
with adding a // in front of
$response->addHTML(PMA_getHtmlForRenameDatabase($db));
But inside the function PMA_getHtmlForCopyDatabase($db) (inside
/libraries/operations.lib.php), they can create a database with the
checkbox called "checkbox_create_database_before_copying" and it's a
little more to hide it on my side ...
So, I would like have an option called $cfg['AllowCreateDb'] (true by
default) to hide their part automaticaly without editing the source code
:) I don't know if we have a way to create a database somewhere else
with PhpMyAdmin but it's a begining.
What do you think about it please ?
Someone could implement it more later ?
Thanks so much in advance,
Élodie
Hi,
While fixing some PHPCS issues, I found something strange here [1] (you
need to get the last master version).
As you can see, there is a mb_strpos !== true… but, this should always be
true… mb_strpos can't be strictly true, it could be false are an int.
It seems that this condition is here since the file is created (commit
7248bf87fad6f371943c7b26c3a597bc04265dc7 – from the log, I can imagine that
the code wasn't in a class before).
Did anyone already use this import please? Because I can't believe that the
returned value is not the initial $cell…
[1] libraries/plugins/import/ImportMediawiki.class.php:561 (method _getCell)
Thanks for your feedbacks,
Hugues.
Hi,
With current master (8785ea0) I made some tests on a MySQL 5.5.37 server
containing about 81000 databases and about 81000 users.
In the mysql.db tables there are about 81000 grant entries; each one
grants some wildcard access to databases starting with a certain pattern.
I tested with root, since the reports we got about the server being slow
seem to be occurring for root.
Good news
---------
First, the login. It takes about 7 seconds before seeing the initial
page after login.
In the navi panel, there is a db page selector with 107 page numbers.
Going to any page takes about 7 seconds. Opening a db takes about 4
second (each db seems to contain about 31 tables).
Browsing tables, grid editing, searching inside a table behave normally.
Using Server > Databases works correctly, including switching pages.
Problems
--------
Going to a MyISAM table, Structure, and trying to change a column's
structure takes 30 seconds before seeing the dialog for this column.
Switching this table to InnoDB does not help.
Database filter: I got mixed results. Sometimes it works (after about 10
seconds) but sometimes it stalls and does not find anything. I could not
find a consistent way to reproduce.
Server > Users: "Error in processing request. Error code: 500. Error
text: Internal server error".
--
Marc Delisle | phpMyAdmin