I have already 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????????
????????????




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

????:&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; Dubbo


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

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

Reply via email to