<div dir="ltr"><div><div><div><div>Hi, I think you tackle it wrong.<br><br></div>If there is no need for accessing the database all the time, why not cache the result in tools such as Memcached or Redis ?<br></div><div>If they are different clients (as in agents), then there are other tools at your disposal, such as Varnish, that create cached version for the web.<br>
</div><div><br></div>Secondly, the MySQL/MariaDB triggers really basics if you compare them to PG and Fb (true open source solutions), not to mention non open source databases such as SQL Server and Oracle.<br><br></div>
Third, try to see how you can optimize the page. If there is no need for constant data reading, why does it constantly refresh itself ?<br>
<br></div>Ido<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Nov 17, 2013 at 10:18 AM, Erez D <span dir="ltr"><<a href="mailto:erez0001@gmail.com" target="_blank">erez0001@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"><div><div><div><div><div><div><div>hello<br><br></div>i have a web page that refreshes all the time to display things from a mysql database which is updated from time to time.<br>
</div>however. this meens a lot of un-needed acesses to the database. and this refresshing page may be openede by many browsers. causing a huge load on the database.<br>
<br></div>i know mysql supports triggers, but it seems this is only internal (i.e. trigger may do a query, usually an "update" query, but this is not what i need).<br><br>I am looking for a way to leave the connection open with mysql, not sending any queries, just waiting for mysql to notify me when a somthing changes.<br>
<br></div>does mysql support that ?<br></div>examples of doing that will be nice<br><br><br></div>thanks,<br></div>erez.<br></div>
<br>_______________________________________________<br>
Linux-il mailing list<br>
<a href="mailto:Linux-il@cs.huji.ac.il">Linux-il@cs.huji.ac.il</a><br>
<a href="http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il" target="_blank">http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il</a><br>
<br></blockquote></div><br></div>