<legend id='vhInU'><style id='vhInU'><dir id='vhInU'><q id='vhInU'></q></dir></style></legend>
    <bdo id='vhInU'></bdo><ul id='vhInU'></ul>
  • <tfoot id='vhInU'></tfoot>

      <i id='vhInU'><tr id='vhInU'><dt id='vhInU'><q id='vhInU'><span id='vhInU'><b id='vhInU'><form id='vhInU'><ins id='vhInU'></ins><ul id='vhInU'></ul><sub id='vhInU'></sub></form><legend id='vhInU'></legend><bdo id='vhInU'><pre id='vhInU'><center id='vhInU'></center></pre></bdo></b><th id='vhInU'></th></span></q></dt></tr></i><div id='vhInU'><tfoot id='vhInU'></tfoot><dl id='vhInU'><fieldset id='vhInU'></fieldset></dl></div>
      1. <small id='vhInU'></small><noframes id='vhInU'>

        ΪʲôһЩmysqlÁ¬½ÓÔÚɾ³ý+²åÈëºóÑ¡ÔñmysqlÊý¾Ý¿âÖеľÉÊý¾Ý?

        Why are some mysql connections selecting old data the mysql database after a delete + insert?(ΪʲôһЩmysqlÁ¬½ÓÔÚɾ³ý+²åÈëºóÑ¡ÔñmysqlÊý¾Ý¿âÖеľÉÊý¾Ý?)
        <legend id='t5fON'><style id='t5fON'><dir id='t5fON'><q id='t5fON'></q></dir></style></legend>

          <tfoot id='t5fON'></tfoot>

            <tbody id='t5fON'></tbody>
            1. <small id='t5fON'></small><noframes id='t5fON'>

                <bdo id='t5fON'></bdo><ul id='t5fON'></ul>
              • <i id='t5fON'><tr id='t5fON'><dt id='t5fON'><q id='t5fON'><span id='t5fON'><b id='t5fON'><form id='t5fON'><ins id='t5fON'></ins><ul id='t5fON'></ul><sub id='t5fON'></sub></form><legend id='t5fON'></legend><bdo id='t5fON'><pre id='t5fON'><center id='t5fON'></center></pre></bdo></b><th id='t5fON'></th></span></q></dt></tr></i><div id='t5fON'><tfoot id='t5fON'></tfoot><dl id='t5fON'><fieldset id='t5fON'></fieldset></dl></div>

                  ±¾ÎĽéÉÜÁËΪʲôһЩmysqlÁ¬½ÓÔÚɾ³ý+²åÈëºóÑ¡ÔñmysqlÊý¾Ý¿âÖеľÉÊý¾Ý?µÄ´¦Àí·½·¨£¬¶Ô´ó¼Ò½â¾öÎÊÌâ¾ßÓÐÒ»¶¨µÄ²Î¿¼¼ÛÖµ£¬ÐèÒªµÄÅóÓÑÃÇÏÂÃæËæןú°æÍøµÄС±àÀ´Ò»Æðѧϰ°É£¡

                  ÎÊÌâÃèÊö

                  ÎÒµÄ python/wsgi Web Ó¦ÓóÌÐòÖеĻỰÓÐÎÊÌâ.2 ¸ö wsgi ÊØ»¤½ø³ÌÖеÄÿ¸öÏ̶߳¼ÓÐÒ»¸ö²»Í¬µÄ¡¢³Ö¾ÃµÄ mysqldb Á¬½Ó.ÓÐʱ£¬ÔÚɾ³ý¾É»á»°²¢´´½¨Ð»Ựºó£¬Ä³Ð©Á¬½ÓÈÔÈ»ÔÚÑ¡ÔñÖлñÈ¡¾É»á»°£¬ÕâÒâζ×ÅËüÃÇÎÞ·¨ÑéÖ¤»á»°²¢ÔÙ´ÎÒªÇóµÇ¼.

                  I'm having a problem with the sessions in my python/wsgi web app. There is a different, persistent mysqldb connection for each thread in each of 2 wsgi daemon processes. Sometimes, after deleting old sessions and creating a new one, some connections still fetch the old sessions in a select, which means they fail to validate the session and ask for login again.

                  ÏêϸÐÅÏ¢:»á»°´æ´¢ÔÚ±¾µØ mysql Êý¾Ý¿âµÄ InnoDB ±íÖÐ.Éí·ÝÑéÖ¤ºó(ͨ¹ý CAS)£¬ÎÒɾ³ý¸ÃÓû§Ö®Ç°µÄËùÓлỰ£¬´´½¨Ò»¸öлỰ(²åÈëÒ»ÐÐ)£¬Ìá½»ÊÂÎñ£¬²¢Ê¹Óà cookie ÖеÄлỰ ID Öض¨Ïòµ½×î³õÇëÇóµÄÒ³Ãæ.¶ÔÓÚÿ¸öÇëÇ󣬶¼»á¸ù¾ÝÊý¾Ý¿âÖеĻỰ¼ì²é cookie ÖеĻỰ ID.

                  Details: Sessions are stored in an InnoDB table in a local mysql database. After authentication (through CAS), I delete any previous sessions for that user, create a new session (insert a row), commit the transaction, and redirect to the originally requested page with the new session id in the cookie. For each request, a session id in the cookie is checked against the sessions in the database.

                  ÓÐʱ£¬Öض¨ÏòºóÔÚÊý¾Ý¿âÖÐÕÒ²»µ½Ð´´½¨µÄ»á»°.Ïà·´£¬¸ÃÓû§µÄ old »á»°ÈÔÈ»´æÔÚ.(ÎÒͨ¹ýÔÚÿ¸öÇëÇó¿ªÊ¼Ê±Ñ¡Ôñ²¢¼Ç¼ËùÓлỰÀ´¼ì²éÕâÒ»µã).²»ÖªºÎ¹Ê£¬Îҵõ½ÁË»º´æµÄ½á¹û.ÎÒ³¢ÊÔʹÓà SQL_NO_CACHE Ñ¡Ôñ»á»°£¬µ«Ã»ÓÐÈκÎÇø±ð.

                  Sometimes, a newly created session is not found in the database after the redirect. Instead, the old session for that user is still there. (I checked this by selecting and logging all of the sessions at the beginning of each request). Somehow, I'm getting cached results. I tried selecting the sessions with SQL_NO_CACHE, but it made no difference.

                  ΪʲôÎÒ»áµÃµ½»º´æµÄ½á¹û?»º´æ»¹ÄÜÔÚÄÄÀï·¢Éú£¬ÈçºÎÍ£Ö¹»òˢлº´æ?»ù±¾ÉÏ£¬ÎªÊ²Ã´ÆäËûÁ¬½Ó¿´²»µ½Ð²åÈëµÄÊý¾Ý?

                  Why am I getting cached results? Where else could the caching occur, and how can stop it or refresh the cache? Basically, why do the other connections fail to see the newly inserted data?

                  ÍƼö´ð°¸

                  MySQL ĬÈϸôÀ뼶±ðΪREPEATABLE READ"£¬ÕâÒâζ×ÅÔÚÊÂÎñ¿ªÊ¼ºóÄú½«¿´²»µ½ÊÂÎñÖеÄÈκθü¸Ä - ¼´Ê¹ÄÇЩ(ÆäËû)ÒÑÌá½»¸ü¸Ä.

                  MySQL defaults to the isolation level "REPEATABLE READ" which means you will not see any changes in your transaction that were done after the transaction started - even if those (other) changes were committed.

                  Èç¹ûÄúÔÚÕâЩ»á»°Öз¢³ö COMMIT »ò ROLLBACK£¬ÄúÓ¦¸Ã»á¿´µ½¸ü¸ÄµÄÊý¾Ý(ÒòΪÕ⽫½áÊøÕýÔÚ½øÐÐ"µÄÊÂÎñ).

                  If you issue a COMMIT or ROLLBACK in those sessions, you should see the changed data (because that will end the transaction that is "in progress").

                  ÁíÒ»¸öÑ¡ÏîÊǽ«ÕâЩ»á»°µÄ¸ôÀ뼶±ð¸ü¸ÄΪREAD COMMITTED".Ò²Ðí»¹ÓÐÒ»¸öÑ¡Ïî¿ÉÒÔ¸ü¸ÄĬÈϼ¶±ð£¬µ«ÄúÐèÒª²é¿´ÊÖ²á.

                  The other option is to change the isolation level for those sessions to "READ COMMITTED". Maybe there is an option to change the default level as well, but you would need to check the manual for that.

                  Õâƪ¹ØÓÚΪʲôһЩmysqlÁ¬½ÓÔÚɾ³ý+²åÈëºóÑ¡ÔñmysqlÊý¾Ý¿âÖеľÉÊý¾Ý?µÄÎÄÕ¾ͽéÉܵ½ÕâÁË£¬Ï£ÍûÎÒÃÇÍƼöµÄ´ð°¸¶Ô´ó¼ÒÓÐËù°ïÖú£¬Ò²Ï£Íû´ó¼Ò¶à¶àÖ§³Ö¸ú°æÍø£¡

                  ±¾Õ¾²¿·ÖÄÚÈÝÀ´Ô´»¥ÁªÍø,Èç¹ûÓÐͼƬ»òÕßÄÚÈÝÇÖ·¸ÁËÄúµÄȨÒ棬ÇëÁªÏµÎÒÃÇ£¬ÎÒÃÇ»áÔÚÈ·ÈϺóµÚһʱ¼ä½øÐÐɾ³ý£¡

                  Ïà¹ØÎĵµÍƼö

                  Set the variable result, from query(ÉèÖñäÁ¿½á¹û£¬À´×Ô²éѯ)
                  What is dynamic SQL?(ʲôÊǶ¯Ì¬ SQL?)
                  Mysql - How to quit/exit from stored procedure(Mysql - ÈçºÎÍ˳ö/Í˳ö´æ´¢¹ý³Ì)
                  Does MySQL have time-based triggers?(MySQL ÓлùÓÚʱ¼äµÄ´¥·¢Æ÷Âð?)
                  is it possible to call a sql script from a stored procedure in another sql script?(ÊÇ·ñ¿ÉÒÔ´ÓÁíÒ»¸ö sql ½Å±¾ÖеĴ洢¹ý³Ìµ÷Óà sql ½Å±¾?)
                  Procedure to loop through comma separated string is not working(±éÀú¶ººÅ·Ö¸ô×Ö·û´®µÄ¹ý³Ì²»Æð×÷ÓÃ)
                    <tfoot id='Reop5'></tfoot>
                      <tbody id='Reop5'></tbody>
                    <legend id='Reop5'><style id='Reop5'><dir id='Reop5'><q id='Reop5'></q></dir></style></legend>
                    <i id='Reop5'><tr id='Reop5'><dt id='Reop5'><q id='Reop5'><span id='Reop5'><b id='Reop5'><form id='Reop5'><ins id='Reop5'></ins><ul id='Reop5'></ul><sub id='Reop5'></sub></form><legend id='Reop5'></legend><bdo id='Reop5'><pre id='Reop5'><center id='Reop5'></center></pre></bdo></b><th id='Reop5'></th></span></q></dt></tr></i><div id='Reop5'><tfoot id='Reop5'></tfoot><dl id='Reop5'><fieldset id='Reop5'></fieldset></dl></div>
                        <bdo id='Reop5'></bdo><ul id='Reop5'></ul>

                        <small id='Reop5'></small><noframes id='Reop5'>