Re: Strange Replication Behavior

I believe the master.info and relay-log.info are only on the slaves and are specific to each slave (as each slave could be at a different point in the bin-log.) Thanks, Carl On Jul 25, 2012, at 2:22 PM, Richard Reina wrote: > I am trying to setup a new slave server and when I go to the mas

Re: Looking for consultant

r is Tomcat which runs on separate servers (the data servers only run MySQL.) Any ideas or help in any way are always welcome. Thanks, Carl On Jul 18, 2012, at 9:42 AM, Shawn Green wrote: > On 7/17/2012 8:22 PM, Carl Kabbe wrote: >> On Monday, I asked if there were consultants out

Looking for consultant

, I am back asking if there are consultants lurking on this list that could help with this project. Thanks, Carl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Looking for consultant

We are looking at installing an NDB cluster and are looking for someone to assist us in setting it up. Thanks, Carl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Converting Microsoft SQL database to MySQL

to do is add some indexes manually. Thanks, Carl On Jan 30, 2012, at 2:06 AM, James wrote: > Hi All, > > I am involved in a project to migrate our entire database from Microsoft > SQL to MySQL. > > I would appreciate the help if anyone could share what tools will you > re

OFF TOPIC - Looking for Consultant

sites and the remote site is currently running as a slave. We are looking for a consultant to do this as our staff simply does not have the time. Reply directly to me c...@etrak-plus.com. Thanks, Carl

Re: Replication issue

Thank you for the information and script. I will try it out tonight when traffic stops. Thanks, Carl - Original Message - From: "Reindl Harald" To: "Carl" Cc: Sent: Wednesday, February 16, 2011 7:47 AM Subject: Re: Replication issue -- MySQL General M

Re: Replication, log info

ee if I am setting myself up for future problems. Thanks, Carl - Original Message - From: Johan De Meersman To: Carl Cc: mysql@lists.mysql.com Sent: Wednesday, February 16, 2011 6:55 AM Subject: Re: Replication, log info On Wed, Feb 16, 2011 at 12:23 PM, Carl

Re: Replication issue

! Thanks, Carl - Original Message - From: "Reindl Harald" To: "Carl" Cc: Sent: Wednesday, February 16, 2011 7:02 AM Subject: Re: Replication issue -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: Replication issue

are you saying to restart the slave in question from a good copy of the master that I know to be good? Reindl Harald replied: yes! there is a reason why the salve stops to work and in my opinion the only save way to get a 100% clean slave is clone it again from the stopped master Carl: I

Re: Replication issue

I know to be good? Just trying to be really careful. Thanks, Carl - Original Message - From: "Reindl Harald" To: "Carl" Cc: Sent: Wednesday, February 16, 2011 6:24 AM Subject: Re: Replication issue -- MySQL General Mailing List For list archives: http://list

Re: Replication issue

The max_allowed_packet setting is the same on both. I have tried restarting the slave... didn't work. I can bounce the master. Thanks, Carl - Original Message - From: "Elizabeth Mattijsen" To: "Carl" Cc: Sent: Wednesday, February 16, 2011 6:23 AM Subje

Replication, log info

5:15:20 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'log even t entry exceeded max_allowed_packet; Increase max_allowed_packet on master', Error_code: 1236 110216 5:15:20 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000717', position 643066423 ~ Thanks, Carl

Replication issue

mbers. If I understand the problem, it is caused by blob >containing a character which is the same character that is used to mark the >end of a transaction in the bin log. My questions: 1) Is this a reasonable/correct analysis and 2) how do I work around the issue? Thanks, Carl

5.5 versus 5.1

ractive-timeout My config file for the 5.1 install is essentially the same (minor variations.) Does anyone know why the performance would be so different? Thanks, Carl

Re: Master Master Replication ... do a fail over and a week agos data is revealed.

, Carl - Original Message - From: "Johan De Meersman" To: "short cutter" Cc: "Brent Clark" ; Sent: Tuesday, October 19, 2010 5:10 AM Subject: Re: Master Master Replication ... do a fail over and a week agos data is revealed. On Tue, Oct 19, 2010 a

Re: Transfer database to MySQL.Huge effort?

uding creating the tables. Thanks, Carl - Original Message - From: "Luis Suzuki" To: Sent: Saturday, September 18, 2010 6:59 PM Subject: Transfer database to MySQL.Huge effort? I want to transfer a database(not MySQL) to MySQL(only the tables,not stored procedures,views etc.

Re: Fixture List generation using MySQL

trivial except for situations where games have been moved, teams have dropped out or been forfeited out, etc. Thanks, Carl Gavin - Sorry, didn't mean to send it to you privately... itchy trigger finger. - Original Message - From: "Gavin Towey" To: "Tompkins Neil&

Re: Master - master replication

Can anyone see how the data could be acquired by a bad person? (I understand both servers have to be secured.) Thanks, Carl - Original Message - From: "Patrick Sherrill" To: "Carl" Cc: Sent: Monday, May 24, 2010 8:09 AM Subject: Re: Master - master replication

Re: Master - master replication

requirements to move the card information from one server to another. Seems illogical since both transmissions are exposed in the same way. Thanks, Carl - Original Message - From: John Daisley To: Prabhat Kumar Cc: Carl ; Walter Heck ; mysql@lists.mysql.com Sent: Monday

Re: Master - master replication

John, I am familiar with the PCI regs and am trying to accomodate them. Our process requires that the card information is available on both servers so it is more a question of how than if. Thanks, Carl - Original Message - From: John Daisley To: Carl Cc: Walter Heck

Re: Master - master replication

Interesting. How is the best way to protect the information while using master - master replication on remote sites? (The data contains the information of children, credit cards and bank accounts.) Thanks, Carl - Original Message - From: John Daisley To: Carl Cc: Walter

Re: Master - master replication

Walter, Don't know how I missed that but it exactly what I needed. Thanks, Carl - Original Message - From: "Walter Heck" To: "Carl" Cc: Sent: Monday, May 24, 2010 5:49 AM Subject: Re: Master - master replication Hi Carl, On Mon, May 24, 2010 at 13:42

Master - master replication

transmission? 2. Is there a way to encrypt the data during transmission? Thanks, Carl

Re: 50 things to know before migrating from Oracle to MySQL

I once was selling a system to an organization. I recommended an IBM AIX box for about $30,000. A competitor was charging $30,000 for the software and said it had to run on an AS/400 that would cost in excess of $200,000. I lost the sale because the IBM salesman said, quite candidly, 'I make m

Re: 50 things to know before migrating from Oracle to MySQL

A quick Google turned up http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/ Man, I love Google. Thanks, Carl - Original Message - From: "Daevid Vincent" To: Cc: "'changuno '" Sent: Thursday, January 28, 2010 5:4

errno: 13

innodb.so;innodb_cmpmem=ha_innodb.so;innodb_cmpmem_reset=ha_innodb.so # Note: ha_innodb.so is in the 'plugins' directory. This error makes no sense to me. Can anyone kick me in the right direction? Thanks, Carl

Thoroughbred data to MySQL

I have a customer that has a five year old system that runs on Thoroughbred (Thoroughbred Software International) data. Has anyone ever been successful converting Thoroughbred data to MySQL? If so, how did you do it? Thanks, Carl

Re: Select query locks tables in Innodb

problem disappeared and the selects behave as one would expect. Many thanks to all who offered advice. Carl - Original Message - From: "Perrin Harkins" To: "Carl" Cc: Sent: Friday, March 13, 2009 1:40 PM Subject: Re: Select query locks tables in Innodb 2009/3/

Upgrading and screwed up

indicates to me that Navicat is using something it has stored because I can see the praramters when I look in the table.) To summarize the problem, mysql does not seem to be able to find/see the stored procedures. Anyone have any ideas? TIA, Carl

Re: Select query locks tables in Innodb

elp and Baron's suggestions also. Carl - Original Message - From: "Brent Baisley" To: "Carl" Sent: Thursday, March 05, 2009 1:12 PM Subject: Re: Select query locks tables in Innodb Ok, so you have 687 unique organization serial numbers. That's not ver

Re: Select query locks tables in Innodb

l_budget_account_detail.budget_account_detail_serial = payment_to_fee_link_budget_account_detail_link.budget_account_detail_serial and budget_account_master.budget_account_serial = budget_account_detail.budget_account_serial and budget_account_master.budget_account_type_serial = 5001 TIA, Carl - Original Message - From: "Bar

Re: Select query locks tables in Innodb

receipt_master table), they are stopped until the report query finishes and query on that table shows in Navicat as waiting for lock ('Locked'.) Since the report query is only reading data, I am puzzled why it locks the tables. Any ideas? TIA, Carl - Original Message ---

Re: Select query locks tables in Innodb

the isolation level but I believe it is whatever was set out of the box (five years ago.) Thanks, Carl - Original Message - From: "Perrin Harkins" To: "Carl" Cc: Sent: Wednesday, March 04, 2009 1:49 PM Subject: Re: Select query locks tables in Innodb 2009

Re: Select query locks tables in Innodb

report query. It is a foreign key on one of the files that is used. TIA, Carl - Original Message - From: "Baron Schwartz" To: "Brent Baisley" Cc: "Carl" ; Sent: Tuesday, March 03, 2009 5:50 PM Subject: Re: Select query locks tables in Innodb On Tue,

Re: Select query locks tables in Innodb

(copy attached), I could easily see it was locking tables using the Server Monitor in Navicat. Explain (copy as text and copy as Excel attached) seems to indicate that it is fairly good although the first step does get quite a few rows. Does anyone have any ideas? TIA, Carl - Original

Re: Select query locks tables in Innodb

l295 1journal_entry_masterrefPRIMARY, organization_shift_start organization_shift_start 5 organization_shift_start_serial 52 Note that it now starts with 5 row, expands to 295 rows, etc. not the 100,000+ from before. Again, thanks for all your help. Carl - Original Message - Fr

Select query locks tables in Innodb

only a read and would, therefore, not lock any tables. Anyone have any ideas? TIA, Carl

Master-master setup

ver B ? Replicate to server A? Does replication control the order in which transactions are applied so that somehow the replication from server A to server B is applied before the insert to server B? TIA, Carl

Really bad situation

erver just died. If anybody has any ideas, I sure would like to hear them. TIA, Carl

Re: MySQL Application Builder

it is decent. However, in order to do the things that make a presentation smooth and easy to understand, you have to understand how Flex works which is as difficult and obtuse as Java Swing. You can do simple things quickly but to do nice things is quite time consuming. HTH. Carl

Re: multiple DB copies with periodic synchronization

erver.) Of course, there are the usual processes to make certain that data gets from one side to the other and that, once the data gets to the other side, it never comes over again (unless it is changed again.) Just our way of doing this (after three false starts.) Thanks, Carl - Original Me

installing jTDS for WorkBench

http://sourceforge.net/projects/jtds docs say "jTDS does not need any special installation. Just drop the jar file into your application's classpath" How do I figure out where that is on a win box? I am trying to connect it to MsSql using http://java.com/getjava and http://sourceforge.net/pro

removing ibdata1 if some/all tables are not InnoDB?

ikely to be an issue, and MyISAM is a more suitable database engine for our much tighter disk space situation? I may have missed a section of the doco that discusses why one would choose an engine over another? Thanks for any advice, Carl -- === Vivitec Pty. Ltd. Suite 6, 51-55

Re: simple data GUI editor?

We use MySQL-Front from Star-Tools GmbH (www.mysqlfront.de)... works pretty much like you have asked. Thanks, Car - Original Message - From: "Berman, Mikhail" <[EMAIL PROTECTED]> To: Cc: "D_C" <[EMAIL PROTECTED]> Sent: Friday, June 17, 2005 4:36 PM Subject: RE: simple data GUI editor?

Re: Re: sleeping processes

get it to work and then expand it to what you really want to accomplish? Can you run a debugger on it to make certain what you think is happening is really what is happening? Thanks, Carl - Original Message - From: "Ronny Melz" <[EMAIL PROTECTED]> To: Sent: Monday, Jun

Re: sleeping processes

d for some things, not good for other ones.) But, for the appropriate applications, it is very fast. 2. You have to free the result set after every select. By the way, this code came right out of Googling. Thanks and good luck, Carl - Original Message - From: "Ronny Mel

Charsets in console

(select * from individuals where name='céline') fails. The funny thing is that the C8line record *is* found when I type the request without accents (select * from individuals where name='celine')? Does anybody know how to make the console show and accept the accented charact

RE: Converting to InnoDB?

On Mon, 25 Apr 2005, mathias fatene wrote: Sorry, Alter table toto ENGINE=innodb. You don't must, you can. You can also have differents storage ENGINES in the same mysql database. With innodb, you will earn ROW level locking. Best Regards Mathias FATENE Thanks, Mathias!

Converting to InnoDB?

says that, after changing the configuration file and restarting the MySQL server, there will be no problems using the existing MyISAM databases. Is that correct? Thanks, Carl G. Riches Software Engineer Department of Mathematics Box 354350 voice: 206-543-5082 or 206-616

links to MySql tools

level fee is only US$595/EUR495 per year and includes a MySQL Network development subscription among other benefits! I can understand that something needs to filter out all the wizbang submissions that arn't upto some standard, so I am not complaining, just wondering. Carl K -- MySQL Ge

where is "MySQL Workbench"? (DBDesigner's successor)

Michael Zinner, who is now among the newest MySQL employees. ... Set for release in May, MySQL Workbench will be available under a GNU GPL; commercial pricing was not determined at press time." That was over a year ago, which is a long time in this arena. So... any DBD fans know whats go

Select previous group

specific page.)  How can I select the names for page 99 (in this case) knowing only the first name on page 100 and the number of names I want to display?   Thanks,   Carl No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3

auth and ssh tunnel

EMAIL PROTECTED] but I don't really want to expose the box like that. I realize that a firewall could block any real exposure, but I don't have that kind of authority over the box. Is there a howto for this kind of setup? Carl Karsten http://www.personnelware.com/carl/resume.html --

Subject: ~~//~~ Greetings from sunny Queensland, Australia ~~//~~ ~~//~~ Adv

Hi, My name is Carl Millen, and I am writing you this email from my home here in sunny Queensland, Australia. The reason for this email is that you and I share something in common... At some point in our lives we contemplated or tried to start a home business. Don't worry; I'm not

Oracle 2 MySQL updates/replication?

e the MySQL instance from Oracle but was hoping to use a trigger/stored procedure to initiate the update so it seems more real time. Does this seem possible? Of course it may turn out non-trivial to write the synchronization code so I'll take suggestions on that front also. Thanks for any id

Re: disconnecting from server

exit; ? - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 21, 2004 10:12 AM Subject: disconnecting from server > Hi, > > I am using the command "./mysqld_safe --user=mysql &" to connect to the > server but how does one disconnect? > > Thanks in

RE: C Client compil error

> try... > > #include > #include > > int main(void) > { > MYSQL *database; > > database = mysql_init(database); > > return(0); > } > > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, April 26, 2004 8:25 AM > Subject: C Client compil error > >

mySqlDump grant command

I am sure that i used mysqldump to create a script that had both CREATE TABLE and GRANT commands, but now I can't figure out how. Carl K http://www.personnelware.com/carl/resume.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: msvcr70.dll was not found error when double click on desktop icon

hi, msvcr70.dll is part of the Microsoft(r) C Runtime Library v7. You can download this file free of charge from: http://www.dll-files.com/cgi-bin/cgiwrap/dll-files/topdown/download.pl?file=msvcr70.zip== (Copy and paste the above URI into your browsers address bar) Carl - Original Message

MYSQL Row Size

account_id='10043'; THIS IS TO DETERMINE HOW MUCH DISK SPACE THE ROW IS TAKING UP! Any help will be appreciated. Thanks --- Carl Fretwell - Web Developer - Doctor Net t. 0870 770 4990 - f. 0870 770 4991 Visit www.doc-net.com - let us b

Re: Load data + odbc

"incarc" PASSWORD "incarc" ; > > > DATABASE "OCUPAT" > > > > > > vQuery="LOAD DATA local INFILE 'c:/ocupat/preluare/baza.txt' into > table > > > baza FIELDS TERMINATED BY ''" > > > > > > r=sqlexec(sqlconnect("transfer"),vQuery) > > > > > > and r is -1 after that. h = SqlConnect("transfer") r=sqlexec(h,vQuery) if r<0 ? aError( laErrors ) _cliptext = laErrors[1,2] endif Paste the result here. Carl K -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems connecting to MySQL with WLS

Hello! I'm using a WLS server and MySQL. Where am I supposed to put the "mysql-connector-java-3.0.11-stable-bin.jar" to make sure WLS will find it? I've tried several places ie. under ttk and right under classes. Still WLS doesn't find my mysql.jar file. It works when I'm compiling it locall

SQL-help needed

Hi! I got a table, champions, looking like this: idclass winner_1 winner_2 year - 0 hd carl mattias 1957 1 hs daniel

SQL-HELP

Hi! I got a table, champions, looking like this: id class winner_1 winner_2 year - 0 hd carl mattias 1957 1 hs

SV: SQL-HELP

sions. But it's cheap :) /Carl -Ursprungligt meddelande- Från: Jochem van Dieten [mailto:[EMAIL PROTECTED] Skickat: den 17 februari 2004 16:44 Till: Carl Schéle, IT, Posten Kopia: [EMAIL PROTECTED] Ämne: Re: SQL-HELP Carl Schéle, IT, Posten wrote: > > I got a table, champio

SV: SQL-HELP

Now UNION is implemented in MySQL 4.0.0. and as I stated earlier I run 3.23.58. -Ursprungligt meddelande- Från: Rodolphe Toots [mailto:[EMAIL PROTECTED] Skickat: den 17 februari 2004 16:19 Till: Jonas Lindén; Carl Schéle; [EMAIL PROTECTED] Ämne: SV: SQL-HELP yeah but that wont really do

SQL-HELP

Hello! I got a table, champions, looking like this: id winner_1 winner_2 0carl mattias 1daniel carl 2erik

WHERE NOT EXISTS

I use php 4.1.1. mysql 3.23.49 and phpmyadmin 2.5.4 I have two tables classes - class_id (int) - class_name (text) HS HD DD DS MD champions - champions_id (int) - year (text) - class_name (text) - winner (text) --

Re: backup

* Rick ([EMAIL PROTECTED]) wrote: > i guys!! im newbie, how can i backup a mysql database? what do you recommend > me? > man mysqldump -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `'GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7

sql parser

ok into the MySql code without having to copy it. That way as MySql evolves, so will my tool. http://www.personnelware.com/carl/resume.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: C API first row not being returned from a query

remember the mysql_data_seek call. However, I did find my problem. It seems I was calling mysql_fetch_row( Result) once BEFORE returning to my calling routing to fetch the rows out, thus I was only getting the last 6 rows. DOH! Thanks for the help. -- .''`. Carl B. Constantine : :

C API first row not being returned from a query

print("Row %d is: %s\n",i,row); i++; } OK, the problem is, I don't get the very first row, I only get the last 6 rows. Can anyone tell me WHY this is? It doesn't really make sense. This code supposedly prints rows 1-7 but really only prints 2-7. Your help is greatly appr

Re: Populating a Table with Data by Inserting a Textfile

t;", 'jane'\t'smyth'\t'9 Fifth Ave'\t'apt 2L'\t'Anytown'\t'NY'\t'1'\t'20030912154615'\r The key thing is the field separation character. There is a parameter to tell the system what you have chosen as a field separation character, like this: --fields-separated-by="" ... After using this, u need not worry about embedded spaces within the individual fields -- ie, no need to quote each field. For lines, as long as you have one row corresponding to one line, you need not bother. But there is also an option to tell the system the character(s) that mark the end of each line . Look up the docs for load data infile and mysqlimport ... hth --carl Steve Tiano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Loading a flat file

y problem is that you may need to run mysqlimport as root ... have not yet found a way to run it as a non-root user .. yet. hth --carl Tried these too: LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable lines terminated by '\n\' LOAD DATA '/mypath/flatfile.txt

non-root users cannot run mysqlimport

has the important 'file' privilege. But it seems only the user root can load these files. Any ideas on whats going on here and what I may be missing/overlooking ... All posts appreciated ... --carl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: error 1044 on database restore

* Victoria Reznichenko ([EMAIL PROTECTED]) wrote: > It means that user doesn't have ALTER privilege. BUT, I've tried granting the user all privs in mysqlcc and it still doesn't work. Looking at my other setup, the users look like they are set up the same. -- .''

error 1044 on database restore

t even get the user to have the lock tables priv, even though I'm root granting the priv, it just refuses to take. Yet, the machine it worked on seems to be set up the same way and I didn't have a problem. Can someone point me in the right direction to a solution? -- .''`.

Re: Database replication

* Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > On Tue, Jun 24, 2003 at 09:14:18PM -0700, Carl B. Constantine wrote: > > I want to be able to take a database running on a primary server and > > duplicate/mirror it on a secondary server. I want to be able to update > > the

Database replication

InnoDB? Thanks. -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `'GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `- Debian GNU/Linux -- The power of freedom pgp0.pgp Description: PGP signature

segfault on startup after kernel change?

search on this error and come up with hits from many different lists (PHP, LDAP, and so forth) but nothing that pertains to what I'm seeing. Can someone provide some insight? -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `'GnuPG: 135F FC30 7A02 B

sudden 1476 segfault starting mysql

ldn't have anything to do with it, should it? -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `'GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `- Debian GNU/Linux -- The power of freedom pgp0.pgp Description: PGP signature

Re: Open-Source/Freeware Tool To Generate ER Diagrams From SQL Sc ripts ? - ImportER (ER Tool: Dezign)

. It also looks more like class diagrams (from the screenshots) than true ER, but I haven't looked at it in detail. Just my $0.02 worth. -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `'GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `-

Re: Open-Source/Freeware Tool To Generate Entity Relationship Diagram s From Text File Containing SQL Scripts ?

same with aggregates and so forth. As to doing ER, you can use Dia <http://www.lysator.liu.se/~alla/dia/> which will also do UML. Now, it shouldn't be hard to go from your SQL script file to a UML type diagram (ala Absess and Oracle) but I'm not aware of utils that do that

Re: mySQL GUIs

you need MySQL 4 if you want to compile it yourself, but binaries are available from the website that still work with 3.23.x -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `'GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `- Debian GNU/L

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

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

JOINing unequal-sized tables (grouped columns)

2 | 5.00 | ++--+--+ 4 rows in set (0.73 sec) Not quite. Any thoughts? I would think this is a well-known and well-solved problem. My SQL skills are slap-dash at best, learned in fits and starts, so forgive me if I've missed something obv

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

Re: SQL select rows conditional on same select

| four | ++---+ and when Z = 3 or 4 or 5, it just returns the single row that I would expect. Again, thanks. Carl > > Carl Franks wrote: > Hi, > > I have 2 tables, "X" and "Y". > > table X table Y > ++---+ +-

SQL select rows conditional on same select

r, I would like to do this with one SELECT if it's possible, for efficiency. Thanks, Carl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the lis

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

Location of header files - RPM

cial MySQ\ L RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-po\ inter -felide-constructors -fno-exceptions -fno-rtti -mpent ium' CXX=gcc Carl Carpenter IT Manager Hill Country Community MHMR Center --- Outgoing m

boolean-mode fulltext search: problems with +searchterm*

the fulltext index both before and after inserting the data. >Fix: As I haven't been able to isolate the exact nature of the bug, I don't know of a fix or workaround. >Submitter-Id: >Originator:Carl J Meyer >Organization: Mennonite.net >MySQL support: none &

double-quotes do not perform as documented in fulltext boolean mode searches

the first two rows are given identical relevance, exactly as if the double-quotes had been omitted. >Fix: Haven't found a way to duplicate the missing functionality. >Submitter-Id: >Originator:Carl J Meyer >Organization: Mennonite.net >MySQL support: none >Syno

server restart updating NULL values in fulltext indexed table

ields with the NULL value. >Submitter-Id: >Originator:Carl J Meyer >Organization: Mennonite.net >MySQL support: none >Synopsis: server restarts when updating NULL-valued fulltext-indexed fields >Severity: serious >Priority: high >Category: mysql &

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

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

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:

  1   2   3   4   >