Beside modifying the schema, I was also looking at tuning queries, so I discovered an article (1) on Databasejournal’s site about “PostgreSQL SQL Analysis” which was exactly what I needed. I was playing around with phpBB on PostgreSQL and looking at how it’s database schema is not optimized for PostgreSQL or other real databases (it does not implement foreign keys and other niceties …) but it’s really built with MySQL’s older versions in mind. Innodb_log_group_home_dir="D:/MySQL InnoDBLogfiles/" #change this if you want to relocate InnoDB transaction logs to a new directory Innodb_data_home_dir="D:/MySQL InnoDBDatafiles/" # change this if you want to relocate InnoDB datafiles to a new directory # The default storage engine that will be used when you create new tables Ssl-key=C:/CA/temp/mysql_server/server.key Ssl-cert=C:/CA/temp/mysql_server/server.pem #SSL certificate of the Certification Authority #example of variables that need to be set to obtain SSL encrypted connections between client and #server #some examples of variables that influence full text indexing and searchįt_stopword_file=C:/mysql/stopwordfiles/italianST.txt #change this if you want to relocate data to a new directory for MyISAM (table definitions and data) and InnoDB (table definitions) #contains a wrong query connection will close). #note that if a user has SUPER privilege init_connect will NOT execute (because if init_connect #this makes MySQL behave like Oracle and other databases, you'll have to commit to save data #The server's default max_allowed_packet value is 1MB #under this section you’ll find all server parameters #to use something bigger you'll have to set it on server and client #the client's default max_allowed_packet value is 16MB #max allowed packet size useful if you need to run large scripts Ssl-key=C:/CA/temp/mysql_client/client.key Ssl-cert=C:/CA/temp/mysql_client/client.pem #SSL certificate of the Certification authority #example of variables that need to be set to obtain SSL encrypted connections between client and server, these are the client settings of course #client will connect to server using this port as default
#by setting this your mysql client (tipically the command line tool) will connect using this password as default #by setting this your mysql client (tipically the command line tool) will connect using this username as default #under this section you’ll find all client parameters please note that this is work in progress!!
Infact, while some commented examples are provided by MySQL AB and some others can be found on the net, I think that there is not an attempt to collect all available options into one file. While at Devshed Forums I noticed the need for an example my.ini (or my.cnf) file with all available options set and proper comments.
0 kommentar(er)
