MySQL: Concept
31st August 2020 at 3:16pm
MySQL
TOC
MySQL: Concept: Binary Log
MySQL: Concept: Information Schema
%22%20d%3D%22M349.8%2C120c-0.4%2C0-0.7%2C0-1.1%2C0c-5.8%2C0.1-7.4%2C7.9-2.2%2C10.3c39.8%2C18.2%2C67.6%2C58.4%2C67.6%2C104.9%0A%09c0%2C24.2-7.4%2C47.3-21.5%2C67c-4.5%2C6.3-9.4%2C12.1-14.2%2C17.7c-14.6%2C17.1-27.2%2C31.9-27.2%2C60v52.4c0%2C16.5-4.4%2C29.1-13.3%2C38.6%0A%09c-0.1%2C0.1-0.3%2C0.3-0.4%2C0.4c-6.6%2C6.7-4.6%2C18%2C4%2C21.7c3.1%2C1.3%2C5.9%2C2.1%2C8.2%2C2.1c11.3%2C0%2C33.5-18.4%2C39-24.2c9-9.5%2C13.3-22.1%2C13.3-38.6%0A%09v-52.4c0-28.1%2C12.6-42.9%2C27.2-60c4.7-5.6%2C9.6-11.3%2C14.2-17.7c14.1-19.8%2C21.6-43.1%2C21.5-67.5C464.8%2C171%2C413.6%2C120%2C349.8%2C120z%22%3E%3C%2Fpath%3E%0A%3Cpath%20d%3D%22M349.8%2C112c-67.9%2C0-123.2%2C55.3-123.2%2C123.2c0%2C25.9%2C7.9%2C50.7%2C23%2C71.6c4.8%2C6.7%2C10%2C12.8%2C14.6%2C18.2%0A%09c14.1%2C16.6%2C25.3%2C29.7%2C25.3%2C54.9v52.4c0%2C18.6%2C5.1%2C33.1%2C15.5%2C44.1c3.9%2C4.2%2C28.9%2C26.7%2C44.9%2C26.7c16%2C0%2C40.9-22.6%2C44.8-26.7%0A%09c10.4-11%2C15.5-25.5%2C15.5-44.1v-52.4c0-0.3%2C0-0.6%2C0-1c0.1-0.5%2C0.2-1.1%2C0.2-1.6c0-0.4%2C0-0.8-0.1-1.1c1.1-22.7%2C11.8-35.4%2C25.2-51.1%0A%09l0.1-0.2c4.8-5.6%2C9.8-11.5%2C14.4-18c15-21%2C23-45.8%2C23-71.6C473.1%2C167.3%2C417.8%2C112%2C349.8%2C112z%20M437.1%2C297.5c-4.3%2C6-9%2C11.6-13.6%2C17%0A%09l-0.1%2C0.2c-13.2%2C15.5-25.7%2C30.2-28.5%2C54.6h-44.5c-4.4%2C0-8%2C3.6-8%2C8s3.6%2C8%2C8%2C8h43.9v47c0%2C0.4%2C0%2C0.8%2C0%2C1.2h-43.9c-4.4%2C0-8%2C3.6-8%2C8%0A%09s3.6%2C8%2C8%2C8H392c-1.8%2C6.3-4.8%2C11.6-8.9%2C15.9c-6.8%2C7.2-26.4%2C21.7-33.2%2C21.7c-6.8%2C0-26.5-14.6-33.2-21.7c-7.5-7.9-11.1-18.8-11.1-33.1%0A%09v-52.4c0-31.1-14.2-47.7-29.1-65.3c-4.6-5.4-9.4-11-13.8-17.1c-13.1-18.3-20-39.8-20-62.3c0-59.1%2C48.1-107.2%2C107.2-107.2%0A%09s107.2%2C48.1%2C107.2%2C107.2C457.1%2C257.7%2C450.2%2C279.3%2C437.1%2C297.5z%20M203.3%2C265.5c0%2C4.4-3.6%2C8-8%2C8h-67.8c-4.4%2C0-8-3.6-8-8s3.6-8%2C8-8h67.8%0A%09C199.7%2C257.5%2C203.3%2C261.1%2C203.3%2C265.5z%20M504.7%2C120.6l-18.9%2C18.9c-1.6%2C1.6-3.6%2C2.3-5.7%2C2.3s-4.1-0.8-5.7-2.3c-3.1-3.1-3.1-8.2%2C0-11.3%0A%09l18.9-18.9c3.1-3.1%2C8.2-3.1%2C11.3%2C0C507.8%2C112.4%2C507.8%2C117.5%2C504.7%2C120.6z%20M225.8%2C135c-1.6%2C1.6-3.6%2C2.3-5.7%2C2.3s-4.1-0.8-5.7-2.3%0A%09l-47.9-47.9c-3.1-3.1-3.1-8.2%2C0-11.3c3.1-3.1%2C8.2-3.1%2C11.3%2C0l47.9%2C47.9C228.9%2C126.8%2C228.9%2C131.9%2C225.8%2C135z%20M500.8%2C407.7%0A%09c3.1%2C3.1%2C3.1%2C8.2%2C0%2C11.3c-1.6%2C1.6-3.6%2C2.3-5.7%2C2.3c-2%2C0-4.1-0.8-5.7-2.3L460%2C389.5c-3.1-3.1-3.1-8.2%2C0-11.3c3.1-3.1%2C8.2-3.1%2C11.3%2C0%0A%09L500.8%2C407.7z%20M341.8%2C82.6V14.8c0-4.4%2C3.6-8%2C8-8s8%2C3.6%2C8%2C8v67.8c0%2C4.4-3.6%2C8-8%2C8S341.8%2C87%2C341.8%2C82.6z%22%3E%3C%2Fpath%3E%0A%3Cpath%20d%3D%22M154.6%2C440.2c-4.9-1.1-9.7%2C2-10.7%2C6.9c-1.1%2C4.9%2C2%2C9.7%2C6.9%2C10.7c0.6%2C0.1%2C1.3%2C0.2%2C1.9%2C0.2c1.7%2C0%2C3.4-0.5%2C4.9-1.4%0A%09c2-1.3%2C3.4-3.3%2C3.9-5.7c0.5-2.4%2C0.1-4.8-1.2-6.8C159%2C442.1%2C157%2C440.7%2C154.6%2C440.2z%20M275.1%2C67c-4.9-1.1-9.7%2C2-10.7%2C6.9%0A%09c-1.1%2C4.9%2C2%2C9.7%2C6.9%2C10.7c0.6%2C0.1%2C1.3%2C0.2%2C1.9%2C0.2c4.2%2C0%2C7.9-2.9%2C8.8-7.1C283.1%2C72.9%2C280%2C68.1%2C275.1%2C67z%20M41.6%2C274.3%0A%09c0.6%2C0.1%2C1.3%2C0.2%2C1.9%2C0.2c1.7%2C0%2C3.4-0.5%2C4.9-1.4c2-1.3%2C3.4-3.3%2C3.9-5.7c0.5-2.4%2C0.1-4.8-1.2-6.8c-1.3-2-3.3-3.4-5.7-3.9%0A%09c-4.9-1.1-9.7%2C2-10.7%2C6.9C33.6%2C268.4%2C36.7%2C273.3%2C41.6%2C274.3z%20M199.7%2C194.9c2-1.3%2C3.4-3.3%2C3.9-5.7c1.1-4.9-2-9.7-6.9-10.7%0A%09c-2.4-0.5-4.8-0.1-6.8%2C1.2c-2%2C1.3-3.4%2C3.3-3.9%2C5.7c-0.5%2C2.4-0.1%2C4.8%2C1.2%2C6.8c1.3%2C2%2C3.3%2C3.4%2C5.7%2C3.9c0.6%2C0.1%2C1.3%2C0.2%2C1.9%2C0.2%0A%09C196.5%2C196.3%2C198.2%2C195.8%2C199.7%2C194.9z%20M130.3%2C394.4c0%2C4.4-3.6%2C8-8%2C8c-11.4%2C0-20.8%2C9.3-20.8%2C20.8c0%2C4.4-3.6%2C8-8%2C8s-8-3.6-8-8%0A%09c0-20.3%2C16.5-36.8%2C36.8-36.8C126.7%2C386.4%2C130.3%2C390%2C130.3%2C394.4z%20M80.3%2C423.2c0%2C4.4-3.6%2C8-8%2C8s-8-3.6-8-8c0-11.4-9.3-20.8-20.8-20.8%0A%09c-4.4%2C0-8-3.6-8-8s3.6-8%2C8-8C63.8%2C386.4%2C80.3%2C402.9%2C80.3%2C423.2z%20M80.3%2C344.4c0%2C20.3-16.5%2C36.8-36.8%2C36.8c-4.4%2C0-8-3.6-8-8s3.6-8%2C8-8%0A%09c11.4%2C0%2C20.8-9.3%2C20.8-20.8c0-4.4%2C3.6-8%2C8-8S80.3%2C340%2C80.3%2C344.4z%20M130.3%2C373.2c0%2C4.4-3.6%2C8-8%2C8c-20.3%2C0-36.8-16.5-36.8-36.8%0A%09c0-4.4%2C3.6-8%2C8-8s8%2C3.6%2C8%2C8c0%2C11.4%2C9.3%2C20.8%2C20.8%2C20.8C126.7%2C365.2%2C130.3%2C368.8%2C130.3%2C373.2z%20M54.4%2C145l11.2-11.2l-11.2-11.2%0A%09c-3.1-3.1-3.1-8.2%2C0-11.3c3.1-3.1%2C8.2-3.1%2C11.3%2C0l11.2%2C11.2L88%2C111.4c3.1-3.1%2C8.2-3.1%2C11.3%2C0c3.1%2C3.1%2C3.1%2C8.2%2C0%2C11.3l-11.2%2C11.2%0A%09L99.3%2C145c3.1%2C3.1%2C3.1%2C8.2%2C0%2C11.3c-1.6%2C1.6-3.6%2C2.3-5.7%2C2.3s-4.1-0.8-5.7-2.3l-11.2-11.2l-11.2%2C11.2c-1.6%2C1.6-3.6%2C2.3-5.7%2C2.3%0A%09c-2%2C0-4.1-0.8-5.7-2.3C51.3%2C153.2%2C51.3%2C148.1%2C54.4%2C145z%20M469.4%2C54.2c0%2C4.4-3.6%2C8-8%2C8h-3.9v3.9c0%2C4.4-3.6%2C8-8%2C8s-8-3.6-8-8v-3.9h-3.9%0A%09c-4.4%2C0-8-3.6-8-8s3.6-8%2C8-8h3.9v-3.9c0-4.4%2C3.6-8%2C8-8s8%2C3.6%2C8%2C8v3.9h3.9C465.8%2C46.2%2C469.4%2C49.7%2C469.4%2C54.2z%20M234%2C358.8%0A%09c0%2C4.4-3.6%2C8-8%2C8h-3.9v3.9c0%2C4.4-3.6%2C8-8%2C8s-8-3.6-8-8v-3.9h-3.9c-4.4%2C0-8-3.6-8-8s3.6-8%2C8-8h3.9v-3.9c0-4.4%2C3.6-8%2C8-8s8%2C3.6%2C8%2C8%0A%09v3.9h3.9C230.5%2C350.8%2C234%2C354.4%2C234%2C358.8z%22%3E%3C%2Fpath%3E%0A%3Cg%3E%0A%09%3Cpath%20fill%3D%22%23F55555%22%20class%3D%22secondary-color%22%20d%3D%22M9.4%2C48.7V26.9h250v21.8H9.4z%20M259.4%2C495.1v-21.8H9.4v21.8H259.4z%22%3E%3C%2Fpath%3E%0A%09%3Cpath%20fill%3D%22%23FCCF31%22%20class%3D%22primary-color%22%20d%3D%22M197.5%2C453.7l60.9-60.9v60.9H197.5z%22%3E%3C%2Fpath%3E%0A%3C%2Fg%3E%0A%3C%2Fsvg%3E)
%22%20d%3D%22M256.4%2C448.3l-99.8-10.5c-15.9%2C0-30.2-6.4-40.6-16.8c-10.3-10.2-16.7-24.4-16.8-40.1%0A%09c-0.3-31.9%2C26.6-42.3%2C58.4-42.3l98.9%2C2.4c34.4%2C0%2C62.4-50.1%2C62.4-84.5v-78.3c0-34.4%2C27.9-51.4%2C62.4-51.4l26.9-11v268.7%0A%09c0%2C27.2-22%2C49.2-49.2%2C63.9H256.4z%20M256.4%2C448.9%22%3E%3C%2Fpath%3E%0A%3Cpath%20d%3D%22M256.4%2C456.9c-57.1%2C0-94.1-8.4-115.2-15.5c-16.4-5.5-43.8-17.3-43.8-34.5V113.6c0-1.3%2C0.3-2.4%2C0.8-3.5%0A%09c-0.5-1.6-0.8-3.3-0.8-5.1c0-17.2%2C27.4-29%2C43.8-34.5c21-7.1%2C58.1-15.5%2C115.2-15.5c57.1%2C0%2C94.1%2C8.4%2C115.2%2C15.5%0A%09C388%2C76%2C415.4%2C87.8%2C415.4%2C105s-27.4%2C29-43.8%2C34.5c-21%2C7.1-58.1%2C15.5-115.2%2C15.5c-57.1%2C0-94.1-8.4-115.2-15.5%0A%09c-8.1-2.7-18.9-7-27.8-12.7v78.9c0.3%2C1.8%2C7.5%2C11%2C35.2%2C19.9c19.9%2C6.4%2C54.7%2C14%2C107.8%2C14c53%2C0%2C87.9-7.6%2C107.8-14%0A%09c27.5-8.9%2C34.8-18%2C35.2-19.9v-58.7c0-4.4%2C3.6-8%2C8-8s8%2C3.6%2C8%2C8v159.5c0%2C0.1%2C0%2C0.1%2C0%2C0.2c-0.4%2C17-28.1%2C28.7-44.5%2C34.2%0A%09c-21.1%2C7-58.1%2C15.4-114.4%2C15.4c-56.3%2C0-93.3-8.4-114.4-15.4c-8.3-2.8-19.5-7.1-28.5-12.9v79c0.2%2C1.7%2C7.2%2C10.9%2C34.5%2C19.8%0A%09c19.8%2C6.4%2C54.7%2C14.1%2C108.5%2C14.1s88.7-7.7%2C108.5-14.1c27.3-8.9%2C34.2-18.1%2C34.5-19.9l0-58.7c0-4.4%2C3.6-8%2C8-8s8%2C3.6%2C8%2C8V407%0A%09c0%2C17.2-27.4%2C29-43.8%2C34.5C350.6%2C448.5%2C313.5%2C456.9%2C256.4%2C456.9z%20M113.5%2C306.3c0.3%2C1.8%2C7.5%2C11%2C35.2%2C19.9c19.9%2C6.4%2C54.7%2C14%2C107.8%2C14%0A%09c53%2C0%2C87.9-7.6%2C107.8-14c27.5-8.9%2C34.8-18%2C35.2-19.9v-79c-9.1%2C5.8-20.2%2C10.2-28.5%2C12.9c-21.1%2C7-58.1%2C15.4-114.4%2C15.4%0A%09c-56.3%2C0-93.3-8.4-114.4-15.4c-8.3-2.8-19.5-7.1-28.5-12.9V306.3z%20M113.5%2C105c0.4%2C1.9%2C7.5%2C11%2C34.5%2C19.8%0A%09c19.8%2C6.4%2C54.7%2C14.1%2C108.5%2C14.1s88.7-7.7%2C108.5-14.1c27-8.8%2C34.1-17.9%2C34.5-19.8c-0.4-1.9-7.5-11-34.5-19.8%0A%09c-19.8-6.4-54.7-14.1-108.5-14.1S167.8%2C78.7%2C148%2C85.2C121%2C94%2C113.9%2C103.1%2C113.5%2C105z%22%3E%3C%2Fpath%3E%0A%3Cpath%20fill%3D%22%23000000%22%20d%3D%22M463.9%2C252.6c0%2C4.4-3.6%2C8-8%2C8h-43c-4.4%2C0-8-3.6-8-8s3.6-8%2C8-8h43C460.3%2C244.6%2C463.9%2C248.2%2C463.9%2C252.6z%0A%09%20M434.4%2C274.6h-73.8c-4.4%2C0-8%2C3.6-8%2C8s3.6%2C8%2C8%2C8h73.8c4.4%2C0%2C8-3.6%2C8-8S438.8%2C274.6%2C434.4%2C274.6z%20M483.5%2C53h-15.8V37.2%0A%09c0-4.4-3.6-8-8-8s-8%2C3.6-8%2C8V53H436c-4.4%2C0-8%2C3.6-8%2C8s3.6%2C8%2C8%2C8h15.8v15.8c0%2C4.4%2C3.6%2C8%2C8%2C8s8-3.6%2C8-8V69h15.8c4.4%2C0%2C8-3.6%2C8-8%0A%09S487.9%2C53%2C483.5%2C53z%20M54.8%2C64h-3.9v-3.9c0-4.4-3.6-8-8-8s-8%2C3.6-8%2C8V64H31c-4.4%2C0-8%2C3.6-8%2C8s3.6%2C8%2C8%2C8h3.9v3.9c0%2C4.4%2C3.6%2C8%2C8%2C8%0A%09s8-3.6%2C8-8V80h3.9c4.4%2C0%2C8-3.6%2C8-8S59.2%2C64%2C54.8%2C64z%20M50.2%2C203.2c-5.9%2C0-10.8%2C4.8-10.8%2C10.8s4.8%2C10.8%2C10.8%2C10.8s10.8-4.8%2C10.8-10.8%0A%09S56.1%2C203.2%2C50.2%2C203.2z%20M50.2%2C273.2c-5.9%2C0-10.8%2C4.8-10.8%2C10.8s4.8%2C10.8%2C10.8%2C10.8s10.8-4.8%2C10.8-10.8S56.1%2C273.2%2C50.2%2C273.2z%0A%09%20M50.2%2C334.2c-5.9%2C0-10.8%2C4.8-10.8%2C10.8s4.8%2C10.8%2C10.8%2C10.8s10.8-4.8%2C10.8-10.8S56.1%2C334.2%2C50.2%2C334.2z%22%3E%3C%2Fpath%3E%0A%3Cpath%20fill%3D%22%23FCCF31%22%20class%3D%22primary-color%22%20d%3D%22M458.4%2C429.2v-34.7H493v34.7H458.4z%20M493%2C481.4v-34.7h-34.7v34.7H493z%20M439.7%2C481.4v-34.7h-34.7v34.7H439.7z%0A%09%22%3E%3C%2Fpath%3E%0A%3C%2Fsvg%3E)
MySQL