Solved

mysql create table won't replicate to slave

Posted on 2009-05-19
7
2,117 Views
Last Modified: 2012-05-07
Warning: I am not a db admin just a simple person with a need for a database so please excuse...

I have successfully set up a master-slave outfit. however when trying to create new tables on the master using a join per code below, the statement does not get replicated to the slave even though It succeeds on the master. Am I missing something obvious? If not I will be happy to provide any supporting info to get to the bottom of this.

Thanks,
Joel

use mydb;
 
create table mydb.table_tmp_1 select * from mydb.table where field.1 = 1;
ALTER TABLE mydb.table_tmp_1 ADD INDEX datetime(datetime);
 
create table mydb.table1_tmp_1 select * from mydb.table1 where field.2 = 1;
ALTER TABLE mydb.table1_tmp_1 ADD INDEX datetime(datetime);
 
create table mydb.table_1
select mydb.table_tmp_1.id,mydb.table_tmp_1.timestamp,mydb.table_tmp_1.QAQC,mydb.table_tmp_1.datetime,mydb.table_tmp_1.cond,mydb.table_tmp_1.do,mydb.table_tmp_1.ph,mydb.table_tmp_1.rw,mydb.table_tmp_1.sw,mydb.table_tmp_1.temp,mydb.table1_tmp_1.orp,mydb.table1_tmp_1.turb,mydb.table1_tmp_1.press
from mydb.table_tmp_1 left join mydb.table1_tmp_1
on mydb.table_tmp_1.datetime = mydb.table1_tmp_1.datetime
group by mydb.table_tmp_1.datetime;
 
drop table mydb.table_tmp_1;
drop table mydb.table1_tmp_1;

Open in new window

0
Comment
Question by:panguluri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 26

Expert Comment

by:Umesh
ID: 24431880
Pls can you post mysql config file? (my.cnf for linux/unix and my.ini incase fo windows)
Also check what is value set for sync_binlog variables

show global variables like 'sync_binlog';
0
 

Author Comment

by:panguluri
ID: 24432207
Here is the requested info.
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
 
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
 
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0
 
 
 
 
[mysqld]
#
# * Basic Settings
#
 
#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#
 
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 128K
thread_cache_size	= 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover		= BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log		= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
log_error		=/var/log/mysql/mysql-error
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
server-id		= 2
log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Federated
#
# The FEDERATED storage engine is disabled since 5.0.67 by default in the .cnf files
# shipped with MySQL distributions (my-huge.cnf, my-medium.cnf, and so forth).
#
skip-federated
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
 
lower_case_table_names=1
#The size of the buffer that is used for full joins.
join_buffer_size=2M
 
[mysqldump]
quick
quote-names
max_allowed_packet	= 16M
 
[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
 
[isamchk]
key_buffer		= 16M
 
#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1
 
 
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
 
 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 538
Server version: 5.1.31-1ubuntu2-log (Ubuntu)
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> 
mysql> show global variables like 'sync_binlog';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sync_binlog   | 0     | 
+---------------+-------+
1 row in set (0.00 sec)

Open in new window

0
 
LVL 26

Expert Comment

by:Umesh
ID: 24432289
My bad... I need both Master and slaves my.cnf
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:panguluri
ID: 24432603
Note, the master is running on Windows 2k Server.  Maybe an important omission?
here is master my.ini
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:\mysql\data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
 
# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock
 
# Here follows entries for some specific programs
 
# The MySQL server
[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
 
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking
 
# Disable Federated by default
skip-federated
 
# Replication Master Server (default)
# binary logging is required for replication
log-bin=esf-binary
 
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 1
 
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
#
# binary logging format - mixed recommended 
#binlog_format=mixed
 
# Point the following paths to different dedicated disks
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/mysql-5.1.34-win32/"
#Path to the database root
datadir=E:/MySQL/Data/
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname
 
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\mysql\data/
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 384M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 100M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
 
[mysqldump]
quick
max_allowed_packet = 16M
 
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
 
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
 
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
 
[mysqlhotcopy]
interactive-timeout

Open in new window

0
 
LVL 26

Expert Comment

by:Umesh
ID: 24432941
Pls provide both Master and Slaves config file... You have posted 2 config files... which one is Master's and which one is Slaves?... pls post as

===============Master's config file =====================


===============Slaves's config file =====================

and also error logs from both master and slave servers
0
 

Author Comment

by:panguluri
ID: 24435007
The first posted config file is the slave and the second the master.  Per your request see below.  The slave error log is empty.
===============Master's config file =====================
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:\mysql\data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
 
# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock
 
# Here follows entries for some specific programs
 
# The MySQL server
[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
 
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking
 
# Disable Federated by default
skip-federated
 
# Replication Master Server (default)
# binary logging is required for replication
log-bin=esf-binary
 
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 1
 
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
#
# binary logging format - mixed recommended 
#binlog_format=mixed
 
# Point the following paths to different dedicated disks
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/mysql-5.1.34-win32/"
#Path to the database root
datadir=E:/MySQL/Data/
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname
 
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\mysql\data/
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 384M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 100M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
 
[mysqldump]
quick
max_allowed_packet = 16M
 
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
 
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
 
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
 
[mysqlhotcopy]
interactive-timeout
 
 
===============Slaves's config file =====================
 
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
 
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
 
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0
 
 
 
 
[mysqld]
#
# * Basic Settings
#
 
#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#
 
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 128K
thread_cache_size	= 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover		= BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log		= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
log_error		=/var/log/mysql/mysql-error
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
server-id		= 2
log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Federated
#
# The FEDERATED storage engine is disabled since 5.0.67 by default in the .cnf files
# shipped with MySQL distributions (my-huge.cnf, my-medium.cnf, and so forth).
#
skip-federated
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
 
lower_case_table_names=1
#The size of the buffer that is used for full joins.
join_buffer_size=2M
 
[mysqldump]
quick
quote-names
max_allowed_packet	= 16M
 
[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
 
[isamchk]
key_buffer		= 16M
 
#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1
 
 
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
 
 
=======================Master Error Log===========================
 
090204 12:27:28 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect key file for table 'C:\WINNT\TEMP\#sql_2ec_0.MYI'; try to repair it
090204 12:27:31 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect key file for table 'C:\WINNT\TEMP\#sql_2ec_0.MYI'; try to repair it
090204 12:29:23 [ERROR] Error writing file 'dataserver-slow.log' (errno: 1)
090204 12:32:03 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86096  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86095  user: 'root'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86089  user: 'root'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86077  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86076  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86075  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86074  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86073  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86060  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86059  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86058  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86057  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86056  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 85801  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 85679  user: 'ichart'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2406  user: 'camile'
 
090204 12:39:41  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090204 12:39:42  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 2 1699339505.
InnoDB: Doing recovery: scanned up to log sequence number 2 1699339505
InnoDB: 10 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 26 row operations to undo
InnoDB: Trx id counter is 0 18721024
InnoDB: Last MySQL binlog file position 0 3412817, file name .\esf-binary.000216
InnoDB: Starting in background the rollback of uncommitted transactions
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720497, 1 rows to undo
090204 12:39:43  InnoDB: Started; log sequence number 2 1699339505
090204 12:39:43 [Note] Recovering after a crash using esf-binary
 
InnoDB: Rolling back of trx id 0 18720497 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720496, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720496 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720495, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720495 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720494, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720494 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720468, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720468 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720463, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720463 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720462, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720462 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720461, 2 rows to undo
 
InnoDB: Rolling back of trx id 0 18720461 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720460, 9 rows to undo
 
InnoDB: Rolling back of trx id 0 18720460 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720459, 8 rows to undo
 
InnoDB: Rolling back of trx id 0 18720459 completed
090204 12:39:43  InnoDB: Rollback of non-prepared transactions completed
090204 12:39:44 [Note] Starting crash recovery...
090204 12:39:44 [Note] Crash recovery finished.
090204 12:39:45 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090205 10:33:16 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090205 10:33:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1656  user: 'camile'
 
090205 10:33:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1  user: 'ichart'
 
090205 10:33:18  InnoDB: Starting shutdown...
090205 10:33:21  InnoDB: Shutdown completed; log sequence number 2 1701858998
090205 10:33:21 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090205 11:54:41  InnoDB: Started; log sequence number 2 1701858998
090205 11:54:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090217  8:42:35 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090217  8:42:37 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 24760  user: 'ichart'
 
090217  8:42:37  InnoDB: Starting shutdown...
090217  8:42:40  InnoDB: Shutdown completed; log sequence number 2 1735299691
090217  8:42:40 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090217  8:45:32  InnoDB: Started; log sequence number 2 1735299691
090217  8:45:33 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090318 14:34:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090318 14:34:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 50975  user: 'jcarson'
 
090318 14:34:38  InnoDB: Starting shutdown...
090318 14:34:41  InnoDB: Shutdown completed; log sequence number 2 1826739394
090318 14:34:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090318 14:38:35  InnoDB: Started; log sequence number 2 1826739394
090318 14:38:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090318 15:07:11 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090318 15:07:13  InnoDB: Starting shutdown...
090318 15:07:15  InnoDB: Shutdown completed; log sequence number 2 1826764200
090318 15:07:15 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090318 15:10:21  InnoDB: Started; log sequence number 2 1826764200
090318 15:10:26 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090325 11:35:38 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090325 11:35:40 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 52392  user: 'camile'
 
090325 11:35:40  InnoDB: Starting shutdown...
090325 11:35:43  InnoDB: Shutdown completed; log sequence number 2 1834949108
090325 11:35:43 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090325 11:38:35  InnoDB: Started; log sequence number 2 1834949108
090325 11:38:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090420  7:35:38 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090420  7:35:38  InnoDB: Starting shutdown...
090420  7:35:42  InnoDB: Shutdown completed; log sequence number 2 1909330530
090420  7:35:42 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090420  7:38:35  InnoDB: Started; log sequence number 2 1909330530
090420  7:38:35 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090421 15:36:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090421 15:36:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2777  user: 'root'
 
090421 15:36:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2766  user: 'root'
 
090421 15:36:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2541  user: 'root'
 
090421 15:36:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2336  user: 'root'
 
090421 15:36:38  InnoDB: Starting shutdown...
090421 15:36:41  InnoDB: Shutdown completed; log sequence number 2 1911987239
090421 15:36:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090421 15:40:58  InnoDB: Started; log sequence number 2 1911987239
090421 15:40:58 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090421 15:41:57 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090421 15:41:59 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2  user: 'root'
 
090421 15:41:59 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1  user: 'root'
 
090421 15:41:59  InnoDB: Starting shutdown...
090421 15:42:02  InnoDB: Shutdown completed; log sequence number 2 1911987249
090421 15:42:02 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
MySQL: Unknown error 1146
090421 15:54:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090421 15:54:52  InnoDB: Started; log sequence number 2 1911987249
090421 15:54:52 [ERROR] Aborting
 
090421 15:54:52  InnoDB: Starting shutdown...
090421 15:54:53  InnoDB: Shutdown completed; log sequence number 2 1911987249
090421 15:54:53 [Warning] Forcing shutdown of 1 plugins
090421 15:54:53 [Note] 
090421 16:08:11  InnoDB: Started; log sequence number 2 1911987249
090421 16:08:11 [Note] MySQL: ready for connections.
Version: '5.0.18-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090422 10:08:25 [Note] MySQL: Normal shutdown
 
090422 10:08:27 [Warning] MySQL: Forcing close of thread 1441  user: 'root'
 
090422 10:08:27 [Warning] MySQL: Forcing close of thread 1282  user: 'camile'
 
090422 10:08:27  InnoDB: Starting shutdown...
090422 10:08:29  InnoDB: Shutdown completed; log sequence number 2 1944582166
090422 10:08:29 [Note] MySQL: Shutdown complete
 
090422 11:45:07  InnoDB: Started; log sequence number 2 1944586335
090422 11:45:08 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: ready for connections.
Version: '5.0.18-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090422 11:47:01 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: Normal shutdown
 
090422 11:47:01  InnoDB: Starting shutdown...
090422 11:47:03  InnoDB: Shutdown completed; log sequence number 2 1944586335
090422 11:47:03 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: Shutdown complete
 
090422 11:48:36  InnoDB: Started; log sequence number 2 1944586335
090422 11:48:36 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: ready for connections.
Version: '5.0.18-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090422 13:13:40 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: Normal shutdown
 
090422 13:13:40  InnoDB: Starting shutdown...
090422 13:13:44  InnoDB: Shutdown completed; log sequence number 2 1944657298
090422 13:13:44 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: Shutdown complete
 
090422 15:00:46  InnoDB: Started; log sequence number 2 1944661461
090422 15:00:46 [Note] Event Scheduler: Loaded 0 events
090422 15:00:46 [Note] MySQL: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:08:13 [Note] MySQL: Normal shutdown
 
090422 15:08:13 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:08:13  InnoDB: Starting shutdown...
090422 15:08:16  InnoDB: Shutdown completed; log sequence number 2 1944669767
090422 15:08:16 [Warning] Forcing shutdown of 1 plugins
090422 15:08:16 [Note] MySQL: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:08:21 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:08:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:08:21 [Note] Event Scheduler: Loaded 0 events
090422 15:08:21 [Note] MySQL: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:16:40 [Note] MySQL: Normal shutdown
 
090422 15:16:40 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:16:42 [Warning] MySQL: Forcing close of thread 10  user: 'root'
 
090422 15:16:42 [Warning] Forcing shutdown of 1 plugins
090422 15:16:42 [Note] MySQL: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:18:09 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:18:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:18:09 [Note] Event Scheduler: Loaded 0 events
090422 15:18:09 [Note] MySQL: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:24:52 [Note] MySQL: Normal shutdown
 
090422 15:24:52 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:24:52 [Warning] Forcing shutdown of 1 plugins
090422 15:24:52 [Note] MySQL: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:24:56 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:24:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:24:56 [Note] Event Scheduler: Loaded 0 events
090422 15:24:56 [Note] MySQL: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:25:17 [Note] MySQL: Normal shutdown
 
090422 15:25:17 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:25:17 [Warning] Forcing shutdown of 1 plugins
090422 15:25:17 [Note] MySQL: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:27:43 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:27:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:27:43 [Note] Event Scheduler: Loaded 0 events
090422 15:27:43 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:38:24 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Normal shutdown
 
090422 15:38:24 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:38:24 [Warning] Forcing shutdown of 1 plugins
090422 15:38:24 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:40:35 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:40:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:40:35 [Note] Event Scheduler: Loaded 0 events
090422 15:40:35 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:42:00 [Warning] Statement is not safe to log in statement format. Statement: ALTER TABLE general_log MODIFY COLUMN server_id INTEGER UNSIGNED NOT NULL
090422 15:42:00 [Warning] Statement is not safe to log in statement format. Statement: ALTER TABLE slow_log MODIFY COLUMN server_id INTEGER UNSIGNED NOT NULL
090422 15:43:34 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Normal shutdown
 
090422 15:43:34 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:43:34 [Warning] Forcing shutdown of 1 plugins
090422 15:43:34 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 16:53:29 [ERROR] Plugin 'InnoDB' init function returned error.
090422 16:53:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 16:53:29 [Note] Event Scheduler: Loaded 0 events
090422 16:53:29 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 16:54:22 [Warning] Statement is not safe to log in statement format. Statement: ALTER TABLE general_log MODIFY COLUMN server_id INTEGER UNSIGNED NOT NULL
090422 16:54:22 [Warning] Statement is not safe to log in statement format. Statement: ALTER TABLE slow_log MODIFY COLUMN server_id INTEGER UNSIGNED NOT NULL
090427  9:33:00 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Normal shutdown
 
090427  9:33:00 [Note] Event Scheduler: Purging the queue. 0 events
090427  9:33:02 [Warning] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Forcing close of thread 9255  user: 'root'
 
090427  9:33:02 [Warning] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Forcing close of thread 9077  user: 'camile'
 
090427  9:33:02 [Warning] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Forcing close of thread 3744  user: 'root'
 
090427  9:33:02 [Warning] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Forcing close of thread 191  user: 'camile'
 
090427  9:33:02 [Warning] Forcing shutdown of 1 plugins
090427  9:33:02 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090427  9:46:17 [ERROR] Plugin 'InnoDB' init function returned error.
090427  9:46:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090427  9:46:17 [Note] Event Scheduler: Loaded 0 events
090427  9:46:17 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090505  7:42:25 [ERROR] Plugin 'InnoDB' init function returned error.
090505  7:42:25 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090505  7:42:26 [Note] Event Scheduler: Loaded 0 events
090505  7:42:26 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

Open in new window

0
 

Accepted Solution

by:
panguluri earned 0 total points
ID: 24441225
ok, I think I got it now. Rick James of the mysql forum helped to figure out my issue. Once I cleared the slave errors and reexecuted the script everything worked. I'll chalk this one up to ignorance/inexperience.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question