Sfrgttk

Check which numbers satisfy the condition [A*B*C = A! + B! + C!]

Extract all GPU name, model and GPU ram

How do pianists reach extremely loud dynamics?

Seeking colloquialism for “just because”

Book where humans were engineered with genes from animal species to survive hostile planets

At the end of Thor: Ragnarok why don't the Asgardians turn and head for the Bifrost as per their original plan?

Should I discuss the type of campaign with my players?

2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?

What is a non-alternating simple group with big order, but relatively few conjugacy classes?

Sci-Fi book where patients in a coma ward all live in a subconscious world linked together

Why was the term "discrete" used in discrete logarithm?

Storing hydrofluoric acid before the invention of plastics

Echoing a tail command produces unexpected output?

Why didn't this character "real die" when they blew their stack out in Altered Carbon?

Why is my conclusion inconsistent with the van't Hoff equation?

In predicate logic, does existential quantification (∃) include universal quantification (∀), i.e. can 'some' imply 'all'?

Why is "Consequences inflicted." not a sentence?

How to react to hostile behavior from a senior developer?

Do I really need recursive chmod to restrict access to a folder?

Generate an RGB colour grid

How widely used is the term Treppenwitz? Is it something that most Germans know?

Why did the IBM 650 use bi-quinary?

Using audio cues to encourage good posture

Output the ŋarâþ crîþ alphabet song without using (m)any letters

Why do information_schema queries scan all databases?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I'm building a PHP application that looks up the last modified date of all databases like this:

$sql = "SELECT MAX(update_time) FROM information_schema.tables WHERE TABLE_SCHEMA LIKE '" . $row["Name"] . "'";

I have about 300 databases and this loop takes about 7 seconds, so I want to speed this up. I noticed with Explain that any query on information_schema scans all databases, so I'm guessing this is why it's slow. Is there any way to fix this? I've upgraded to the latest MariaDB 10.3.14. This was a bug fixed in MySQL 8.0 so maybe MariaDB hasn't merged that yet? https://bugs.mysql.com/bug.php?id=81347

MariaDB [(none)]> EXPLAIN SELECT update_time FROM information_schema.tablesG

*************************** 1. row ***************************

           id: 1

  select_type: SIMPLE

        table: tables

         type: ALL

possible_keys: NULL

          key: NULL

      key_len: NULL

          ref: NULL

         rows: NULL

        Extra: Open_full_table; Scanned all databases

1 row in set (0.000 sec)

mariadb information-schema

share

asked 5 mins ago

Elliott BElliott B

1085

add a comment | 

0

I'm building a PHP application that looks up the last modified date of all databases like this:

$sql = "SELECT MAX(update_time) FROM information_schema.tables WHERE TABLE_SCHEMA LIKE '" . $row["Name"] . "'";

I have about 300 databases and this loop takes about 7 seconds, so I want to speed this up. I noticed with Explain that any query on information_schema scans all databases, so I'm guessing this is why it's slow. Is there any way to fix this? I've upgraded to the latest MariaDB 10.3.14. This was a bug fixed in MySQL 8.0 so maybe MariaDB hasn't merged that yet? https://bugs.mysql.com/bug.php?id=81347

MariaDB [(none)]> EXPLAIN SELECT update_time FROM information_schema.tablesG

*************************** 1. row ***************************

           id: 1

  select_type: SIMPLE

        table: tables

         type: ALL

possible_keys: NULL

          key: NULL

      key_len: NULL

          ref: NULL

         rows: NULL

        Extra: Open_full_table; Scanned all databases

1 row in set (0.000 sec)

mariadb information-schema

share

asked 5 mins ago

Elliott BElliott B

1085

add a comment | 

I'm building a PHP application that looks up the last modified date of all databases like this:

$sql = "SELECT MAX(update_time) FROM information_schema.tables WHERE TABLE_SCHEMA LIKE '" . $row["Name"] . "'";

I have about 300 databases and this loop takes about 7 seconds, so I want to speed this up. I noticed with Explain that any query on information_schema scans all databases, so I'm guessing this is why it's slow. Is there any way to fix this? I've upgraded to the latest MariaDB 10.3.14. This was a bug fixed in MySQL 8.0 so maybe MariaDB hasn't merged that yet? https://bugs.mysql.com/bug.php?id=81347

MariaDB [(none)]> EXPLAIN SELECT update_time FROM information_schema.tablesG

*************************** 1. row ***************************

           id: 1

  select_type: SIMPLE

        table: tables

         type: ALL

possible_keys: NULL

          key: NULL

      key_len: NULL

          ref: NULL

         rows: NULL

        Extra: Open_full_table; Scanned all databases

1 row in set (0.000 sec)

mariadb information-schema

share

asked 5 mins ago

Elliott BElliott B

1085

$sql = "SELECT MAX(update_time) FROM information_schema.tables WHERE TABLE_SCHEMA LIKE '" . $row["Name"] . "'";

MariaDB [(none)]> EXPLAIN SELECT update_time FROM information_schema.tablesG

*************************** 1. row ***************************

           id: 1

  select_type: SIMPLE

        table: tables

         type: ALL

possible_keys: NULL

          key: NULL

      key_len: NULL

          ref: NULL

         rows: NULL

        Extra: Open_full_table; Scanned all databases

1 row in set (0.000 sec)

share

asked 5 mins ago

Elliott BElliott B

1085

share

asked 5 mins ago

Elliott BElliott B

1085

asked 5 mins ago

Elliott BElliott B

1085

asked 5 mins ago

Elliott BElliott B

1085