Search Our Knowledge Base

Recent Articles 1 - 15 of 16 Total in "MySQL"

Variphy Call Analytics Reports Fail to Run due to MYSQL password expiration

Created by brian on Nov 15, 2016 and last updated on Oct 24, 2017 in Category: MySQL

PROBLEM: After installing MySQL 5.7.x, the root password will expire (default is 360 days). When this happens, Variphy will not be able to run queries or do data inserts on the database.   SYMPTOMS: The following issues will arise when this condition occurs. 1) Any Call analytics reports run... Read More >

How to Increase MySQL Buffer Pool Memory Usage

Created by MySQL Guru on May 1, 2013 and last updated on May 18, 2017 in Category: MySQL

When Variphy Insight's Call Data searches become very slow, it is often caused by a shortage of available memory on the SQL database server. This typically happens when the size of the database outgrows the ammount of memory made avaialable to cache it. The larger the ratio of database size to datab... Read More >

Migrating MySQL DB Using mysqldump (Linux to Linux OVA)

Created by edgar on May 9, 2016 and last updated on Mar 28, 2017 in Category: MySQL

Be aware that we discourage the migration of MySQL to MSSQL and vice versa.  Our documentation is written on the assumption of migration to a similar platform and architecture.   PREPARE SOURCE MYSQL SERVER: Step 1. Login via SSH to Insight Server Step 2.  Identify DB: ... Read More >

How to enable connections to MySQL from Remote Machine

Created by mysql-guru on Sep 20, 2013 and last updated on Feb 17, 2017 in Category: MySQL

MySQL considers connections from the same local machine different than connections from a remote machine, even if using the same root user and password.   When installing and configuring MySQL, the root account and password being setup is by default, only for connections from the same server t... Read More >

Dump and Reload MySQL Buffer Pool Data Upon Shutdown and Startup

Created by layne on Sep 15, 2016 and last updated on Sep 15, 2016 in Category: MySQL

MySQL performs best with all (or at least most) of its data cached in its buffer pool(s).  For larger systems, this can often mean that there are many GBs of data cached.   If MySQL is restarted, for example as part of a server maintenance reboot, it can often take considerable time to lo... Read More >

Migrating MySQL DB Using MySQL Workbench (Windows to Linux OVA)

Created by edgar on Jan 29, 2016 and last updated on Jun 3, 2016 in Category: MySQL

Be aware that we discourage the migration of MySQL to MSSQL and vice versa.  Our documentation is written on the assumption of migration to a similar platform and architecture.   PREPARE DESTINATIN MYSQL SERVER: Step 1. Login via SSH to Insight Server Step 2. Navigate to locat... Read More >

How To Determine If MySQL installed is 32 or 64 bit version

Created by MySQL Guru on May 8, 2013 and last updated on Dec 11, 2015 in Category: MySQL

On Windows, locate the folder where the file "mysqld.exe" exist - it is often in the folder "C:Program Files>MySQL>MySQL Server 5.6>bin" Open the command prompt in Windows Click Start and enter 'cmd' in the Run window In the command window, change the working directory to that of where t... Read More >

Mac OS X - Reset MySQL Root Password

Created by edgar on Mar 5, 2015 and last updated on Jul 23, 2015 in Category: MySQL

Have you forgotten your Mac OS X 'ROOT' password  and need to reset it?  Follow these 4 simple steps: 1.  Stop the mysqld server.  Typically this can be done by from 'System Prefrences' > MySQL > 'Stop MySQL Server' 2.  Start the server in safe mode with privilege by... Read More >

MySQL CDR Database Zero-Duration cleanup procedure

Created by brian on Jul 3, 2015 and last updated on Jul 17, 2015 in Category: MySQL

Problem When customers keep CDR data for several months or longer, the database may grow very large, overtaking the system memory available to cache search results, which can result in increasingly poor search performance. Often this database “bloating” is caused by a large amount of ze... Read More >

Move MySQL Database File Storage Location to different drive/partition

Created by MySQL Guru on May 17, 2013 and last updated on Oct 7, 2014 in Category: MySQL

As more CDR/CMR data is created by CUCM and saved by Variphy CDR Manager, the database storage files for MySQL can become large in size and consume disk space, particularly if located on the C drive/partition.  It's recommended to store the database files on a 'data' partition (such as the D or... Read More >

Reset Root Password for MySQL

Created by brian on Jan 27, 2014 and last updated on Jul 18, 2014 in Category: MySQL

If you can no longer access the CDR database in MySQL and do not have a working root account password, the root account may be reset via the following instructions (note: applies to MySQL 5.6, consult the appropriate MySQL user manual for older versions):   On Windows, use the following... Read More >

MySQL Configuration Variables To Adjust

Created by MySQL Guy on Mar 14, 2014 and last updated on Mar 15, 2014 in Category: MySQL

Within the [mysqld] section: max_allowed_packet=100M innodb_lock_wait_timeout=120 In running config (via MySQL cmd line or workbench): SET GLOBAL max_allowed_packet=104857600; SET GLOBAL innodb_lock_wait_timeout = 120;  Background According to MySQL discussion forums, a max_allowed_... Read More >

MySQL won't install on HP Server

Created by brian on Dec 3, 2013 and last updated on Dec 3, 2013 in Category: MySQL

ISSUE: When installing MySQL on HP desktop or Server platforms, the installation may fail. A check of the MySQL install logs or Windows Application logs will show an error indicating the following: "Could not access network location Hewlett-Packard\"   CAUSE:  This problem stems from ... Read More >

Increase Max Connections Setting for MySQL

Created by mysql-guru on Sep 19, 2013 and last updated on Oct 21, 2013 in Category: MySQL

In environments with multiple clusters, an HTTP 500 error may be thrown by Apache Tomcat when trying to access clusters in the Call Usage tab. This may be caused by too many connections trying to access the MySQL database at once (the default number is set to 100).  There is a 'max_connections... Read More >

Locate MySQL Configuration File

Created by MySQL Guru on Apr 18, 2013 and last updated on Oct 3, 2013 in Category: MySQL

On Windows MySQL starts up with configurations defined in a file named "my.ini".  To find where the active "my.ini" configuration file is located on the Windows Server: Open Windows Services (e.g. start --> run --> "services.msc") Find the appropriate MySQL Service entry (e.g. "MySQL"... Read More >

View More >
Variphy UC Tools & Analytics is trusted and used by thousands of organizations & Cisco Unified Communications/Collaboration engineers
Providing leading edge UC Management Tools to over 1200 organizations worldwide