Further steps for troubleshooting

•

If a single directory or path is not in sync with the file system, then you can run this command to force a sync on that path:

Unix: /usr/etc/venture/bin/syncvoltodb -delnorm path_to_dir

Windows: \Program Files\Xinet\Venture\Bin\syncvoltodb.exe -delnorm
path_to_dir

If this fails, syncvoltodb(8) will write errors into the Xinet venture.log file. These can be valuable as they may indicate why a particular path cannot be brought into sync with the file system.

Important note: If the path on which you are running a syncvoltodb(8) process is not the path to the top level of the volume, then the -dir flag should be added to the command above, just after syncvoltodb.

•

How do I turn off the database (briefly)?

Sometimes, the only way to determine if a problem is Xinet related is to briefly shutdown its database. It is always best to do this from the Xinet Administration view via your browser. Go to the Database, Admin, Settings page and click the Stop Database button. Restart the database from this same location when you are done.

Alternately, you can shutdown the database on the command-line using the dbmgr(8) program:

Unix: /usr/etc/venture/bin/dbmgr -shutdown

Windows: \Program Files\Xinet\Venture\Bin\dbmgr.exe -shutdown

To restart, simply substitute the word restart for shutdown above.

•

How do I see what mysqld is processing right now?

A very simple way to monitor the database is to use MySQL’s processlist command. This can be done from the command-line only—either from within the database “client” itself, or alone using the mysqldmin program. Directions for each method follow:

Unix: /usr/etc/venture/bin/mysqladmin -u root
-proot_password processlist

Windows: \Program Files\Xinet\Venture\Bin\mysqladmin.exe
-u root -pPASSWORD processlist

The commands listed above will give you a grid in which the running process at that moment in time is displayed (in other words, this utility does not provide dynamically-updated output).

You can also get a more detailed list from within the client, as follows:

Unix: /usr/etc/venture/bin/mysql -u root -p
At the Enter password: prompt, type the root password
After login in, type: use webnative;
show processlist;

For added detail, type: show full processlist;

Windows: \Program Files\Xinet\Venture\Bin\mysql -u root -p
At the Enter password: prompt, type the password
After login in, type: use webnative;
show processlist;
For added detail, type: show full processlist;

•

How do I get a “status report” on the database?

Using the mysqladmin command, you can request a report on the status of the database which will provide the information listed below. This can be useful for day-to-day monitoring of the database, but more likely, can be referred to in the event that the speed at which the database responds to queries is slow.

Unix: /usr/etc/venture/bin/mysqladmin -u root
-proot_password status

Windows: \Program Files\Xinet\Venture\Bin\mysqladmin.exe
-u root -pPASSWORD status

The utility will report something like this:

Uptime: 530 Threads: 2 Questions: 9 Slow queries:
0 Opens: 10 Flush tables: 1 Open tables: 4 Queries
per second avg: 0.017

The variables have the following meanings:

Uptime = database uptime (in seconds)
Threads = current number of clients connected to the database
Questions = number of clients connected since the database was
started
Slow queries = the total number of queries that have taken more
than 10 seconds to be answered
Opens = number of open tables since the database was
started
Flush tables = the number of flushed tables
Open tables = the number of currently open tables

Please refer to the MySQL Web site at www.mysql.com for more information on these variables and how they relate to database performance.