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:32] – juckins
Line 19: Line 19:
   thread_handling = pool-of-threads   thread_handling = pool-of-threads
      
-Then do: systemctl restart mariadb.service+Then do: ''systemctl restart mariadb.service''
  
   * Other commands to check and modify on mariadb server:   * Other commands to check and modify on mariadb server:
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