Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools

Trace:
centos_7_migration_notes

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
centos_7_migration_notes [2022/05/18 13:31] – juckinscentos_7_migration_notes [2022/05/18 13:32] – juckins
Line 29: Line 29:
   * See https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/   * See https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/
   * Also check python3 coding best practices for opening/closing database connections   * Also check python3 coding best practices for opening/closing database connections
 +    * Open and close the database connection only once in the python script
   * [[https://pypi.org/project/mysqlclient/|mysqlclient]] is supposedly [[https://stackoverflow.com/questions/43102442/whats-the-difference-between-mysqldb-mysqlclient-and-mysql-connector-python|faster than alternatives]]   * [[https://pypi.org/project/mysqlclient/|mysqlclient]] is supposedly [[https://stackoverflow.com/questions/43102442/whats-the-difference-between-mysqldb-mysqlclient-and-mysql-connector-python|faster than alternatives]]
       * import MySQLdb       * import MySQLdb
centos_7_migration_notes.txt · Last modified: 2023/12/14 10:10 by juckins