Question about slave server

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 chec

RE: Question about SLAVE STOP

? 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

RE: Question about SLAVE STOP

g will now 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

RE: ODBC and SystemDSN?

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

Client installation by itself?

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: InnoDB

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

RE: Feature? (Not null and timestamps)

uot;show create table" command shows 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:

Timestamp and Load Data command

t;load data" or mysqlimport 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

Performance issues between two servers

on SQLDEV1. 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, pl

Interesting problem with Alter table and foreign keys on 3.23.51

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 Con

innodb locking behavior question

ocked. 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