Show table status

Hello, Does anyone know where (c-api functions perhaps) "SHOW TABLE STATUS" gets its info from? Specifically, the new columns added in 4.1.2 and 4.1.3, are they the result of underlying c-function changes, new functions, or something else. Thanks Michael -- MySQL General Mailing List For list

RE: datetime/timestamps/4.1.12

enient and annoying. Any plans on rectifying this, or has anyone found a workaround, or are we left to go SIOH (hint OH stands for "our hat") :-} Later... Michael -Original Message- From: DePhillips, Michael P Sent: Sun 7/17/2005 11:05 AM To: m

datetime/timestamps/4.1.12

Hello, I just upgraded to 4.1.12 from 4.0.22 and my timestamps changed formats to %Y-%m-%d %H:%i:%s So I added the following lime to my my.cnf file datetime_format=%Y%m%d%H%i%s Which is the format I prefer, I restart the server and my time stamps still appear as %Y-%m-%d %H:%i:%s The

dateTime vrs. Timestamp

Hello, Am I gaining anything by using a timestamp instead of using dateTime and calling now(), for example, increased performance, better indexing, etc. I guess another way to ask this is does the MySQL internals handle a timestamp more efficiently than a dateTime. Thanks Michael -- MySQL Gene

Replication - Too many master threads -BUG?

Hi - perhaps this is a bug - but I figure I'd try here first in case I'm doing something wrong. Master is 4.0.20 - slave connect and replicate fine, HOWEVER, for each binlog dump a new thread gets created and the old one is NOT released. Within a couple of days my master sever is flooded and allo

RE: Replication died

Never mind...I've fixed it. Thanks Michael > -Original Message- > From: DePhillips, Michael P > Sent: Wednesday, June 09, 2004 4:17 PM > To: '[EMAIL PROTECTED]' > Subject: Replication died > > Hello - > > I just upgraded my master to 4.0.20 fr

Replication died

Hello - I just upgraded my master to 4.0.20 from 3.23.54 (ran the mysql_fix_privileges script) My slaves are all 4.0.[16,17,18] All seems well EXCEPT the Slave_IO_Running will NOT start. All my slave a stuck at the point prior to the upgrade. Error logs reveal nothing out

RE: Replication Madness

reconnecting to master '[EMAIL PROTECTED]:3336': Error: 'Host '111.111.11.11' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400 (Numbers and letter changed intentionally.) -Original Message- From: Mikael Fridh To:

Replication Madness

Hi Folks Every now and again one of my slaves try's to connect to its master via its ip address as opposed to its dns name. This causes a problem because the ip address does not have credentials on the master, therefore, connection refused ->replication ends ->databases out of sync-> angry use

RE: new install failure

That did it thanks Pete I need to my installs earlier in the day ;) -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:44 PM To: DePhillips, Michael P; [EMAIL PROTECTED] Subject: RE: new install failure Have you checked permissions

new install failure

HI list When installing mysql 4.16 on debian linux 2.4.20-20.8smp I get the following errors... ---snip- -- 031112 16:05:08 mysqld started 031112 16:05:08 InnoDB: Started 031112 16:05:08 Fatal error: Can't open p

Master/Slave Replication

Hi List I'm having trouble start a slave. All seems to be configured well as per show slave status, I issue a mysql> slave start; Query OK, 0 rows affected (0.00 sec) and nothing happens, show slave status sill says slave is not running. Any insght?? Thanks mike -- MySQL General Mailing Li

copy database

HI List, Using version 4.0.15 I'm trying to copy a database. Copy db1 to (new) db2. So I created db2. And then tried the following and got the subsequent errors. # mysqldump --add-drop-table db1 | mysql db2 ERROR 1064 at line 399: You have an error in your SQL syntax near '

4.0.13/Solaris9 - 64 bit or 32 bit

Hi all, I'm upgrading a mission critical production server with Solaris 9 and mysql 4.0.13 and was wonder if I should install as 64 bit or 32 bit. I couldn't find much recent discourse on the subject, perhaps some of you have some experience, known pit falls, ideas or suggestions Th

RE: MYI file difference

To be a bit clearer, should the MYI index files betweened two slaves of a mirrored database be different? I would think they would be identical, right? Thanks -Original Message- From: DePhillips, Michael P To: [EMAIL PROTECTED] Sent: 7/16/2003 6:18 PM Subject: MYI file difference Hi

MYI file difference

Hi All, I tarred up the data directory from mirror1 data base - slave. Copied the tarball to mirror2 with the hopes of rebuilding mirror2 - another slave. Backed up the data directory from mirror2 into old and untarred mirror1 Then I did a diff -r against another mirror and the diff came ba

create table...checksum = 1

Hey Folks I'm having a tough time finding any information in the available documentation about this feature. Does anyone out there have a bit of insight as to what exactly it does. Docs says MySQL will store a checksum for each row if this is 'on' - that's about all I can find. Some