MySQL Questions

[McCully, Dwayne (NIH/NIAMS) [C]]

What should be the MySQL setting for the following variables that support the USCS Genome Browser?

 

character-set-server=

collation-server=

 

Is it possible to get a copy of a servers my.cnf configuration file?

 

Dwayne

[Jairo Navarro Gonzalez]

Hello Dwayne,

Thank you for using the UCSC Genome Browser and your question about configuring your MySQL variables. 
We have not set the "character-set-server" or the "collation-server" variables on our MySQL server and are just using the defaults.

These settings were recommended by one of our engineers: 

[mysqld]
default-storage-engine = MyISAM
default-tmp-storage-engine = MyISAM
sql_mode=""

You could also query our public MySQL server to see all of its variables with the following command:

mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -e 'show variables;' hg38

I hope this is helpful. If you have any further questions, please reply 
to genome...@soe.ucsc.edu. All messages sent to that address are archived 
on a publicly-accessible Google Groups forum. If your question includes 
sensitive data, you may send it instead to genom...@soe.ucsc.edu.

Jairo Navarro 
UCSC Genomics Institute

--

---
You received this message because you are subscribed to the Google Groups "UCSC Genome Browser mirror site discussion list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to genome-mirror+unsubscribe@soe.ucsc.edu.