Bug #25608 | CREATE DATABASE create_specification enhancement ... | ||
---|---|---|---|
Submitted: | 13 Jan 2007 14:32 | Modified: | 20 Feb 2007 10:57 |
Reporter: | [ name withheld ] | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server | Severity: | S4 (Feature request) |
Version: | all | OS: | Any (all) |
Assigned to: | CPU Architecture: | Any |
[13 Jan 2007 14:32]
[ name withheld ]
[20 Feb 2007 10:29]
Valeriy Kravchuk
Thank you for a feature request. Sorry, but I see no need to implement a feature like this when it is possible to use symbolic links (read http://dev.mysql.com/doc/refman/5.1/en/symbolic-links.html) and partitioning (read http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html and links from that page).
[20 Feb 2007 10:57]
[ name withheld ]
sorry, perhaps i did not explained myself correctly(I am french and my english is not so good) the feature is needed to solve a performance problem: when you have several thousands of databases with several thousands of symbolic links in the /var/lib/mysql directory, it takes a very very very long time to open phpmyadmin, due to the directory traversal and retrieval from symbolic links. if instead there was a table containing some kind of symbolic link, (database_ name => directory_location) the traversal would be immediate... I hope that this explanation is bette than the previous Best regards Pascal
[21 Feb 2007 11:07]
Valeriy Kravchuk
Now it's more clear. The problem is performance with a lot of databases when symbolic links are used. Maybe, phpmyadmin should just no try to access all the databases upon opening... Anyway, I think, partitioning in 5.1, with ability to store data and indexes for partitions of individual tables in separate directories, may be a valuable alternative solutions to symbolic links in this case. Please, check.