$ 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
>Environment:
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=''
LIBC:
lrwxrwxrwx 1 root root 11 2009-03-21 08:20 /lib/libc.so.6 -> libc-2.9.so
-rwxr-xr-x 1 root root 1310924 2009-03-19 02:16 /lib/libc-2.9.so
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'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
