26 Matching Annotations
  1. Sep 2023
  2. Jul 2023
    1. Create a mosaic of an images like what MPC-HC does.

    2. screenshot-mosaic

      a

    3. To download, open the dist folder and just put the .js file into your scripts folder.

      a

  3. May 2023
  4. Apr 2023
  5. Mar 2023
    1. Section 5.4.4, “The Binary Log”.

      a

    2. Beginning a transaction causes any pending transaction to be committed. See Section 13.3.3, “Statements That Cause an Implicit Commit”

      a

    3. completion_type system variable

      a

    4. autocommit is a session variable and must be set for each session. To disable autocommit mode for each new connection, see the description of the autocommit system variable

      a

    5. Section 15.7.2.3, “Consistent Nonlocking Reads”.

      a

    6. Section 13.3.7, “SET TRANSACTION Statement”.

      a

    7. Specifying READ ONLY ensures these optimizations are applied in cases where the read-only status cannot be determined automatically. See Section 8.5.3, “Optimizing InnoDB Read-Only Transactions”

      a

    8. To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION

      sql START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT;

    9. These statements provide control over use of transactions:

      ```sql START TRANSACTION [transaction_characteristic [, transaction_characteristic] ...]

      transaction_characteristic: { WITH CONSISTENT SNAPSHOT | READ WRITE | READ ONLY }

      BEGIN [WORK] COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE] ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE] SET autocommit = {0 | 1} ```

  6. Feb 2023
  7. Jan 2023