Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


centos_7_migration_notes

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
centos_7_migration_notes [2022/05/18 13:32]
juckins
centos_7_migration_notes [2022/05/18 13:36] (current)
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+    * I have noted that opening and closing the database connection only once in the python script helps reduce database "cannot assign requested address" errors
   * [[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: 2022/05/18 13:36 by juckins