<p dir="ltr">Thank you all.</p>
<p dir="ltr">Whats the maximum connections can it bear when add a pool? If I use Cowboy to provide a REST API for data query and I start up the http listener with 10000 acceptors and 10000 emysql connections, does that mean i can support 10000 concurrency?</p>

<div class="gmail_quote">On 5 Jul 2013 14:35, "Mike Oxford" <<a href="mailto:moxford@gmail.com">moxford@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
emysql_util also has some other methods ... as_record/1, as_proplist/1, as_dict/1<div>Those will clean up the raw output into something far more usable/accessible.<br><div><br></div><div>-mox<br><br><div class="gmail_quote">

On Thu, Jul 4, 2013 at 2:12 AM, Barco You <span dir="ltr"><<a href="mailto:barcojie@gmail.com" target="_blank">barcojie@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div dir="ltr">Where can I find the detailed description about the fields for result_packet?<div><br></div><div>The result_pakcet looks like {result_packet, Number, List1, List2, <<>>}, and seemingly only List2 is meaningful. Why is there Number, List1 and <<>> ?</div>


</div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 4:37 PM, Barco You <span dir="ltr"><<a href="mailto:barcojie@gmail.com" target="_blank">barcojie@gmail.com</a>></span> wrote:<br>


<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">What is this part as following for?<div><div><br></div><div><div style="font-family:arial,sans-serif;font-size:13px">


 [{field,2,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div style="font-family:arial,sans-serif;font-size:13px">                       <<"userid">>,<<"userid">>,8,<<>>,63,20,16899,0},</div><div style="font-family:arial,sans-serif;font-size:13px">



                {field,3,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div><div style="font-family:arial,sans-serif;font-size:13px">



                       <<"name">>,<<"name">>,254,<<>>,33,36,20489,0},</div><div style="font-family:arial,sans-serif;font-size:13px">                {field,4,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>



<div style="font-family:arial,sans-serif;font-size:13px">                       <<"id_no">>,<<"id_no">>,254,<<>>,33,54,20481,0},</div><div style="font-family:arial,sans-serif;font-size:13px">



                {field,5,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div><div style="font-family:arial,sans-serif;font-size:13px">



                       <<"sex">>,<<"sex">>,1,<<>>,63,1,0,0},</div><div style="font-family:arial,sans-serif;font-size:13px">                {field,6,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>



<div style="font-family:arial,sans-serif;font-size:13px">                       <<"age">>,<<"age">>,2,<<>>,63,6,0,0},</div><div style="font-family:arial,sans-serif;font-size:13px">



                {field,7,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div><div style="font-family:arial,sans-serif;font-size:13px">



                       <<"tel">>,<<"tel">>,254,<<>>,33,33,0,0},</div><div style="font-family:arial,sans-serif;font-size:13px">                {field,8,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>



<div style="font-family:arial,sans-serif;font-size:13px">                       <<"email">>,<<"email">>,253,<<>>,33,132,0,0}],</div></div></div></div><div>
<div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 4:35 PM, Barco You <span dir="ltr"><<a href="mailto:barcojie@gmail.com" target="_blank">barcojie@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">



<div dir="ltr">Solved, the bind-address of mhysql should be changed to 0.0.0.0<div><br></div><div>But the result packet of emysql:execute looks very verbose and fuzzy. How can I get only the clean field value or a row, like {field, value} ?</div>




<div><br></div><div><div>emysql:execute(db_pool, <<"select * from user where tel = 13761975289">>).</div><div>{result_packet,11,</div><div>               [{field,2,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>




<div>                       <<"userid">>,<<"userid">>,8,<<>>,63,20,16899,0},</div><div>                {field,3,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>




<div>                       <<"name">>,<<"name">>,254,<<>>,33,36,20489,0},</div><div>                {field,4,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>




<div>                       <<"id_no">>,<<"id_no">>,254,<<>>,33,54,20481,0},</div><div>                {field,5,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>




<div>                       <<"sex">>,<<"sex">>,1,<<>>,63,1,0,0},</div><div>                {field,6,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>




<div>                       <<"age">>,<<"age">>,2,<<>>,63,6,0,0},</div><div>                {field,7,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>




<div>                       <<"tel">>,<<"tel">>,254,<<>>,33,33,0,0},</div><div>                {field,8,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>




<div>                       <<"email">>,<<"email">>,253,<<>>,33,132,0,0}],</div><div>               [[1,</div><div>                 <<231,138,185,230,157,176>>,</div>




<div>                 <<"237689098736789870">>,1,32,<<"13761975289">>,</div><div>                 <<"<a href="mailto:you.jie@bestv.com.cn" target="_blank">you.jie@bestv.com.cn</a>">>]],</div>




<div>               <<>>}</div></div><div><br></div></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 4:21 PM, Max Lapshin <span dir="ltr"><<a href="mailto:max.lapshin@gmail.com" target="_blank">max.lapshin@gmail.com</a>></span> wrote:<br>




<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Barco, it means that you need to read manual for mysql server and<br>
enable socket listener.<br>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
erlang-questions mailing list<br>
<a href="mailto:erlang-questions@erlang.org" target="_blank">erlang-questions@erlang.org</a><br>
<a href="http://erlang.org/mailman/listinfo/erlang-questions" target="_blank">http://erlang.org/mailman/listinfo/erlang-questions</a><br>
<br></blockquote></div><br></div></div>
</blockquote></div>