Administration Guide : Troubleshooting the Xinet database : Further steps for troubleshooting

Further steps for troubleshooting
More questions to consider:
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
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.
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;
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
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
Flush tables = the number of flushed tables
Open tables = the number of currently open tables
Please refer to the MySQL Web site at for more information on these variables and how they relate to database performance.