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 master

Re: Looking for consultant

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 there who could help set up an NDB high availability

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 recommend of converting SQL

OFF TOPIC - Looking for Consultant

the 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

Replication issue

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

Replication, log info

up to log 'mysql-bin.000717', position 643066423 ~ Thanks, Carl

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 l...@dijkmat.nl To: Carl c...@etrak-plus.com Cc: mysql@lists.mysql.com Sent: Wednesday

Re: Replication issue

that I know to be good? Just trying to be really careful. Thanks, Carl - Original Message - From: Reindl Harald h.rei...@thelounge.net To: Carl c...@etrak-plus.com Cc: mysql@lists.mysql.com Sent: Wednesday, February 16, 2011 6:24 AM Subject: Re: Replication issue -- MySQL General

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

! Thanks, Carl - Original Message - From: Reindl Harald h.rei...@thelounge.net To: Carl c...@etrak-plus.com Cc: mysql@lists.mysql.com Sent: Wednesday, February 16, 2011 7:02 AM Subject: Re: Replication issue -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Replication, log info

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 c...@etrak

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 h.rei...@thelounge.net To: Carl c...@etrak-plus.com Cc: mysql@lists.mysql.com Sent: Wednesday, February 16, 2011 7:47 AM Subject: Re

5.5 versus 5.1

-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 vegiv...@tuxera.be To: short cutter shortcut...@126.com Cc: Brent Clark brentgclarkl...@gmail.com; mysql@lists.mysql.com Sent: Tuesday, October 19, 2010 5:10 AM Subject: Re: Master Master Replication ... do a fail over and a week agos data

Re: Transfer database to MySQL.Huge effort?

creating the tables. Thanks, Carl - Original Message - From: Luis Suzuki luissuz...@live.com To: mysql@lists.mysql.com 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

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 gto...@ffn.com To: Tompkins Neil neil.tompk

Master - master replication

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

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 wal...@openquery.com To: Carl c...@etrak-plus.com Cc: mysql@lists.mysql.com Sent: Monday, May 24, 2010 5:49 AM Subject: Re: Master - master replication Hi Carl

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

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

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

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 patr...@michael-clarke.com To: Carl c...@etrak-plus.com Cc: mysql@lists.mysql.com Sent: Monday, May 24, 2010 8:09 AM Subject: Re

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

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 dae...@daevid.com To: mysql@lists.mysql.com Cc: 'changuno ' chang...@rediffmail.com Sent

errno: 13

. 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: Solved 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 per...@elem.com To: Carl c...@etrak-plus.com Cc: mysql@lists.mysql.com Sent: Friday, March 13, 2009 1:40 PM Subject: Re: Select query

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

suggestions also. Carl - Original Message - From: Brent Baisley brentt...@gmail.com To: Carl c...@etrak-plus.com 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 very unique

Re: Select query locks tables in Innodb

= 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: Baron Schwartz ba...@xaprb.com To: Carl c...@etrak-plus.com Cc: mysql

Re: Select query locks tables in Innodb

journal_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 - From: Baron Schwartz

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

in the report query. It is a foreign key on one of the files that is used. TIA, Carl - Original Message - From: Baron Schwartz ba...@xaprb.com To: Brent Baisley brentt...@gmail.com Cc: Carl c...@etrak-plus.com; mysql@lists.mysql.com Sent: Tuesday, March 03, 2009 5:50 PM Subject: Re: Select

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 per...@elem.com To: Carl c...@etrak-plus.com Cc: mysql@lists.mysql.com Sent: Wednesday, March 04, 2009 1:49 PM Subject: Re: Select query

Re: Select query locks tables in Innodb

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 - From: Baron Schwartz ba

Select query locks tables in Innodb

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

Master-master setup

? 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

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

Re: MySQL Application Builder

and 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

.) 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 Message

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

removing ibdata1 if some/all tables are not InnoDB?

, 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 City Rd. Southbank, 3006

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: mysql@lists.mysql.com Cc: D_C [EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:36 PM Subject: RE: simple data

Re: Re: sleeping processes

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: mysql@lists.mysql.com Sent: Monday, June 06, 2005

Re: sleeping processes

. 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 Melz [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, June 05, 2005 4:57 PM Subject: Re: sleeping processes

Charsets in console

* 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 characters? Thanks Carl -- MySQL

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

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! Carl

where is MySQL Workbench? (DBDesigner's successor)

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 going on? Carl Karsten -- MySQL

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 General

Select previous group

to a 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/18

auth and ssh tunnel

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 -- MySQL General

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 trying

Oracle 2 MySQL updates/replication?

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 ideas, -Carl

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 advance

RE: C Client compil error

try... #include windows.h #include mysql.h 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 Hello

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

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 be your key

Re: Load data + odbc

TERMINATED BY '' r=sqlexec(sqlconnect(transfer),vQuery) and r is -1 after that. h = SqlConnect(transfer) r=sqlexec(h,vQuery) if r0 ? aError( laErrors ) _cliptext = laErrors[1,2] endif Paste the result here. Carl K -- MySQL General Mailing List For list archives: http

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 locally

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

SQL-HELP

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

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

SV: SQL-HELP

. 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, champions, looking like

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 9F7A 3FF8 `- Debian GNU/Linux

sql parser

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

( 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 : :' : [EMAIL PROTECTED] `. `'GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `- Debian GNU/Linux

C API first row not being returned from a query

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 appreciated. -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `'GnuPG: 135F FC30 7A02 B0EB

Re: Populating a Table with Data by Inserting a Textfile

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]

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 unsubscribe

Re: Loading a flat file

to be loaded .. The only 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' INTO TABLE mytable

error 1044 on database restore

, 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? -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `'GnuPG

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. -- .''`. Carl B. Constantine

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 secondary server on a selectable

Database replication

. -- .''`. 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?

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 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `- Debian GNU/Linux -- The power

sudden 1476 segfault starting mysql

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

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/Linux -- The power of freedom pgp0.pgp

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

. 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 either. -- .''`. Carl B. Constantine : :' : [EMAIL

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

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 `- Debian GNU/Linux -- The power

RE: Question about SLAVE STOP

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

? 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 check: http

JOINing unequal-sized tables (grouped columns)

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 obvious here. Thanks! Carl

innodb locking behavior question

. 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

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 ++---+ ++---+ | id | title | | id | assoc

SQL select rows conditional on same select

possible, for efficiency. Thanks, Carl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

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 Concepts

Location of header files - RPM

' '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 mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version

server restart updating NULL values in fulltext indexed table

. Submitter-Id: 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 Class: sw-bug Release: mysql

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

found a way to duplicate the missing functionality. Submitter-Id: submitter ID Originator:Carl J Meyer Organization: Mennonite.net MySQL support: none Synopsis: fulltext boolean mode search, double-quotes do not work as documented Severity: non-critical Priority: low Category

boolean-mode fulltext search: problems with +searchterm*

able to isolate the exact nature of the bug, I don't know of a fix or workaround. Submitter-Id: submitter ID Originator:Carl J Meyer Organization: Mennonite.net MySQL support: none Synopsis: boolean-mode fulltext search: problems with +searchterm* Severity: serious Priority

Performance issues between two servers

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

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

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

  1   2   3   4   >