RE: Question about SLAVE STOP

2002-12-09 Thread Carl McNamee
point to the begining of the transaction that was rolled back. If this is incorrect please let me know. Thanks! Carl -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 8:56 AM To: '[EMAIL PROTECTED]' Cc: Carl McNamee Subject: Re

RE: Question about SLAVE STOP

2002-12-06 Thread Carl McNamee
? Or does it, heaven forbid, just stop in the middle of the transaction? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Question about slave server

2002-11-26 Thread Carl McNamee
sql,query In a replicated environment, are slave servers read only or can a user attach to one and perform updates? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting, please check: http

innodb locking behavior question

2002-08-19 Thread Carl McNamee
. What we were expecting was that process B would skip over the records locked by process A and get the next 5 records. Any thoughts on what's really going on here? Is there a (better?) way to do what we want? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282

Interesting problem with Alter table and foreign keys on 3.23.51

2002-06-18 Thread Carl McNamee
Below is an example of a problem I'm having when issuing an alter table command to create a foreign key in mysql version 3.23.51. I am running the max version and the tables exist in the innodb table space. Thoughts? Comments? Criticism? Carl McNamee Systems Administrator Billing Concepts

Performance issues between two servers

2002-05-03 Thread Carl McNamee
. On SQLDEV0 it shares access with several other programs but the box is not very busy. Thoughts? Comments? Criticism? Carl McNamee Systems Administrator/DBA Billing Concepts (210) 949-7282 - Before posting, please check

RE: Feature? (Not null and timestamps)

2002-04-15 Thread Carl McNamee
the not null for the timestamp column. Which is correct? How do I make the column not null? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting, please check: http://www.mysql.com/manual.php

Timestamp and Load Data command

2002-04-15 Thread Carl McNamee
commands? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: InnoDB

2002-04-09 Thread Carl McNamee
Heiki, I have a question concerning the new auto-extending function (which sounds really cool by the way!). How does it handle the case where it runs out of disk space while expanding? Will it gracefully handle this scenerio or will some sort of recovery be necessary? Carl McNamee Systems

Client installation by itself?

2002-02-27 Thread Carl McNamee
Is it possible to install just the mysql client software for NT? The only client distributions I can find include the mysql server as well. Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting

RE: ODBC and SystemDSN?

2002-02-25 Thread Carl McNamee
sql,query Is it possible to setup a system DSN with myodbc? We have several databases that need to be linked together for Crystal Reports to use. So far I have not figured out how to do this. TIA! Carl McNamee Systems Administrator Billing Concepts (210) 949-7282