Already created issues, please help to solve



https://github.com/apache/incubator-shardingsphere/issues/4604




------------------ ???????? ------------------
??????:&nbsp;"Juan Pan"<[email protected]&gt;;
????????:&nbsp;2020??3??5??(??????) ????10:37
??????:&nbsp;"[email protected]"<[email protected]&gt;;
????:&nbsp;"dev"<[email protected]&gt;;
????:&nbsp;Re: Too many sub tables lead to slow start



Hi


The dev list will generally drop the attachments, if you debugged and found 
something, my suggestion is to attach the log a ISSUE[1].


[1] https://github.com/apache/incubator-shardingsphere/issues


Cheers,
Trista


&nbsp;Juan Pan (Trista)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
Senior DBA &amp; PPMC of Apache ShardingSphere(Incubating)
E-mail: [email protected]




On 03/4/2020 21:19????????????<[email protected]&gt; wrote??
I have already&amp;nbsp;check.table.metadata.enabled: false


But the startup is still slow. I have about 3000 meters


The code in the attachment is that I track the slow execution position. 
Although my database performance is average, it takes more than 15 minutes to 
start


Definitely help



????????check.table.metadata.enabled: false
??????????????????????????3000????
??????????????????????????????????????????????????????????????????????15????????
????????????




------------------&amp;nbsp;????????&amp;nbsp;------------------
??????:&amp;nbsp;"[email protected]"<[email protected]&amp;gt;;
????????:&amp;nbsp;2020??3??4??(??????) ????9:13
??????:&amp;nbsp;"dev"<[email protected]&amp;gt;;

????:&amp;nbsp;Re: Too many sub tables lead to slow start



Hi, google translate may can not translate your mean correctly, I can't get
your point.

------------------

Liang Zhang (John)
Apache ShardingSphere &amp;amp; Dubbo


?????????? <[email protected]&amp;gt; ??2020??3??4?????? ????8:31??????

&amp;gt; Set check.table.metadata.enabled: false to start slowly
&amp;gt;
&amp;gt; I have nearly 3000 watches
&amp;gt;
&amp;gt; As shown in the attachment code location
&amp;gt;
&amp;gt; Very time-consuming
&amp;gt;
&amp;gt;
&amp;gt;
&amp;gt;
&amp;gt; ------------------ ???????? ------------------
&amp;gt; *??????:* "Juan Pan"<[email protected]&amp;gt;;
&amp;gt; *????????:* 2020??3??4??(??????) ????7:06
&amp;gt; *??????:* 
"[email protected]"<[email protected]&amp;gt;;
&amp;gt; *????:* "dev"<[email protected]&amp;gt;;
&amp;gt; *????:* Re:Too many sub tables lead to slow start
&amp;gt;
&amp;gt; Hi
&amp;gt;
&amp;gt;
&amp;gt; The configuration option `check.table.metadata.enabled` which decides 
to
&amp;gt; check metadata of each table or not
&amp;gt; can affect the speed of start-up.
&amp;gt;
&amp;gt;
&amp;gt;&amp;nbsp; Juan Pan (Trista)
&amp;gt;
&amp;gt; Senior DBA &amp;amp; PPMC of Apache ShardingSphere(Incubating)
&amp;gt; E-mail: [email protected]
&amp;gt;
&amp;gt;
&amp;gt;
&amp;gt;
&amp;gt; On 03/4/2020 18:19????????????<[email protected]&amp;gt; wrote??
&amp;gt; Hello
&amp;gt; I use mysql5 database
&amp;gt; Sharding version: 4.0.0-rc2
&amp;gt; As there are about 2000 tables, the program starts slowly. Is there any
&amp;gt; way to solve this problem?
&amp;gt;

Reply via email to