...
| Bloc de code | ||
|---|---|---|
| ||
+--------------------------+---------------------------------------------+ | Variable_name | Value | +--------------------------+---------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | D:\ESUP\mysql-5.5.29-winx64\share\charsets\ | +--------------------------+---------------------------------------------+ 8 rows in set (0.00 sec) +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_unicode_ci | | collation_server | utf8_unicode_ci | +----------------------+-----------------+ 3 rows in set (0.00 sec) |
Mise à jour de la propriété "maxThreads"
Dans le fichier "uportal-war/src/main/resources/properties/portal.properties", modifier la valeur de la clé "org.jasig.portal.io.threadPool.maxThreads" :
| Bloc de code |
|---|
org.jasig.portal.io.threadPool.maxThreads=1
|
Performances
Les performances seront meilleures si les réglages suivants sont effectués dans le fichier my.ini :
| Bloc de code |
|---|
max_connections = 1500 table_cache = 512 query_cache_size = 128M set-variable = innodb_buffer_pool_size=128M set-variable = innodb_log_file_size=256M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_log_buffer_size=4M innodb_flush_log_at_trx_commit=1 |
Deadlocks
TODO : faire cette partie plus en détails : Cf. le wiki de JASIG
Deadlock troubleshooting
One thing that will most likely come up in working with uPortal and MySQL (or any database for that matter) is the issue of deadlocks - when a record is needed to be accessed by two different queries at the same time.
The MySQL site has an EXCELLENT chapter on dealing with these. Overall, the on-line reference guide for MySQL is an EXCELLENT resource.
| Info | ||
|---|---|---|
| ||
https://wiki.jasig.org/display/UPM40/MySQL |