Skip to Content.
Sympa Menu

grouper-users - [grouper-users] MySQL storage engine

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] MySQL storage engine


Chronological Thread 
  • From: "Wessel, Keith" <>
  • To: " Mailing List" <>
  • Subject: [grouper-users] MySQL storage engine
  • Date: Tue, 13 Feb 2018 21:35:33 +0000
  • Accept-language: en-US
  • Ironport-phdr: 9a23://CDdBJvoDKfUfWUOdmcpTZWNBhigK39O0sv0rFitYgeIv/xwZ3uMQTl6Ol3ixeRBMOHs6sC07KempujcFRI2YyGvnEGfc4EfD4+ouJSoTYdBtWYA1bwNv/gYn9yNs1DUFh44yPzahANS47xaFLIv3K98yMZFAnhOgppPOT1HZPZg9iq2+yo9JDffxhEiCChbb9uMR67sRjfus4KjIV4N60/0AHJonxGe+RXwWNnO1eelAvi68mz4ZBu7T1et+ou+MBcX6r6eb84TaFDAzQ9L281/szrugLdQgaJ+3ART38ZkhtMAwjC8RH6QpL8uTb0u+ZhxCWXO9D9QLYpUjqg8qhrUgflhicZOTAk7GHZhM9+jKNHrxyuqBNy2JLUYJiJOPZiYq/RYc0WSGxcVchRTSxBBYa8YpMBA+UBI+lYtJL9qEUKrRemGAKiAf3gyj5Uhn/206ExzuMsEQLI3QM+BNIOq2rbrNHuOacTVeC1yKjIzTPEb/NXwjfx8pbHfQ08ofyVW797bMnfyVE3Gg/bklmdppbpMjeb2+gXrWSX9eptWfquhmMosQ19vCajyt0xhoTKmo4Z0E3I+CV3zYotK923Vk12bcKhHZZVqS6VK4h7T8EnTmxntiY3yaYJtJumcyUO1pso3RvSZOaZfISU4B/uUvuaLy1ii3J/Yr2/gg6/8Ui+xe34Ucm5yExKoTRBktbWtnENzAXf5dKISvRj+EehxSqD2x7J5uFYP087iarbK4U/zb4qiJoTsFjMETHtmEnsja+WckEk+umu6+TgY7XmvYWQOJFphQHjKqgum8q/DvokMgUWQWSX5eux2Kfn8ED3WrlGkOc6n6nBvJDfP8sbp6q5AwFP0oYk7hayFzSm0doGknkcN1JKZhaHgpPoO1HKJPD4DPG/g1OtkDdw3fzJIKDuAojVInjZjLjhZap961JbyAcrwtBf/ZVUCqwZIP3tQE/9rcHYDgQnPAyu2ObqE9F91oIFWWKTGa+VLrnesV6O5uIzPeaMfokVtyjhK/Q7/fLhk2I2mUJONZWuiNEYcnelBvl8ZliCbGD3qtYHDWoQuAciFqrnhEDKdDdSY3e0UOoY5yonQsryAp3EW5igmvmcxyqhBbVXYHxLEFaBDS2ueomZDaQiciWXd4VenycfWLzlA6ws1A2u/keuyKVqNfHZ/gUZsZbi0t90/KvemQxkpm88NNiUz2zYFzI8pWgPXTJjhK0=

All,

Last week at a TIER face-to-face, Shilen told us that we needed to be doing
regular runs of table optimizations on our MySQL Grouper tables. This is easy
enough to do, but when you try to do an optimization on innodb tables, MySQL
informs you that optimize isn't supported and that it's using recreate +
analyze.

I'm pretty sure that innodb is the default storage engine in MySQL 5.7, and I
assume that's why the tables Grouper created use that storage engine.

Are others who are using MySQL using different storage engines for the
Grouper tables that support a direct optimize? I suspect we could optimize
faster if we were using a storage engine that didn't have to fall back on
recreate + analyze.

Keith




Archive powered by MHonArc 2.6.19.

Top of Page