{"id":24405,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/mysql-database-configuration-1\/"},"modified":"2025-02-17T13:00:29","modified_gmt":"2025-02-17T21:00:29","slug":"mysql-database-configuration-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/","title":{"rendered":"MySQL Database Configuration"},"content":{"rendered":"<p>The database configuration section within the <code>Configuration.properties<\/code> file initially looks like this:<\/p>\n<p><code># MySQL driver<br \/>\n#DB_URL\u00a0\u00a0\u00a0\u00a0\u00a0 = jdbc:mysql:\/\/db.yourdomain.com:3306\/evdbx?useInformationSchema=true<br \/>\n#JDBCDriver\u00a0 = com.mysql.jdbc.Driver<br \/>\n#DBMS_INTERFACE = com.extraview.dbms.mysql.MysqlDbms<br \/>\n# uncomment the next line for MySQL server to eliminate potential hangs during pool recovery<br \/>\n#DB_FORCE_CLOSE_METHOD = abortInternal<\/code><\/p>\n<p>You must uncomment the lines <code>DB_URL<\/code>, J<code>DBCDriver<\/code>, <code>DBMS_INTERFACE<\/code> and D<code>B_FORCE_CLOSE_METHOD<\/code>.\u00a0 Replace\u00a0 <code>db.yourdomain.com:3306<\/code> with the domain and port number of the database server.<\/p>\n<p>The following changes to the <b>my<\/b> configuration file must be made. On Linux systems this file is named <span class=\"fixedWidthFont\">my.cnf<\/span> and on Windows systems this file is named <span class=\"fixedWidthFont\">my.ini<\/span>.<\/p>\n<ul>\n<li>Change the default packet size for the server section <span class=\"fixedWidthFont\">[mysqld]<\/span> and the mysqlsump <span class=\"fixedWidthFont\">[mysqldump]<\/span> section.\n<p class=\"fixedWidthFont\"># change default packet size<br \/>\nmax_allowed_packet=16M<\/p>\n<p>The <span class=\"fixedWidthFont\">max_allowed_packet<\/span> size corresponds to the maximum attachment size that ExtraView will store in the database. You should change the default of 16M as appropriate for your installation, to allow larger attachments.<\/li>\n<li>Also in the <span class=\"fixedWidthFont\">[mysqld]<\/span> section we need:\n<p class=\"fixedWidthFont\">lower_case_table_names=1<\/p>\n<\/li>\n<li>Example completed <span class=\"fixedWidthFont\">[mysqld]<\/span> section tuned for ExtraView:\n<p class=\"fixedWidthFont\">[mysqld] section<br \/>\n#must have lower case table names<br \/>\nlower_case_table_names=1<br \/>\n#must have a larger packet size<br \/>\nmax_allowed_packet=16M<br \/>\n#name the transaction log file<br \/>\nlog-bin=mysql-bin<br \/>\n#need to use ROW logging to binary log, default STATEMENT does not work<br \/>\nbinlog_format=ROW<br \/>\n#turn off DNS lookup for client connections. Can slow things down<br \/>\nskip_name_resolve<\/p>\n<\/li>\n<li>Example completed <span class=\"fixedWidthFont\">[mysqldump]<\/span> section tuned for ExtraView:\n<p class=\"fixedWidthFont\">[mysqldump] section.<br \/>\n# change default packet size<br \/>\nmax_allowed_packet=16M<\/p>\n<\/li>\n<li>innodb support must be available. Make sure that the skip configuration is commented out.\n<p class=\"fixedWidthFont\">#skip-innodb<\/p>\n<\/li>\n<li>Typically you will move the database files to a location of your preference:\n<p class=\"fixedWidthFont\">#*** INNODB Specific options ***<br \/>\ninnodb_data_home_dir=&#8221;F:\/MySQL Datafiles\/&#8221;<br \/>\ndatadir=&#8221;F:\/MySQL Datafiles\/&#8221;<\/p>\n<\/li>\n<li>You should make the innodb buffer pool as large as possible on your system.\n<p class=\"fixedWidthFont\">innodb_buffer_pool_size=200M<\/p>\n<\/li>\n<li>You should now create a database user and import an initial database. This database is supplied by ExtraView Corporation. The following script will create the MySQL database user and will perform this import. Note that if any database with the given name exists, it will be dropped before the import of the new one.\n<p class=\"fixedWidthFont\">#!\/bin\/sh<br \/>\n# Import a MySQL ExtraView database from a backup<br \/>\n# Any database by the given name will be dropped first.<br \/>\n# A default user for this database will be created with the database name.<br \/>\n#<br \/>\nif [ &#8220;$#&#8221; -ne 5 ]<br \/>\nthen<br \/>\necho &#8220;usage: ImportExtraview.sh adminUser adminPassword dbname password backupname&#8221;<br \/>\nexit 1<br \/>\nfi<br \/>\nMYSQL_ADMIN=$1<br \/>\nMYSQL_ADMIN_CRED=$2<br \/>\ndbname=$3<br \/>\ndbuser=$3<br \/>\npassword=$4<br \/>\nbackupname=$5<br \/>\nif [ ! -f $backupname.sql ]<br \/>\nthen<br \/>\necho &#8220;database file does not exist&#8221;<br \/>\necho &#8220;terminating&#8230;&#8221;<br \/>\nexit 1<br \/>\nfi<br \/>\nlowdbname=&#8221;$(echo ${dbname} | tr &#8216;A-Z&#8217; &#8216;a-z&#8217;)&#8221;<br \/>\nif [ $lowdbname = mysql ]<br \/>\nthen<br \/>\necho &#8220;Cannot import to the mysql system database&#8221;<br \/>\necho &#8220;terminating&#8230;&#8221;<br \/>\nexit 1<br \/>\nfi<br \/>\ncat &gt;\/tmp\/imp_one$$.sql &lt;&lt;EOF<br \/>\ndrop database if exists $dbname;<br \/>\ncreate database $dbname default character set utf8 DEFAULT COLLATE utf8_bin;<br \/>\ngrant all on $dbname.* to &#8216;$dbuser&#8217;@&#8217;localhost&#8217; identified by &#8216;$password&#8217;;<br \/>\ngrant all on $dbname.* to &#8216;$dbuser&#8217;@&#8217;%&#8217; identified by &#8216;$password&#8217;;<br \/>\ngrant trigger on $dbname.* to &#8216;$dbuser&#8217;@&#8217;localhost&#8217;;<br \/>\ngrant trigger on $dbname.* to &#8216;$dbuser&#8217;@&#8217;%&#8217;;<br \/>\ngrant select on mysql.* to &#8216;$dbuser&#8217;@&#8217;localhost&#8217;;<br \/>\ngrant select on mysql.* to &#8216;$dbuser&#8217;@&#8217;%&#8217;;<br \/>\ngrant super on *.* to &#8216;$dbuser&#8217;@&#8217;localhost&#8217;;<br \/>\ngrant super on *.* to &#8216;$dbuser&#8217;@&#8217;%&#8217;;<br \/>\nEOF<br \/>\nmysql &#8211;user=$MYSQL_ADMIN &#8211;password=$MYSQL_ADMIN_CRED mysql &lt;\/tmp\/imp_one$$.sql<br \/>\nmysql &#8211;user=$dbuser &#8211;password=$password $dbname &lt;$backupname.sql rm \/tmp\/imp_one$$.sql<\/p>\n<h3>Attachments and MySQL Databases<\/h3>\n<p>MySQL has some special considerations regarding file attachments. MySQL is very inefficient in the way it stores attachments in the database, and the Java driver software that accesses these requires a huge amount of memory when processing large attachments. To conserve memory, the maximum size of MySQL attachments is 16 MBytes. Therefore, if you believe that you are likely to store and retrieve attachments larger than this size with the MySQL database frequently, you should configure the attachments to work with external storage, where only the limitations of the operating system apply. Alternatively, you can modify the MySQL configuration file to change the default setting, although this is more expensive in terms of memory usage.<\/p>\n<p>The configuration line is:<\/p>\n<div class=\"fixedWidthFont\">\nmax_allowed_packet=16M<\/div>\n<p>You can change the <span class=\"fixedWidthFont\">16M<\/span> value as required.<\/p>\n<h3>Timeout Setting<\/h3>\n<p>There is a MySQL default setting for <b>wait_timeout<\/b> that is likely set to 288000 (480 minutes). It is advised that this value be increased to 31536000 (365 days). ExtraView handles its own timeouts to the database.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The database configuration section within the Configuration.properties file initially looks like this: # MySQL driver #DB_URL\u00a0\u00a0\u00a0\u00a0\u00a0 = jdbc:mysql:\/\/db.yourdomain.com:3306\/evdbx?useInformationSchema=true #JDBCDriver\u00a0 = com.mysql.jdbc.Driver #DBMS_INTERFACE = com.extraview.dbms.mysql.MysqlDbms # uncomment the next line for MySQL server to eliminate potential hangs during pool recovery #DB_FORCE_CLOSE_METHOD = abortInternal You must uncomment the lines DB_URL, JDBCDriver, DBMS_INTERFACE and DB_FORCE_CLOSE_METHOD.\u00a0 Replace\u00a0 db.yourdomain.com:3306 with&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24373,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24405","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL Database Configuration - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Database Configuration - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"The database configuration section within the Configuration.properties file initially looks like this: # MySQL driver #DB_URL\u00a0\u00a0\u00a0\u00a0\u00a0 = jdbc:mysql:\/\/db.yourdomain.com:3306\/evdbx?useInformationSchema=true #JDBCDriver\u00a0 = com.mysql.jdbc.Driver #DBMS_INTERFACE = com.extraview.dbms.mysql.MysqlDbms # uncomment the next line for MySQL server to eliminate potential hangs during pool recovery #DB_FORCE_CLOSE_METHOD = abortInternal You must uncomment the lines DB_URL, JDBCDriver, DBMS_INTERFACE and DB_FORCE_CLOSE_METHOD.\u00a0 Replace\u00a0 db.yourdomain.com:3306 with...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-17T21:00:29+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/\",\"name\":\"MySQL Database Configuration - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-17T21:00:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Installation &#038; Upgrade Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Software Installation &#038; Upgrades\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"MySQL Database Configuration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Database Configuration - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Database Configuration - Product Documentation","og_description":"The database configuration section within the Configuration.properties file initially looks like this: # MySQL driver #DB_URL\u00a0\u00a0\u00a0\u00a0\u00a0 = jdbc:mysql:\/\/db.yourdomain.com:3306\/evdbx?useInformationSchema=true #JDBCDriver\u00a0 = com.mysql.jdbc.Driver #DBMS_INTERFACE = com.extraview.dbms.mysql.MysqlDbms # uncomment the next line for MySQL server to eliminate potential hangs during pool recovery #DB_FORCE_CLOSE_METHOD = abortInternal You must uncomment the lines DB_URL, JDBCDriver, DBMS_INTERFACE and DB_FORCE_CLOSE_METHOD.\u00a0 Replace\u00a0 db.yourdomain.com:3306 with...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-17T21:00:29+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/","name":"MySQL Database Configuration - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-17T21:00:29+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/mysql-database-configuration-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Installation &#038; Upgrade Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/"},{"@type":"ListItem","position":4,"name":"Software Installation &#038; Upgrades","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/"},{"@type":"ListItem","position":5,"name":"MySQL Database Configuration"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24405"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24405\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24373"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}