Out of control connections

own in about a minute. Does anyone know of any way I can log these connections or some other way of catching it in progress from myslq so I can figure out which website is causing it and then go correct the code? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mys

Upgrading and table engine change advise

ems I need to be aware of? Thanks in advance. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysqlhotcopy and replication

7;s my question. While the tables are flushed with read lock, what becomes of all the Insert,Update and delete queries that come in via replication? Will they be applied after the backup is done and the tables unlocked? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.

Multi master replication question

pdates setting (there are downstream servers doing one way replication off of server B) and then replicated back to A? Just having a brain fart here... Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Multi master replication question

> -Original Message- > From: Dominik Klein [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 18, 2006 11:06 > To: mysql@lists.mysql.com > Subject: Re: Multi master replication question > > > > Replication setup: > > > > A -> B -> A > > | > > C > > > > One thing I can't remember i

Mysql-shared-compat for 4.13

. Problem is, I can't find the rpm or source for the MySQL-shared-compat for 4.1.13 (or any other version for that matter). Anyone know where I can get my hands on the correct RPM? Are they hidden somewhere on the MySQL site? Best regards, Jeff -- MySQL General Mailing List For list

RE: Mysql-shared-compat for 4.13

Thanks! Jeff > -Original Message- > From: Jason Pyeron [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 26, 2005 3:03 PM > To: mysql@lists.mysql.com > Subject: Re: Mysql-shared-compat for 4.13 > > > > you can find what you need here: > >

Replication question

Does anyone know if there are any problems replicating from a master database on version 4.0.16 to a slave running version 4.1.13? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Install error on fedora Core3

fore mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL...[FAILED] Anyone have this problem and know how to fix it??? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

Replication started but not running

Master_SSL_Key: Seconds_Behind_Master: NULL Any ideas as to what is locking it up? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Circular Replication

n. Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Circular Replication

> -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: Friday, September 16, 2005 11:34 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: Circular Replication > > > In the last episode (Sep 16), Jeff said: > > Does anyone use ci

RE: Circular Replication

> -Original Message- > From: Jeff McKeon > Sent: Friday, September 16, 2005 13:19 > To: Devananda > Cc: mysql@lists.mysql.com > Subject: RE: Circular Replication > > > > -Original Message- > > From: Devananda [mailto:[EMAIL PROTECTED] > &

RE: Circular Replication

with --log_slave_updates? Or is that only necessary in a replication situation like this with more than 2 servers? A -> B -> C -> A If it's just: A -> B -> A Is it necessary to start the servers with --log_slave_updates? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Circular Replication

> -Original Message- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 20, 2005 17:13 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: Circular Replication > > > Jeff wrote: > >>-Original Message- > >>Fro

RE: Circular Replication

> -Original Message- > From: Bruce Dembecki [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 20, 2005 23:05 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: Circular Replication > > > On Sep 16, 2005, at 11:07 AM, Jeff wrote: > >

Timezone setting wrong?

n the new slave returns *** 120. row *** Variable_name: timezone Value: IST I'm sure I've missed something simple here but what? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

MyISAM to InnoDB

ems replicating from A -> B -> A (circular replication) when A had Table1= InnoDB and B has Table1=MyISAM? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Web-based reporting tool?

> -Original Message- > From: Warrick Wilson [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 12:09 > To: mysql@lists.mysql.com > Subject: Web-based reporting tool? > > > This seems to be a common question, but answers aren't that common... > > What are people using as a we

RE: MyISAM to InnoDB

> -Original Message- > From: Bruce Dembecki [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 11:41 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: MyISAM to InnoDB > > > You will need to make sure you have innodb configured in the my.cnf

RE: Avg row length is varying a lot from oracle to MySQL

> -Original Message- > From: Sujay Koduri [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 15:23 > To: mysql@lists.mysql.com > Subject: Avg row length is varying a lot from oracle to MySQL > > > hi ,, > > we are converting our oracle DB to MySQL DB. One problem i > see is

RE: Avg row length is varying a lot from oracle to MySQL

w. I believe there is also some paging overhead so generally take your calculated row size and multiply by 1.1. > sujay > > -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: Friday, September 23, 2005 1:12 AM > To: mysql@lists.mysql.com > Subject: RE:

RE: MyISAM to InnoDB

> -Original Message- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 16:14 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: MyISAM to InnoDB > > > Jeff wrote: > > True, is there a way to tell a slave to not repli

RE: MyISAM to InnoDB

> -Original Message- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 19:03 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: MyISAM to InnoDB > > > Jeff wrote: > >>-Original Message- > >>From:

RE: MyISAM to InnoDB

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, September 23, 2005 09:40 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: RE: MyISAM to InnoDB > > > Sorry to butt in but I wanted to make sure you didn't do >

RE: MyISAM to InnoDB

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, September 23, 2005 10:25 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: RE: MyISAM to InnoDB > > > "Jeff" <[EMAIL PROTECTED]> wrote on 09/23/2005

Weird database files

lmysql 14K Sep 12 11:50 #sql-7c1c_217c.frm -rw-rw1 mysqlmysql1.8G Sep 12 11:54 #sql-7c1c_217c.MYD -rw-rw1 mysqlmysql 92M Sep 12 12:09 #sql-7c1c_217c.MYI Anyone ever see something like this before? Are they files for a temp table maybe? Jeff

RE: Weird database files

> Jeff wrote: > > Had problem with our database this weekend, apparently an > app did an > > insert query that was huge size wise and this totally boogered up > > replication downstream. Also I cant read past that point in the > > binlog using mysqlbinlog on th

RE: MyISAM to InnoDB

threads = 4 But what happens if the ibdata2 fills up to the max of 2G? I've got 50 gig available on the partition where the db data is stored. Is there anything else here that looks incorrect? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

RE: MyISAM to InnoDB

> -Original Message- > From: Sujay Koduri [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 11:04 > To: Jeff; mysql@lists.mysql.com > Cc: [EMAIL PROTECTED] > Subject: RE: MyISAM to InnoDB > > > > If you think your storage requiremnets will

RE: MyISAM to InnoDB

> -Original Message- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 13:06 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: MyISAM to InnoDB > > > Jeff wrote: > >> Cut orignal thread because it was too long >

RE: MyISAM to InnoDB

> -Original Message- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 13:06 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: MyISAM to InnoDB > > > Jeff wrote: > >> Cut orignal thread because it was too long >

RE: MyISAM to InnoDB

> Jeff wrote: > > > > Ugh... > > > > mysqladmin -uroot -ptelaurus processlist | grep -c "Sleep" > > > > And it returned 200 sleeping connections, all persistant > connections > > from our app servers and 4 threads_running > &g

RE: MyISAM to InnoDB

> -Original Message- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 29, 2005 14:56 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: MyISAM to InnoDB > > > Jeff wrote: > > > > Well the applications with persis

Database user Permissions

the db from the local system, fails until I actually create another grant record for [EMAIL PROTECTED] It's not a huge problem but I'd like to understand it better. Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Database user Permissions

from that server. I guess that could be easily spoofed though. In any event, thanks for a thorough answer, at least I know the behavior is truly by design. Jeff > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 12, 2005 09

Turn of bin log for a session

Hey all, I need to do some repairs on a replication master/slave and can't remember the command to turn off bin logging on the master for a single session. Set session log_bin = off; Just returns an error: ERROR 1193: Unknown system variable 'LOG_BIN' MySQL ver 4.1.13

Insert query problem

1','test','test test',unix_timestamp(now()),'"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>','Medium','Open',unix_timestamp(now()),'Jeff McKeon','Jeff McKeon','','','ks5hslajdfasd','1',

RE: Insert query problem [solved]

Nevermind, found that usig `from` works. Jeff > -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 29, 2005 11:43 > To: mysql@lists.mysql.com > Subject: Insert query problem > > > All, > > I can't get this query to

Alter MyISAM table to adjust max_rows and Avg_row_length

etting for Avg_row_length or even what the measurement is. Bytes? Columns? Any help is much appreciated. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Alter MyISAM table to adjust max_rows and Avg_row_length

> -Original Message- > From: Michael Stassen [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 08, 2005 14:34 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: Alter MyISAM table to adjust max_rows and Avg_row_length > > > Jeff wrote: > > I'

Relication from multiple databases

Anyone know if it's possible to do replication from more than one database? Example: System A: Database 1 System B: Database 2 System C: Replication of SYSA:DB1, Replication SYSB:DB2 Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Replication from multiple masters?

Does anyone know if it's possible to replicate to a single slave from different databases on different masters? For instance: M1:dbAM2:dbB \ / rep rep \ / Slave Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

RE: Replication from multiple masters?

Sorry for the top post, just saying thanks, that's what I thought Back to the drawing board... Jeff > -Original Message- > From: David Griffiths [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 01, 2006 18:13 > To: mysql@lists.mysql.com > Cc: [EMAIL PROT

MyISAM Backup

f I'm tar'ing a file while mysql has it open? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Changing the binlog dir

move the old binlogs to the /data/ prior to restarting mysql 2) should I move the binlog index as well? 3) will moving the binlog location throw the slaves off? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Auto increment Primary Index fields in replicated db

some way to have this work? Someone on another msg board told me to look at Auto_increment_increment and Auto_increment_offset to accompish this but I don't see anything like that in the MySQL docs. Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.co

RE: Help regarding a simple query

Thanks in Advance, > > Regards, > venu. > (sorry for my poor English) > Won't this work? Select * from X where name like '%venu%' jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Help regarding a simple query

>-Original Message- >From: VenuGopal Papasani [mailto:[EMAIL PROTECTED] >Sent: Monday, March 13, 2006 11:48 >To: Jeff >Subject: Re: Help regarding a simple query > > >Hi Jeff, > This is venu again.Last mail i did not include a constraint that is what irritatin

Using IF in a query to set a variable then sort on said variable

ible in a mySQL query directly? The only other option I guess I have is to run a mass update on a field then doing the normal order but doing three updates just to make one select work seems kind of unfortunate :( Jeff

RE: Using IF in a query to set a variable then sort on said variable

ould be. I originally wanted to use mySQL as the part that did this processing as opposed to outputting the results then sorting an array. Jeff From: 卢钧轶 [mailto:cenal...@gmail.com] Sent: Sunday, October 25, 2009 1:19 AM To: Jeff Subject: Re: Using IF in a query to set a variable then sort on sai

RE: Using IF in a query to set a variable then sort on said variable

An additional field is pretty much impossible since that case would change throughout the day unfortunately. But thank you all for your assistance, will do some testing. Jeff -Original Message- From: Jaime Crespo Rincón [mailto:jcre...@warp.es] Sent: Monday, October 26, 2009 12:52 PM

what is the rationale for not allowing LOCK TABLES in a stored procedure

Hello, I have read through several pages of the reference manual, and I've seen several instances where it is stated that LOCK TABLES (and UNLOCK TABLES) is not allowed in a stored procedure, but so far, I haven't found an explanation as to *why* that is. Could someone please enlighten me? Thanks

terrible time installing MySql

haracter or so descriptive subject here (for reference)] >Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: Jeff >Organization: >MySQL support: [none | licence | email support | extended email support ] >Syn

Syntax confusion

get 0 rows returned The book hinted at using DATE_FORMAT which I did SELECT BA_ID, BA_DATE FROM BA WHERE SUBSTRING(BA_ID,1,3) = 'TSV' AND BA_DATE = DATE_FORMAT('2003-25-2', '%y-%d-%m') But still 0 rows... D'OH... What am I missing here? Thanks for any help..

Re: Syntax confusion

Yes Paul, that's what I meant. See, even confusing myself now ;-) The field is datetime as the time is used in other functions... Would I be better using 2 separate fields? Jeff - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Jeff" &

Re: Syntax confusion

Thanks guys, Appreciate the help. Kinda makes sense now ;-) Jeff - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Benjamin Pflugmann" <[EMAIL PROTECTED]>; "Jeff" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL P

XML

can manage, but it's XML support is so very tempting. Thanks. Jeff Levy Software Design Meta-Craft Creations - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

help understanding memory usage

, Jeff - 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 PROTECTED]> To unsubscribe, e-mail &

Searching for partial dates

record for the month of June. What is the best way to search? Do I need to separate the date into different columns (day, month, year)? I have tried wildcard searches, but they seem to do an entire table scan and are very slow. Th

RE: Multiple MySQL Instances...

only be accessed by them and couldn't be squashed (or even accessed) by other departments. Just a thought! jeff -- Hey All, On Redhat Linux is there an easy way to have an ISP style setup where each "user" has their own database directory? Long story short, we ha

Query Help

dump one country by doing: SELECT x_country, country_name FROM request, countries WHERE x_country = country_id AND ID = x But I was hoping I would be able to do all three in one query. Any help would be *greatly* appreciated! Thanks!!! jeff --

RE: MySQL performance?

Here you go - http://www.mysql.com/information/benchmarks.html --- I'm just now starting to play with MySQL. I had a client ask me how it performance compared to Oracle, DB2, and MS SQL server. Does anyone know of any benchmarks of other specs that can compare performance? -

RE: newbie: SQL question

Try this: http://www.devshed.com/Server_Side/MySQL - Hi, I am just a starter. Anyone can suggest me good web resources for learning SQL command that I can use (compatible) with mySQL ? I read from www.mysql.com documentation, but it's not complete ... Well, if you hav

RE: PHP & mysql

NT Server uses NTFS file system, add execute rights for I_USR_ to the directory that contains php.exe." In other words, you have to tell IIS to parse .php files with php.exe. Hope that helps! Jeff ** Hi guys, I hope you can show me where I am going wrong

cannot install mysql, read directions many times

quot;ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)" -- Jeff Greer - B.S. computer science - Univ. MO - Rolla - web developer/software engineer, dedicated to the struggle against the fascist Microsoft hegemony

Re: cannot install mysql, read directions many times

Never mind. Dumb mistake. I had an older version of mysql on this system set to a password which I forgot. -- Jeff Greer - B.S. computer science - Univ. MO - Rolla - web developer/software engineer, dedicated to the struggle against the fascist Microsoft hegemony

Re: Loop Trigger

father) references t1(id) on update restrict on delete > restrict ); > create trigger tg_t1 > before update on t1 > for each row > begin > update t1 set c=c+1 where father=NEW.id; > end; set NEW.c = NEW.c + 1; or whatever. You dont update on a before trigger.. Jeff pgpeUL5J7xa3l.pgp Description: PGP signature

Re: Fun with Dates and Incentives.

the parent table and use it as the relationship key for all child tables. This way I know that the value will never change and it's not part of data important to the end user or the application. This is basically what Peter suggested. jeff -- Counting in octal is just like counting i

Re: Fun with Dates and Incentives.

the parent table and use it as the relationship key for all child tables. This way I know that the value will never change and it's not part of data important to the end user or the application. This is basically what Peter suggested. jeff -- MySQL General Mailing List For list a

Re: Broken Mac pref panel

On Sunday 04 June 2006 20:38, Marcus Bointon scribble on about: > On 4 Jun 2006, at 23:25, Marcus Bointon wrote: > > I'm having trouble with the prefpane in OS X > > It seems I'm not alone - there are several reports of this in the > MySQL bug tracker. Looks like a bug in the prefpane: > > http://b

RE: Mysqlhotcopy and replication

Excellent Dan! Thanks! -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Thu 6/29/2006 4:35 PM To: Jeff Cc: mysql@lists.mysql.com Subject: Re: Mysqlhotcopy and replication Jeff, that is

stuck on localhost authentication

insert into user (user,host) values ('jeff','localhost'); flush privileges; grant all on databaseName.* to jeff; select user,host from user; returns jeff localhost In Java, I use: DriverManager.getConnection( /localhost/databaseName , 'jeff&#x

subquery performance

I have a query with a subquery which does not throw an error, but does not return either. I've been testing the query using mysql Query Browser and the poor dolphin jumps only once a minute or so ;) I use MYSQL's excellent error documentation heavily so if the query doesn't throw an error, I'm

Re: subquery performance

Thanks for the detailed feedback. I do not create the data so I can't modify it. Your illustration of the table is correct. I'll try to implement some of your feedback. Thanks On 9/25/06, Michael Stassen <[EMAIL PROTECTED]> wrote: Jeff Drew wrote: > I have a query wi

Re: can innodb_buffer_pool_size be set > 2Gb on FreeBSD?

. However, some kernels have things to let you go over, but you get weird results when doing so. Jeff pgpzqaIko4NhJ.pgp Description: PGP signature

Re: drop trigger?

;' at line 1 > mysql> drop trigger testdb.foo; > ERROR 1146 (42S02): Table 'testdb.testdb' doesn't exist > > Seems like a serious bug to me. Why not submit a bug? Jeff pgpx29Q7QtMCz.pgp Description: PGP signature

InnoDB Netapp Snapshot

Create the Snapshot * Issue an "unlock tables;" The reason I ask is that this list is the only place I can find reference to this procedure. Everywhere else talks about either mysqldump or the InnoDB Hot Backup utility for making online backups. Thanks in advance! Jeff -- Jeff Richards

Re: InnoDB Netapp Snapshot

Hi Dobromir, Thanks for the feedback. So you have successfully restored from a Snapshot created in this way? Jeff On Wed, 2005-07-27 at 12:30 +0300, Dobromir Velev wrote: > Hi, -- Jeff Richards Consulting Architect Openwave Systems Asia Pacific +61 415 638757 -- MySQL General Mailing L

mysql command line execution

sword visible on the command line the only way? Thanks, Jeff -- Jeff Richards Consulting Architect Openwave Systems Asia Pacific +61 415 638757 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: is there an active mysql developers list?

it will > default to localhost, using named pipes (i think, but maybe tcp). > > so then there is no need to pass the -h That error message says the socket doesnt exist.. Your either pointing mysql to the wrong area, or mysqld isnt started. Jeff pgpULUOI2faEA.pgp Description: PGP signature

Populating table with test file

groups_namevarchar(15) Would the text file look like: NULLstudents NULLfaculty NULLstaff where I would acutally type NULL or 0students 1faculty 2staff where I would supply the number (would it start with 0 (zero) or 1)? or what else is there? Thanks for the help. Jeff

upgrade 3.23 to 4.12 slowness

userid=user_account1.id order by sex LIMIT 200 Any ideas/help is much appreciated. Im a relative newbie to mysql and databases in general. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: upgrade 3.23 to 4.12 slowness

r(30) | YES | | NULL| | +---+--+--+-+-+---+ 20 rows in set (0.01 sec) I also realized that if I say: mysql> select * from user_stats1; I get an immediate response also. If I use column names it takes a while. It never did in 3.23. Thanks, Jeff -- MySQL General Mailing

Re: upgrade 3.23 to 4.12 slowness

sex='m' AND userid=user_stats1.id AND userid=user_wants1.id AND userid=user_account1.id; Id still like to know why, but at least its a huge start. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: upgrade 3.23 to 4.12 slowness

lack of a primary key was the problem. I am surprised the problem didnt show up in 3.23 but did in 4.12 Thanks for the suggestions! Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQLDUMP Problem

se extended inserts are on by default in 4.1.x. To get multiple inserts (usually slower) use a command like: mysqldump --skip-extended-insert mydatabase > mydatabase.sql -- Jeff Shapiro listserv only address -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: Index update process 20+ hrs

On Monday 29 August 2005 04:55 pm, Alexey Polyakov wrote: > I'd try setting > innodb_buffer_pool_size=8G > in my.cnf Then it will run out of memory. You only get 2gig for bufferpools no matter how much more you have. -- === Jab

Alphabetizing within GROUPS

Hi. Thanks for any help on this. I've been beating my head over it for hours. Here's what I am trying to do: I have four tables I am joining via a unique key (Fellow_id). The results I want to group into three categories, each alphabetized within the group. Is this too much to do in a single q

Re: confirm unsubscribe to mysql@lists.mysql.com

m ?192.168.1.47? ( [71.102.133.117]) > by mx.gmail.com with ESMTP id j7sm287121nzd.2005.09.15.10.03.36; > Thu, 15 Sep 2005 10:03:37 -0700 (PDT) > Reply-To: [EMAIL PROTECTED] > Organization: Nensha > To: [EMAIL PROTECTED] > Date: Thu, 15 Sep 2005 10:03:07 -0700 >

RE: Circular Replication

> -Original Message- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Friday, September 16, 2005 11:55 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: Circular Replication > > > Jeff wrote: > > > > Am I correct in this setup process: >

RE: Timezone setting wrong?

> -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 21, 2005 08:55 > To: mysql@lists.mysql.com > Subject: Timezone setting wrong? > > > I've got a RHEL3 server I just installed with mysql 4.0.16. > > The hardware

Re: Weird database files

> Jeff wrote: > > Had problem with our database this weekend, apparently an > app did an > > insert query that was huge size wise and this totally boogered up > > replication downstream. Also I cant read past that point in the > > binlog using mysqlbinlog on the mas

RE: Weird database files

laves are > up to 4.1.13. > > If you can - upgrade the master server. > It's in the plans but that is our main production server so it's not something we can just do at any time. I've upgraded the slaves first because generally you can replicate from an older version

RE: MyISAM to InnoDB

> "Jeff" <[EMAIL PROTECTED]> wrote on 09/29/2005 08:47:52 AM: > > > > > > Jeff wrote: > > > > > > > > Ugh... > > > > mysqladmin -uroot -ptelaurus processlist | grep -c > "Sleep" And it > > > > re

Encryption for mySQL 3.23

Hi, I need to encrypt data as I insert it into a mySQL database. The data will then be sent as a text file to another institution to be decrypted. I am using mySQL version 11.18 Distrib 3.23.58 for RedHat Linux. I cannot find a single encryption function in the documentation that seems to not cr

encryption syntax

Anybody have an idea why I might be getting the following message: ERROR 1064 (0): You have an error in your SQL syntax near '('hello','password')' at line 1 When I type this in at the command line: SELECT AES_ENCRYPT('hello','password'); Version info: mysql Ver 14.7 Distrib 4.1.12,

Re: Encryption for mySQL 3.23

'password' and the 128 bit key...correct? Where might I find the key so that I can send it along to them? any suggestions on this? Thank you for your help. Jeff [EMAIL PROTECTED] wrote: Make sure your upgrade actually took: SHOW VARIABLES

Re: Cursors in 5.0.13

s running into.. So what error are you getting? Jeff pgpZjgXtyciGn.pgp Description: PGP signature

Re: Detect if table exists from within MySQL?

. 4.1, you can show tables like '%tab%' and you will get a row back if exists.. WARNING, myisam will be quick, innodb will be really slow, specially if the tables are big.. Jeff pgphkfOW9sFUY.pgp Description: PGP signature

  1   2   3   4   5   6   7   8   9   >