二进制日志文件记录的内容:记录表的更改。

  二进制日志文件记录的形式:基于语句的复制、基于行的复制。

  两种记录形式的优点与不足:

基于语句的复制–>它不能保证复制的正确性。如随机函数可能在两台机子上执行的结果是不一样的。

基于行的复制   –>它可以保证复制的正确性。但是问题是它可能要更多的网络流量。因为它要把整行数据都复制过去。

  查看二进制日志都记录了一些什么的方法:

show binlog events in ‘log_name’;在不指定log_name的情况下会默认为第一个二进制日志文件。

show binlog events in ‘logbin.000011′<img src=”data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABLcAAAEFCAYAAAARwgXXAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACKeSURBVHhe7d2/ayTZvhjwGv8ZDQPLXuYvsHnBmAUxGOaZGzi5ZmGT4fKCwcljDfbbRKGStQ1enBgF5qFkYPBNHDzwJEIwWMELbu5d7rIw0I6VKHhJW6e7zszRUf3qqupWn9bnA73TVd/zq05Va9VfTpWeLZfLVQUAAAAABfpn9b8AAAAAUBzJLQAAAACKJbkFAAAAQLEktwAAAAAoluQWAAAAAMWS3AIAAAA4MIvFYtDr0Pz1739f/c8//aneeijEQpk5SW4BAAAAHKDlctn5OkR/88c/Vv/hP/5dY4Ir7AuxUGZOklsAAAAAzOLf/uEP1X/5z//pQYIrJrZCLJSZ07Plcrmq3wMAAABwAMIth32rs4aUeSxpMivYVWIrGJTcev+n/1W/G+fbP/yb+h0AAAAAfUpPbgUxwRXsKrEVDL4t8V+9/te9r//7//7pwb/buP7xVfXq1dvq/ad6R491+bfvq9bi1z9Wb2Njn95Xb1+F9rPXj9eb+F0r7982xPPXvf6uqx/v9n1uYm3Tzv19JQrH9uPdfwEAAKBsIQk05EWZBq/c+pcv/6re2s7/uf7HASu3QiLltPr17UV1/u2n9fvq7LL64WUdbhASW6fVWXXx1UX15rc31WVT4ZDc+vTdXZvPN8mtd8+r87Rc074tfHr/tnpz/ku9tfH69evqw4cP9Vbtxdvq4vzb6m4UBQnn5GP1zeUP1bjZOS7hXJ/dXXHra+mzzXW7Oduv7y7Zh3PVXC9Kr/v78Qf17q7lV6fZdXXnRUNdAAAAyheSbSWv3NrnbYmDV2791b/456Ne3eJqqZBEuay/pL+sfrh7/83HsL9p5dCmTkhshYTW82/P1wmufAXXelXX6Yfql/M3X9r5cPplBVZ4vTmv7qemtvDpfXV2/nV1dnlRvX0REhuX1eXd+69+/VC9Pruszl5X638vw/7iElsl2tGKuXrFX57E3PS3uW7DOT57/aE6TTtvrffFp/cXdWIs0Vbv5Q+baym+Lt5WL6rX1RuJLQAAAA5M/vD48Arvw74Qm9uj/bXEzS2IZ1V1GpJDH6rTmHCqX6e/vq0uLr+pPobtmDQIq1deval+e3P35f67T9XbOqEVElyXYbHXXdlY9OUPd2XOXq9XtlzGFTWvzxoSBONcv7usXl2Edp9X357fjTOM5fpddfnqYr3i7OUPF9VXF27rK9un6v3ZeVXdXUMhWXlfOO9fVmq9/OauwK+f6gRrV71anRx9fS8+oF7t+l0o992DlWIAAADwmPLEVrTLBNfg2xL//d/+u/X71WpT/NmzZ+t/o7A/3xf81//232d5oHy8DfHe7YdhlUvIjyUro9blQmIs7FvflvhN9eryY/X89KvqommlVkh4/fC8ev/2TdWxyOa+9DbDMIbGWxuvqx/ffqq+m7RqK9y2dlF9dfaqujzdjD2sBvuh+nKL2ua2tLtzdDf+kFi7dxvbxd0xb4LJSqD09rn0trra52MLsQm3JYZ5efNb9SbWv7cdVj2FJGU4eXf93+szHU9+q19bPNs/+DbQbBz13vUcZwcdrquwQrDtFsC2ePP+2O9mheLwerV8bgEAADg6Q58Bdmi3Jf71739f/c0f/9h6+2FIbP2Pv//76n//wz/Ue6bbauVWTGCFV0xyxX/HCF/gv6zW2jxIPjxrKF3BFW83XK/EyjMOz7+tzrMkxrrcet+n6v1FuC3xoqpOf6hehrLpqq34WrcZVuE0xC7PqtchUZLvj33GJMODxNacfqnWhxD6PXtdfTi9m5OP32zGcfG2qs7fVddh/G9eV79cXq/nKrj++KF6/eZunHdj3Nw+GccfEyKbhNBd4PNx9a0WmtuH0/q2viSxFZ4/FcdzN/3V6edbU7vi4VbWsAJwk5ja9jbQz+NYtxnmeOCKu3D+6+v04zfxttp+1z++qc6/Put8plwXq7YAAACOX0haDXkdmpC0aktsBSE2Z2IrGH1bYlylla7WGpPois+lShMrn59Vld02+CDx9eAVkxJhZcxZVb0KtyWeVt9WX5IQja/0eV1htVfDn2sMfd/bv05s1SvB1rdL5u2eVh9+Oa/e5O1/FpI1sWzXX4h8Ub09rZM1L7+p7o6oevtdndZ4/rz6uvq1+hTqhtgvl9X1up3r6uOH19U3odi6TLjtM+vj+uN6xVRsKljfWjfK0GO57/VZsvKoHs9pmiB6+d36ltWP4aT2xXu1j/HeOLZpM0mYrp8R13ieM3fXynpl4eiEaDi3L6pXL7dJ3wEAAMDxGp3cylduNd2SOLf1s7UuL6uLi2T1zvq1WbXz4vNqlrAS67z6nAfJVm1d3BX+nEALr3Ql1sVX9xMotdB3+KuMnx//9e68+vrsrFqng8LDvkN27t4qr2TVV+NKos2D8zdlk7GO9rL67m1VXV5/ujuMi+rD62/quYj9rB9KtlXyabi5jyX1ovqqs72+eLTLMd61/sPd+f6cXGyzWU1YxaTn3SvcXbr+owdDEmPBOsn3qpLbAgAAgI2tklvxdsTwalq5FcUyQ6xvs6u/5H9Rr7IJK6O+fp4lhq6r67OzdZ11oml9a1i4P63ntrBQLvlrdrHfz+2ExMPZZfUqrpJqsHlI/CY5FG5/vLf4JiS4wi2KSR/79vzlq6q6fFe9uwx3rdWDuzvu9+shhYRfSAL+Uv0WsijrlV7n1bvPw60TL7OqV5Xd+XR92f2XKevxnKWZt+t31XlVJ3L64hN8SJZpfXp/Vp3/Uq9665JdT+uEYm/S6eHtr5uc6MXgWynD7aYvXoU/YwAAAAAEW6/cCsmstlVaacKrrUyu6bbEKl1l8+D2rZfrVVlhZVQVElTrvFbfSpyQuDqvfvlw+vnWwnTlVugiPAfptzdZO58+Vb/WbzeeV9/e9Xl51rLKJiS4Rt9uNoPn31Zvvv5QfUgTPnf7nodb5taJvPRZT3dzvH6+VIxtbuOczV2/p+GRYG827Z/99vW9W0wfCuf8rPo6rGKqk47rR4J9Tvr0xZ9XL1+92BzP0FVQtdfVx89tvlk/n2zAg9rD8X11cb/ewATVeOGWxKr6+vluewEAAICSbP3XEre17V9LDM+2evf8fPjDtpO/Cph+5Q8Pqw+rwV68fVt9fX6+fnB6aDO0/+UvB9bWfzHxS4exbrD5a4RtyYSwwiz7i4JhPLFy1u4+dP6VvT4tc3m8wrPZNn+1cM+nCQAAAJjJ4OTWFNskt5gg3CoXbo0csvKoieQWAAAAUJhByS0OX1xtFm63HJ2okdwCAAAACiO5BQAAAECxtn6gPAAAAAAcCsktAAAAAIoluQUAAABAsSS3AAAAACiW5BYAAAAAxZLcAgAAAKBYklsAAAAAFEtyCwAAAIBiPVsul6vFYlFvAgAAAMDurVar6ubmpt4a5/b21sotAAAAAMoluQUAAABAsSS3AAAAACiW5BYAAAAAxZLcAgAAAKBYklsAAAAAHJzvv/++ftdNcgsAAACAgxITW0MSXJJbAAAAAByMPKHVl+CS3AIAAADgIKSJrJ9++ql+153gktwCAAAA4KDExFaa4GojuQUAAADAwcgTWn0JrmfL5XK1WCzqTQAAAADYvdVqVd3c3NRb49ze3lq5BQAAAEC5JLcAAAAAKJbkFgAAAADFktwCAAAAoFiSWwAAAAAUS3ILAAAAgGJJbgEAAABQrGfL5XK1WCzqzcdzdXVVv9s4OTmp323EeL5/Dmnfu2i/zzb9j52HvvllHvu4Tpva3uX5Tdvua3dXx58fX5D2set4FMp1HVtXPPbRVR8AAOApWa1W1c3NTb01zu3t7eGs3Apf+Lq+9MVY05fQqR77y+Y++u+b36dgF9fOodjl+X3s6yZNCqXHGffvOh7l27m+OAAAALtR1G2JbV86n5L0yzfD7euaeernZx/HPzXJtG08bHfV6YsDAACwW+vbEn/++ed68770S2r88hb3tW1H+RfcNB5ief2obX9qSJnc0PG1ja2rflf5vJ82efvBtv2n2vptG1dX+0EaD7G2dtp0tZ+31dT2kPqpvngwtP0hpoxviNhGX722cn3Hl8ZDLG8nrx+kbXS131e3TzqWpn52HY/Sck264n11AQAAnqKd3JYYv3jFf/Mvem3SL25NdfP41C96TX106RtfKuzPy2xTf6q2PtL9bdrq9uk7vjyebg/R136fofXb4nFfEMuk+6aOL8jbbLLr9tv0HV8eT7dzbW2k+9u01d3WkH66TI2PEdrcRbsAAADMdFti/NKWf0nela4v3022Gd/UcU/50n7swtxMmZ+p9dtsc33wePrO/a7jAAAAHKbZnrkVEwLhC+IuvyTGtrdNPuxrfLSL5yC+tjW1fpfYpuvjsPWd913HAQAAODyDk1vxS1/65b9v39zyPoba9fjSNsP7seM8VOnxzTFveTtN7XfNXV5/W3n9dDsdy1Mx9/kdK/bfNoauayLYdRwAAIDDdO+B8umXu/gFs+kLX1Ms/0Ka12v6wtpVP4plusYzRNf40lhbf131g7R8XrdPU90grZ/3HzX119R/V/0gj6d1c03t9xnSfle7XfXzem3tpG10xYKmMXTJ60ehnaHjm6Kr/2Cb4+sab9pO2kZX/13tpdraDpra7+t/rnhTLBgaBwAAoNlcD5RfJ7cWi0W9q1/8Ijfli9scbbA/+fly/o6L8wsAAMBj2GtyK37ZjaZ86Z2zLfbHeTtuzi8AAAD79mgrtwAAAABgqrmSW7P9tUQAAAAA2DfJLQAAAACKJbkFAAAAQLEktwAAAAAoVjHJrfDX3PK/6AYAAADA01ZMcuvk5GT9rwQXAAAAAFFRtyVOTXDF1V8SZAAAAADHobhnblnBBQAAAED0bLlcrhaLRb35OLoSVTGZlYt12uIAAAAAHK7ValXd3NzUW+Pc3t4eRnJrWxJbAAAAAGWbK7lV3G2JUxJboW58AQAAAFC+opJbVmwBAAAAkComuTVHYktSDAAAAOC4FPnMrbGs/AIAAAA4DE/6gfIAAAAAlO3JPlAeAAAAACLJLQAAAACKJbkFAAAAQLEktwAAAAAoluQWAAAAAMWS3AIAAACgWJJbAAAAABTrQXLr6upq/eJpKv38u37L5vw9LvNfNucPADg2fr9hKCu3AAAAACjWs+VyuVosFq3Z0JOTk85MqXj58aCtzCGMry8etJU5hPGJd8eDtjKHML5jjwdtZQ5hfOLd8aCtzCGMT1y8jbi4uHgbcfGgrUyMczxWq1V1c3NTb41ze3v7JbkVxYvIRfM0lX7+Xb9lc/4el/kvm/MHABwbv98cv7mSW25LBAAAAKBYD1ZuAQAAAMCuWbkFAAAAwJMnuQUAAABAsSS3AAAAACiW5BYAAAAAxZLcAgAAAKBYklsAAAAAFEtyCwAAAIBiSW4BAAAAUKxny+VytVgs6s2qurq6Wv97cnKy/neIWCfapi6HZY7zHz3GdTDn+APX8n6NOX9Bfg6P9bz1zU86D2PmYMz853OfmnIep4xhzLEfgzHnL5hj/saeOwCALmN/v6Ecq9Wqurm5qbfGub29nWflVnqhueienvz8x+38C9Ohahp/um9fps5XKfM9t/R/ePG8PdW5eIzrNu0znoOx45hSb2xdHp7DbaWfweCpfv4AAHg8bkuEFvv8sjz1y6Avk09DuCb3eV1OUco4mVdJ1ygAAMdjltsSg756+ZfvvFwaD7FtxpG3HXS1H6TxpvpBV5kh4yrRNvOeyuu1bUd5+3PN75zjz8feth3EfVFXLOiLB2mZLkPq52NOt5veB031ozQ2p3ycQwyp0zX+/Jjz9vq2gyntD9HVfpDHg23aj8aMLcjrhe30fW7f48/b74qHWFs7TdKyeTvRNv0HQ/ptss24c21187EFbWXa+p3r+ACAp2fK7zeUYWe3JYaLZu4LJ70gY9vpL7t5fOwF3NZ+EGNt8SDG8jL5+IKm+scgPcYxwryk8xX0zV9ffBtpG2OEfrfte+j42+LpeGOZdF+fueqHMaV14xiHHt8c0j6GSsfUNK6+8bf1N/QYd91+kLada+p/rKlthLG0HVfadlpmzvE3aWq/q/90e4i0zdhG3E7/bYoFffFtpG3MrW18+ft87HG7rT4AQJf0dwjo8iC51fTL6ViH9AtsPK4pY5pavwRTjzH+8NnmB1AsG/vdtn5qrvGPMbXvQ7eP4xvbR3re2uoPaTvEd3n+p7S/D0OOoUt6Hhgmv26nzOHU8zdGOtYpYwcAaPIYv99Qpp09c+uQLsA4lqm/eMf6U9vhoTinh/LDa8z5jccQX8fmUI8vvWbiuJquoSHjj/u7yrSJdbrqxv1dZY7BMR/bLsTr4VB+/gEAQGkO4oHy8YtQKb/Y+wIyr3Q+02vhsTWNKd/XJC03xi7qb3sMXZraL8m249/3+T8WpcxB0/ndp7TfdCwAAMBwszxQvusX8bZf1vu+HAZDx5CXb6qf9h/2p2W6yudtRmnZY9I0F32GzE1fmbnmd47xp9J2utruGn9er62dtI2mPvoMrd/Uf1o36oqPGd8QTWMbom98XfGhx9Y1tjna75K3EcW20njY1zXWLmPqtY0taBpLUx9pG011+rSNIe8z6mp3276Dpv7T+n39bzO+LmPGHnT1n7fZth019T2kDABAk/x3D47PXA+Uf5Dcegzb/vKcc6FzzOa8/tv+59C2n93z863brucnv/bbttuEcnkdAABgmKNKbgX5FwhfEmAefZ8tnz2euimfAZ8fAAAY7+iSWwAAAAA8HXMltw7igfIAAAAAMIbkFgAAAADFktwCAAAAoFiSWwAAAAAUS3ILAAAAgGJJbgEAAABQrAfJraurq/WLp6n08+/6LZvz97jMf9mcPwDg2Pj9hqGs3AIAAACgWM+Wy+VqsVi0ZkNPTk46M6Xi5ceDtjKHML6+eNBW5hDGJ94dD9rKHML4jj0etJU5hPGJd8eDtjKHMD5x8Tbi4uLibcTFg7YyMc7xWK1W1c3NTb01zu3t7ZfkVhQvIhfN01T6+Xf9ls35e1zmv2zOHwBwbPx+c/zmSm65LREAAACAYj1YuQUAAAAAu2blFgAAAABPnuQWAAAAAMWS3AIAAACgWJJbAAAAABRLcgsAAACAYkluAQAAAFAsyS0AAAAAiiW5BQAAAECxni2Xy9Visag3q+rq6mr978nJyfrfoWK9aNv6XdK2+9odO/4++fEFaR+7jkehXNex9cX7xHFMaWOqKWMYUzfWafKY87AL6bEe4rEdwvVXsjB/U+bO/E/TNv/p5y7Iy+TxYMw5GHv++sbH7jSd+2DKOZz7/Ls+honzZH52Y+z87uv6Tfsp8RoYO/59ze8Y+diipjHGstuO/5CP/9CMneNgSl3KsFqtqpubm3prnNvb2/lWboWLbVcX3GNfyOkHKj3OuH/X8SjfzvXFS/AYxxDnO0jn/9DMMTeHemxMdwyf/5K1zX/cn/5sScvm8aYyu9Q3PvYjPf/xPAzVdA6H6jv/h3J9PEafHIf02t2lffSxS2PHv6/5HSMdVzrOOX+eHPLxHxI/w9mXo7stcR8/ZPo+oHPHw3ZXnb54KQ7pGA7tf1THcH7ZjWP5/Jdq7vl3LssUr4N9n7/Y367+n7WP36n6lPKZOIS5Ombml11yfbWb+v+3Un6Gcxxmuy0xaqufX9hd8RDL28nrB2kbXe331e2TjqWpn13Ho7Rck774EHO0MUbTHIwZw9i6eb2wnbYR41FbLOxvaqvJmPZTaZk+TW0M7T+YGh8qtjO2/lM2x9yZ//GGzl1eLt2O76Ntz8OY8zekTte40lh6DLFM33Ywpf0+++o/LzdUW3tDTa2f62tvTH/p3ARp3TwW9MWDrjJtsbA/bscy6XZeNuirH6RlgjQWTI33mdJ+Hotimb54MLT9sD9uD60fTI1HTX0PsW3/QSyT99k0hq72u9qOuuoH28aDvMwQsZ0p/YdYWztj5e21bUdpv3ksaBtX27i72g/SeIi1tdMkL9tUt6v/oX3n5baRttnW/hBT6lKGnd2WGC6auS+c9IKMbacflDzedQG3tZHub9NWd1tD+ukyNb5Loe999991vrc1dfxhLPm1kY4vtp2WaesvbyeWa2sjvoK29vNyQzSNP9UUT/ufGt9G2gb7Z/53K/2stJky/2POXywfxtb0ue37fLf119RWk12332eu/mP9tvJ9QnvxNcbU+kGs23QMadtpPO5vesV4kM5N3Jdqi6d9xTLpvr7207KptF4Qtpva6KsfpPVyaTt528GQeNsrxoOx7Ucx1lamLd7XftyXG1o/SGNNYrytfpdQtu0VdbUf36fxbXW1H7XFm/qfGk+FeNtriFhuaP/p9txC203tx767pGXS8ffJjy9I6+fxpvFN0dd/Wz9pmSDWbyvfZs7jGdM/T9OD5Fa4EPOLmo2+edl1fB/CGB5rHHnfY8YxdfxTf3iGvsfUj+OeMvap2vqPxxNjfXPUF+/y2HPw1Jn/3Uk/P03mmPex5y/9zLbVH9J2iO/ysz+l/T6P1X+c+/gK+sbRZGr9WCe2kWtrP+5veqVCnTHjGmpI+yGej2sbY+rH8nFsTXMTtI0/lm96NemK7VLb+FMh3je2MeOPfff13yT21/SKprQ/xJzt52OPxrafzkf+Kk067jnmuiRDzn+I7+q85v33jaVJ3ga0Obpnbu1a3wd/1/FjFI45fUWPORdj+4718mPpEn9Yb1NnF2L/TeOI+/zPBbaXfsa79MV3If1Mx/6bPuPxZ0B8NYn7u8q0iXW66sb9XWXGim12tR33N5WJ89g0d4cuP/+7EOesae7mMKT9uL+rTJex9WP5rusjlomv0gwZf9zfVWZb6bU7V5up0tuPYvu77ofDNOT8x/1NZeLPrni9DhXbytvM24c5HURyK17kYz44c+r78PZ9GHcdh2DXn5O8/XQ7/ay2yevDU9b02Wn6fJTy83/bz3fTcXcd67bt93ns/vsM7S+WGzu2tvpxu2megqY6U0xtr6/+1Pbnlo4nneM2U8c/tf5UpY9/btv+/Jmqb/764vvW9nMnF+OHNPY5DD3+NtteX2P7gZLM9kD5tg9L+sFL9X34grxu2E7bSdvo6r+rvVRb20FT+339zxVvigVD49uIbY2pO4f8WLYdx5jxD+mzq0xf/aYx5fvSNsK+rjpB3kefvvbTeJC3PzU+VD4u+uVzH42ZQ/O/vb75H3J+msrs8/zl/ef1u+J9daOusc3Rfp/H7r/LkD7SMnl8Sv28btRVpqn9Ll31Yyzuy7ejtI2uWNDUfpTXDfIyQT6eaGj9YGgbQ/roMqX9GGvb1xcPhrQfpbGor0wej5r6D/vidlM81TSWJtu03xQPmvZFXfXzel1tR3kf28Sb+uyTtx/F+n39p9r6zsc4VN/Ygq4y+XiaxtfXRx5P6+aa2h+iq15X/9uMbaqpfY2dG8ox1wPlHyS3HkN+wbqAYbj8fxg5nyMAaOZ3TngcQ77/HfPnc8jxw1NxVMmtIH6gIx9sAAB2xe+e8Lie+mfQzyDYOLrkFgAAAABPx1zJLX8tEQAAAIBiSW4BAAAAUCzJLQAAAACKJbkFAAAAQLEktwAAAAAoluQWAAAAAMV6kNy6urpav3iaSj//rt+yOX+Py/yXzfkDAI6N328YysotAAAAAIr1bLlcrhaLRWs29OTkpDNTKl5+PGgrcwjj64sHbWUOYXzi3fGgrcwhjO/Y40FbmUMYn3h3PGgrcwjjExdvIy4uLt5GXDxoKxPjHI/ValXd3NzUW+Pc3t5+SW5F8SJy0TxNpZ9/12/ZnL/HZf7L5vwBAMfG7zfHb67kltsSAQAAACjWg5VbAAAAALBrVm4BAAAA8ORJbgEAAABQLMktAAAAAIoluQUAAABAsSS3AAAAACiW5BYAAAAAxZLcAgAAAKBYklsAAAAAFOvZcrlcLRaLerOqrq6uqpOTk3qrPGH8QcnH0KfpGOO+1DZz0Fd/avu79hTOOwAAAByT1WpV3dzc1Fvj3N7e3l+51ZTAYD5zzG9TEifdF1/B0P766k9tfx8OcUwAAADA7q2TWyEhcCxJgTT5ckjmmN/YRt/xTe2rr/6hXisSXAAAAPD03LstcWjyJJcmE0LdpnbyhENTrG9flyHtp4a2G3W1H2zbf7DNGGIbTXXSWN84m/TVn9p+0FdvajyVjhcAAAA4TDu5LXGstiRCTDKkyYZYNk9WTJW23WZs/33j74vHfUEsk+6b29S2++pv2/7U+euLAwAAAE/X7H8tMSQdYgJijENMWuQJlTTJkgrxxxz/1L776o9tf+75a6sPAAAAPD2zJ7di0uHYEhDxeLoSMLFMfM0ptteX/Jnab1/9se2HeuG16/mLbY+tDwAAAJRl9uTWGDERERIT4f2hJSjShEw61jZp+SZ98TZ9fffNV+x3bP2x5yPtc5fzF/eNHScAAABQnvUD5X/++ed6876hSYI80dBUr69MmpgYk6TI24+a2puj/bxuXzxIy2zTd65p/Hn/QdcY+8YfbNt+l7x+X/9j49uMCQAAAHg8cz1Q/t5fSwQAAACAfTiov5YIAAAAAI9BcgsAAACAYkluAQAAAFAsyS0AAAAAiiW5BQAAAECxJLcAAAAAKJbkFgAAAADFktwCAAAAoFiSWwAAAAAUS3ILAAAAgGJJbgEAAABQLMktAAAAAIoluQUAAABAsSS3AAAAACiW5BYAAAAAxZLcAgAAAKBYklsAAAAAFEtyCwAAAIBiSW4BAAAAUCzJLQAAAACKJbkFAAAAQLEktwAAAAAo1rPlcrlaLBb15uO5urqq322cnJzU7zZiPN8PAAAAQHlWq1V1c3NTb41ze3t7OCu3QtKqK3EVY3kSDAAAAICnq6jbEiW4AAAAAEitb0v8+eef68370pVU+W2BbdtRWjdI4yGW14/a9qeGlAEAAADgcO3ktsSYLIr/5gmrNmmyqaluHp+anGrqAwAAAICnZ5bbEvNkU0xi7crU5BgAAAAAj+8vf/nL6Fc02zO3YkIrJJ52uaJKYgsAAACAaHByKyaT0uRV37655X0AAAAA8LTde6B8mjTqSiQ1xfJkVl6vKdnVVT+KZbrG06et7WhMmwAAAACMFx4o/+c//7ne2t7vfve79QPl18mtxWJR7+43JckUzdHGNiS3AAAAAA7LXMmtQbclhuRQfAVzJLaCvqQTAAAAAHTZeuVWifqSaFZuAQAAAOzXo92WCAAAAABT7fW2RAAAAAA4RJJbAAAAABRLcgsAAACAYkluAQAAAFAsyS0AAAAAiiW5BQAAAECxJLcAAAAAKJbkFgAAAADFktwCAAAAoFjPlsvlarFY1JsAAAAAsHur1aq6ubmpt8a5vb21cgsAAACAckluAQAAAFAsyS0AAAAAiiW5BQAAAECxJLcAAAAAKJbkFgAAAADFktwCAAAAoFiSWwAAAAAUS3ILAAAAgGJJbgEAAABQLMktAAAAAIoluQUAAABAsSS3AAAAACiW5BYAAAAAxZLcAgAAAKBYklsAAAAAFEtyCwAAAIBiSW4BAAAAUCzJLQAAAACKJbkFAAAAQLEktwAAAAAoluQWAAAAAMWS3AIAAACgWJJbAAAAABRLcgsAAACAYkluAQAAAFAsyS0AAAAAiiW5BQAAAECxJLcAAAAAKJbkFgAAAAAH4fvvv6/f3de2P5DcAgAAAOBg5ImsrsRWILkFAAAAwEGJCa2+xFbwbLlcrhaLRb0JAAAAALu3Wq2qm5ubeuuLpoTWTz/9VL+77/b21sotAAAAAA5HnshqS2xFklsAAAAAHJSY0OpLbAVuSwQAAABg79puS9yG2xIBAAAAKJrkFgAAAADFktwCAAAAoFiSWwAAAAAUa/1A+fo9AAAAABSkqv4/1Vb70EbUQ84AAAAASUVORK5CYII=” alt=”” />

log_name :  日志文件名

pos:       事件开始的字节位置

Event_Type: 事件的类型

Server_ID:   服务器的ID(my.cnf中指定的Server_ID)

End_log_pos:   事件结束的字节位置+1

Info:                事件的可读文本

发表回复

后才能评论