Schema Designer (Sqlyog 8.2)

[AGA Media]

Hi there,

the call upon of a schema in schema designer (SQLYog 8.2) takes several times longer (between 20 and 30 seconds) compared to 8.1x (the same schema of course).

Kind regards!

Joachim Bartels

AGA Media

Germany

[nithin]

Hello,

Can you explain the issue in detail?

You did 'Add tables' to canvas or Load a saved 'schema design' file?

It will be appreciated if you provide a test case.

Also tell Is it direct or HTTP/SSH connection.

Also tell MySQL Server version.

Thank you

Nithin

[peterlaursen]

There is/should be no difference with Schema Designer at all with any 8.x version. Are you sure that not something else happened at around the time you upgraded?

You should be aware that when you are loading a SCHEMAXML, SQLyog will connect to the server and verify that objects listed in the SCHEMAXML exist.

Best would be if you had both 8.1x and 8.2 installed at the same time and tried with both. Also you should be connected to the same server from same client machine.

[AGA Media]

Thank you both for your quick responses!

@nithin

Sorry, but I can not provide my schema.

The server is 5.1.34 community and runs on localhost (no changes here during the upgrade from SQLYog 8.1 -> 8.2).

The delay occurs after calling upon a saved schema file and answering the second dialog (i.e. during synchronization to the tables).

@peter

Did as requested a comparison between 8.18 and 8.2 (on Win Vista Ultimate SP 2)

In both cases: first reboot, then call upon schema from file:

8.18: 2-3 seconds until the dialogs appear, then another 3 seconds until the schema is painted in designer

8.2: 2-3 seconds until the dialogs appear, then another *90* seconds until the schema is painted in designer (the time after the answering of the second dialog is not always as long as 90 seconds, but often around 60 seconds). Hope this will help!

Kind regards and a merry X-mas!

Joachim Bartels

[peterlaursen]

OK .. we will have to try to reproduce that.  How many tables and FK's do you have in that design? What server version are you connected to?

[AGA Media]

'peterlaursen' wrote on '24:

OK .. we will have to try to reproduce that.  How many tables and FK's do you have in that design? What server version are you connected to?

There are about 50 tables in that specific design and the server is 5.1.34 community.

[peterlaursen]

Are you telling that this problem occurs with one specific layout (only) or are all layouts affected?

Also please tell the exact Windows version.

We cannot reproduce this and without a test case where this is reproducible it will be very hard to do progress. You cannot share that layout – even not in a private ticket?  

[nithin]

Quote:

The delay occurs after calling upon a saved schema file and answering the second dialog (i.e. during synchronization to the tables).

Can you confirm the 2nd dialog you mentioned is same as attached image?

[AGA Media]

'nithin' wrote on '28:

Can you confirm the 2nd dialog you mentioned is same as attached image?

Yes, that´s the one.

At the moment I´m a little bit confused – I called upon several schemas and today every one of them was called upon in under 5 seconds (just as I was used to with version 8.18). I´ll try to figure it out, and will be back with more information.

[AGA Media]

'peterlaursen' wrote on '28:

Are you telling that this problem occurs with one specific layout (only) or are all layouts affected?

Also please tell the exact Windows version.

We cannot reproduce this and without a test case where this is reproducible it will be very hard to do progress. You cannot share that layout – even not in a private ticket?  

The Windows version is Vista Ultimate German SP2 (please also cf. my answer to nithin).

[peterlaursen]

Quote:

I called upon several schemas and today every one of them was called upon in under 5 seconds (just as I was used to with version 8.18). I´ll try to figure it out, and will be back with more information.

With a large LAYOUT quite a lot of SHOW-statements will have to be processed by the server in order check that all objects refferred in the LAYOUT are stored on the server.  Irresponsiveness by SQLyog may simply indicate that it is waiting for the server to return results.

What you could do is to

1) Check query execution times in HISTORY once it has finished.  Any particular statement taking lots of time?

2) Enable the server general log and see when each statement was received (the general log logs information when statement is received – not when execution has finished).

[AGA Media]

'peterlaursen' wrote on '28:

What you could do is to

1) Check query execution times in HISTORY once it has finished.  Any particular statement taking lots of time?

Hello Peter,

did as requested – here comes the log file (HISTORY) – the call upon time was between 5 to 10 seconds this time. There are (to me) only two tables out of the normal range, but a quick check got no answers (two indexes as usual, two constraints – both tables are n:m-tables with just integer values and a timestamp) … don´t know why it took so long compared to the other ones. Will repeat this and report whether there might be some pattern.

/*[18:34:53][ 0 ms]*/ SHOW VARIABLES LIKE 'lower_case_table_names';

/*[18:34:53][ 0 ms]*/ SET NAMES 'utf8';

/*[18:34:53][ 0 ms]*/ SET sql_mode='';

/*[18:34:53][ 0 ms]*/ USE `daten`;

/*[18:35:06][ 32 ms]*/ SHOW FULL TABLES FROM `daten` WHERE table_type = 'BASE TABLE';

/*[18:35:06][ 0 ms]*/ USE `daten`;

/*[18:35:06][ 31 ms]*/ SHOW FULL TABLES FROM `daten` WHERE table_type = 'BASE TABLE';

/*[18:35:06][ 15 ms]*/ SHOW CREATE TABLE `daten`.`tabflaeche`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relanffla`;

/*[18:35:06][ 16 ms]*/ SHOW CREATE TABLE `daten`.`relanfimo`;

/*[18:35:06][ 63 ms]*/ SHOW CREATE TABLE `daten`.`sdanbindung`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdentfernung`;

/*[18:35:06][ 31 ms]*/ SHOW CREATE TABLE `daten`.`sdgebausweis`;

/*[18:35:06][ 31 ms]*/ SHOW CREATE TABLE `daten`.`sdversorgarten`;

/*[18:35:06][ 16 ms]*/ SHOW CREATE TABLE `daten`.`tabanfrage`;

/*[18:35:06][ 31 ms]*/ SHOW CREATE TABLE `daten`.`sdanfstatus`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabimmo`;

/*[18:35:06][ 16 ms]*/ SHOW CREATE TABLE `daten`.`tabanftelekom`;

/*[18:35:06][ 46 ms]*/ SHOW CREATE TABLE `daten`.`sdtelekom`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdentsorgarten`;

/*[18:35:06][ 16 ms]*/ SHOW CREATE TABLE `daten`.`tabanfentsorgung`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabanfverkehr`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabanfversorgung`;

/*[18:35:06][ 16 ms]*/ SHOW CREATE TABLE `daten`.`sdmesseinheiten`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdprostat`;

/*[18:35:06][ 15 ms]*/ SHOW CREATE TABLE `daten`.`relanftodo`;

/*[18:35:06][ 16 ms]*/ SHOW CREATE TABLE `daten`.`relkonanf`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relflapic`;

/*[18:35:06][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relimopic`;

/*[18:35:06][ 16 ms]*/ SHOW CREATE TABLE `daten`.`relgebfla`;

/*[18:35:08][2156 ms]*/ SHOW CREATE TABLE `daten`.`relflaadr`;

/*[18:35:10][1515 ms]*/ SHOW CREATE TABLE `daten`.`relimoadr`;

/*[18:35:10][ 32 ms]*/ SHOW CREATE TABLE `daten`.`relanfwv`;

/*[18:35:10][ 156 ms]*/ SHOW CREATE TABLE `daten`.`sdnutzungsarten`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdfshinweise`;

/*[18:35:10][ 281 ms]*/ SHOW CREATE TABLE `daten`.`sdflatyp`;

/*[18:35:10][ 15 ms]*/ SHOW CREATE TABLE `daten`.`sdlagekat`;

/*[18:35:10][ 16 ms]*/ SHOW CREATE TABLE `daten`.`tabflurstueck`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdgemarkungen`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdfluren`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdabstandsklassen`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabstarefpunkt`;

/*[18:35:10][ 16 ms]*/ SHOW CREATE TABLE `daten`.`relflaref`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdverfuegbarkeit`;

/*[18:35:10][ 15 ms]*/ SHOW CREATE TABLE `daten`.`tabflatelekom`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflaentsorgung`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflaversorgung`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relgebimo`;

/*[18:35:10][ 16 ms]*/ SHOW CREATE TABLE `daten`.`tabflaaltlast`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdaltlasten`;

/*[18:35:10][ 16 ms]*/ SHOW CREATE TABLE `daten`.`sdaltlaststat`;

/*[18:35:10][ 15 ms]*/ SHOW CREATE TABLE `daten`.`sdobjekttypen`;

/*[18:35:10][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdbauarten`;

/*[18:35:10][ 16 ms]*/ SHOW CREATE TABLE `daten`.`sdzustaende`;

/*[18:35:11][ 15 ms]*/ SHOW CREATE TABLE `daten`.`sddenkmalkat`;

/*[18:35:11][ 0 ms]*/ SHOW CREATE TABLE `daten`.`reluntma`;

/*[18:35:11][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relimoma`;

/*[18:35:11][ 32 ms]*/ SHOW CREATE TABLE `daten`.`relflama`;

/*[18:35:11][ 16 ms]*/ SHOW CREATE TABLE `daten`.`relanfdok`;

/*[18:35:11][ 16 ms]*/ SHOW CREATE TABLE `daten`.`tabstagebiet`;

/*[18:35:11][ 15 ms]*/ SHOW CREATE TABLE `daten`.`sdgebtypen`;

/*[18:35:11][ 78 ms]*/ SHOW CREATE TABLE `daten`.`tabflanutzung`;

/*[18:35:11][ 32 ms]*/ SHOW CREATE TABLE `daten`.`tabimoeinheit`;

/*[18:35:11][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdimoeinheiten`;

/*[18:35:11][ 46 ms]*/ SHOW CREATE TABLE `daten`.`sdbelegstat`;

/*[18:35:11][ 32 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabflaeche';

/*[18:35:11][ 47 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabflaeche`;

/*[18:35:11][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relanffla';

/*[18:35:11][ 16 ms]*/ SHOW FULL FIELDS FROM `daten`.`relanffla`;

/*[18:35:11][ 63 ms]*/ SHOW KEYS FROM `daten`.`relanffla`;

/*[18:35:11][ 16 ms]*/ SHOW KEYS FROM `daten`.`tabflaeche`;

/*[18:35:11][ 15 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relanfimo';

/*[18:35:11][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relanfimo`;

/*[18:35:11][ 15 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdanbindung';

/*[18:35:11][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdanbindung`;

/*[18:35:11][ 16 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdentfernung';

/*[18:35:11][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdentfernung`;

/*[18:35:11][ 16 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdgebausweis';

/*[18:35:11][ 31 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdgebausweis`;

/*[18:35:11][ 47 ms]*/ SHOW KEYS FROM `daten`.`sdgebausweis`;

/*[18:35:11][ 47 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdversorgarten';

/*[18:35:11][ 15 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdversorgarten`;

/*[18:35:11][ 47 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabanfrage';

/*[18:35:11][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabanfrage`;

/*[18:35:11][ 16 ms]*/ SHOW KEYS FROM `daten`.`tabanfrage`;

/*[18:35:11][ 0 ms]*/ SHOW KEYS FROM `daten`.`relanfimo`;

/*[18:35:11][ 15 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdanfstatus';

/*[18:35:11][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdanfstatus`;

/*[18:35:11][ 16 ms]*/ SHOW KEYS FROM `daten`.`sdanfstatus`;

/*[18:35:11][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabimmo';

/*[18:35:11][ 31 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabimmo`;

/*[18:35:11][ 15 ms]*/ SHOW KEYS FROM `daten`.`tabimmo`;

/*[18:35:11][ 16 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabanftelekom';

/*[18:35:12][ 15 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabanftelekom`;

/*[18:35:12][ 31 ms]*/ SHOW KEYS FROM `daten`.`tabanftelekom`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdtelekom';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdtelekom`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdtelekom`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdentsorgarten';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdentsorgarten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabanfentsorgung';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabanfentsorgung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabanfentsorgung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdentsorgarten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabanfverkehr';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabanfverkehr`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabanfverkehr`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdanbindung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdentfernung`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabanfversorgung';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabanfversorgung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabanfversorgung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdversorgarten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdmesseinheiten';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdmesseinheiten`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdmesseinheiten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdprostat';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdprostat`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdprostat`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relanftodo';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relanftodo`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relanftodo`;

/*[18:35:12][ 15 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relkonanf';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relkonanf`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relkonanf`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relflapic';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relflapic`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relflapic`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relimopic';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relimopic`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relimopic`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relgebfla';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relgebfla`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relgebfla`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relflaadr';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relflaadr`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relflaadr`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relimoadr';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relimoadr`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relimoadr`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relanfwv';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relanfwv`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relanfwv`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdnutzungsarten';

/*[18:35:12][ 15 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdnutzungsarten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdfshinweise';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdfshinweise`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdflatyp';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdflatyp`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdflatyp`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdlagekat';

/*[18:35:12][ 16 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdlagekat`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdlagekat`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabflurstueck';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabflurstueck`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabflurstueck`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdfshinweise`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdgemarkungen';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdgemarkungen`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdfluren';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdfluren`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdfluren`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdgemarkungen`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdabstandsklassen';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdabstandsklassen`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdabstandsklassen`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabstarefpunkt';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabstarefpunkt`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relflaref';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relflaref`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relflaref`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabstarefpunkt`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdverfuegbarkeit';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdverfuegbarkeit`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdverfuegbarkeit`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabflatelekom';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabflatelekom`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabflatelekom`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabflaentsorgung';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabflaentsorgung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabflaentsorgung`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabflaversorgung';

/*[18:35:12][ 16 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabflaversorgung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabflaversorgung`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relgebimo';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relgebimo`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relgebimo`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabflaaltlast';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabflaaltlast`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabflaaltlast`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdaltlasten';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdaltlasten`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdaltlasten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdaltlaststat';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdaltlaststat`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdaltlaststat`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdobjekttypen';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdobjekttypen`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdobjekttypen`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdbauarten';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdbauarten`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdbauarten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdzustaende';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdzustaende`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdzustaende`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sddenkmalkat';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sddenkmalkat`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sddenkmalkat`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'reluntma';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`reluntma`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`reluntma`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relimoma';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relimoma`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relimoma`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relflama';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relflama`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relflama`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relanfdok';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relanfdok`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`relanfdok`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabstagebiet';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabstagebiet`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabstagebiet`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdgebtypen';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdgebtypen`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdgebtypen`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabflanutzung';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabflanutzung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabflanutzung`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdnutzungsarten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'tabimoeinheit';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`tabimoeinheit`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`tabimoeinheit`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdimoeinheiten';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdimoeinheiten`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdimoeinheiten`;

/*[18:35:12][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'sdbelegstat';

/*[18:35:12][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`sdbelegstat`;

/*[18:35:12][ 0 ms]*/ SHOW KEYS FROM `daten`.`sdbelegstat`;

/*[18:35:12][ 31 ms]*/ SHOW FULL TABLES FROM `daten` WHERE table_type = 'BASE TABLE';

/*[18:36:42][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relflaadr`;

/*[18:36:55][ 187 ms]*/ SHOW TABLE STATUS FROM `daten`WHERE ENGINE IS NOT NULL;

/*[18:36:55][ 16 ms]*/ SELECT `TABLE_NAME` AS View_name,`View_definition`,`Check_option`,`Is_updatable`,`Definer`,`Security_type` FROM `INFORMATION_SCHEMA`.`VIEWS` WHERE `TABLE_SCHEMA` = 'daten';

/*[18:36:55][ 0 ms]*/ SHOW PROCEDURE STATUS WHERE Db = 'daten';

/*[18:36:55][ 15 ms]*/ SHOW FUNCTION STATUS WHERE Db='daten';

/*[18:36:55][ 78 ms]*/ SHOW TRIGGERS FROM `daten`;

/*[18:36:55][ 0 ms]*/ SELECT `Event_name`,`Definer`,`Event_type`,`Execute_at`,`Interval_value`,`Interval_field`,`Starts`,`Ends`,`Status` FROM `INFORMATION_SCHEMA`.`EVENTS` WHERE `EVENT_SCHEMA` = 'daten';

/*[18:36:55][ 0 ms]*/ SHOW CREATE DATABASE `daten`;

/*[18:38:18][ 0 ms]*/ SHOW FULL FIELDS FROM `daten`.`relflaadr`;

/*[18:38:18][ 0 ms]*/ SHOW KEYS FROM `daten`.`relflaadr`;

/*[18:38:18][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relflaadr';

/*[18:38:30][ 0 ms]*/ SHOW KEYS FROM `daten`.`relflaadr` ;

/*[18:38:44][ 0 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relflaadr';

/*[18:39:07][ 0 ms]*/ SHOW KEYS FROM `daten`.`relimoadr` ;

/*[18:39:14][ 16 ms]*/ SHOW TABLE STATUS FROM `daten` LIKE 'relimoadr';

/*[18:39:23][ 0 ms]*/ USE `daten`;

/*[18:39:23][ 0 ms]*/ SHOW VARIABLES LIKE 'character_set_database';

/*[18:39:23][ 0 ms]*/ SHOW VARIABLES LIKE 'collation_database';

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflaeche`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relanffla`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relanfimo`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdanbindung`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdentfernung`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdgebausweis`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdversorgarten`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabanfrage`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdanfstatus`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabimmo`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabanftelekom`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdtelekom`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdentsorgarten`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabanfentsorgung`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabanfverkehr`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabanfversorgung`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdmesseinheiten`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdprostat`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relanftodo`;

/*[18:39:23][ 16 ms]*/ SHOW CREATE TABLE `daten`.`relkonanf`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relflapic`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relimopic`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relgebfla`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relflaadr`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relimoadr`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relanfwv`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdnutzungsarten`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdfshinweise`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdflatyp`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdlagekat`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflurstueck`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdgemarkungen`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdfluren`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdabstandsklassen`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabstarefpunkt`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relflaref`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdverfuegbarkeit`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflatelekom`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflaentsorgung`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflaversorgung`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relgebimo`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflaaltlast`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdaltlasten`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdaltlaststat`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdobjekttypen`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdbauarten`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdzustaende`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sddenkmalkat`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`reluntma`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relimoma`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relflama`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`relanfdok`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabstagebiet`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdgebtypen`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabflanutzung`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`tabimoeinheit`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdimoeinheiten`;

/*[18:39:23][ 0 ms]*/ SHOW CREATE TABLE `daten`.`sdbelegstat`;

[Author]

Posts