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 revision		Previous revision
Next revisionBoth sides next revision
centos_7_migration_notes [2022/05/18 13:31] – juckinscentos_7_migration_notes [2022/05/18 13:36] – 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
 +    * 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: 2023/12/14 10:10 by juckins