List:General Discussion« Previous MessageNext Message »
From:jidanni Date:March 24 2009 12:21pm
Subject:SHOW TABLE STATUS constantly wildly fluctuating
View as plain text  
$ watch -d mysqlshow --status myDB #shows the count of rows is
constantly fluctuating for some tables, even though the database is
offline. There ought to be a note about it here and on HELP SHOW TABLE STATUS;
Must use
       o  --count
          Show the number of rows per table.
(Which also should mention that it also shows number of columns.)

>Release:	mysql-5.1.32-1 ((Debian))

>C compiler:    gcc (Debian 4.3.3-5) 4.3.3
>C++ compiler:  g++ (Debian 4.3.3-5) 4.3.3
System: Linux jidanni2 2.6.26-1-686 #1 SMP Sat Jan 10 18:29:31 UTC 2009 i686 GNU/Linux

Some paths:  /usr/bin/perl /usr/bin/make

Compilation info (call): CC='gcc'  CFLAGS='-O3 -DBIG_JOINS=1 '  CXX='g++'  CXXFLAGS='-O3
-DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti '  LDFLAGS=''  ASFLAGS=''
Compilation info (used): CC='gcc'  CFLAGS=' -O3 -DBIG_JOINS=1    -DUNIV_LINUX'  CXX='g++' 
CXXFLAGS=' -O3 -DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti   
-fno-implicit-templates -fno-exceptions -fno-rtti'  LDFLAGS=' -rdynamic '  ASFLAGS=''
lrwxrwxrwx 1 root root 11 2009-03-21 08:20 /lib/ ->
-rwxr-xr-x 1 root root 1310924 2009-03-19 02:16 /lib/
Configure command: ./configure  '--build=i486-linux-gnu' '--host=i486-linux-gnu'
'--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info'
'--mandir=/usr/share/man' '--with-server-suffix=-1' '--with-comment=(Debian)'
'--with-system-type=debian-linux-gnu' '--enable-shared' '--enable-static'
'--enable-thread-safe-client' '--enable-assembler' '--enable-local-infile' '--with-pstack'
'--with-fast-mutexes' '--with-big-tables'
'--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql'
'--with-libwrap' '--with-ssl' '--without-docs' '--with-extra-charsets=all'
'--with-plugins=max' '--without-ndbcluster' '--with-embedded-server'
'--with-embedded-privilege-control' 'build_alias=i486-linux-gnu'
'host_alias=i486-linux-gnu' 'CC=gcc' 'CFLAGS=-O3 -DBIG_JOINS=1 ' 'LDFLAGS=' 'CPPFLAGS='
'CXX=g++' 'CXXFLAGS=-O3 -DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti '
'FFLAGS=-g -O2'
SHOW TABLE STATUS constantly wildly fluctuatingjidanni24 Mar