Re: Replication issue: I/O thread dies immediately after START SLAVE with no logged errors

aster.info file exists and is blank or doesn't include enough information, delete it. If it's there and looks right, include it's contents in your next mail here (you can blank out the username/password info). Best Regards, Bruce Tierney Thurban <[EMAIL PROTECTED]> wrote: &

Converting Text columns from mysql 4.0 to 4.1

ump files if someone wants to test... Let me know. Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Character Sets, 4.0 and 4.1

tional character sets, and we find ourselves with lost data from the moment we import, and user posts disappearing as they come in. What do we do to not have this problem? Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Social Networking querys

networking engine... ryze appears to be a rather simple/straight-forward list of lists/links approach, whereas linkedin has the ability to allow msgs to only proceed between nodes if one is a 'trusted' node within the chain -bruce -Original Message- From: Balazs Rauzni

RE: Social Networking querys

dathan... given that you work at friendster, aren't you kind of restricted from commenting on how one would go about creating/implementing this kind of system?? if you aren't and you have information to share, then we'd appreciate hearing it!!! regards, bruce -O

Re: Social Networking querys

nick... just from curiousity.. is the code that you've alluded to available for public play. or is it yours/your company's? thanks bruce -Original Message- From: Nick Arnett <[EMAIL PROTECTED]> Sent: Feb 2, 2005 9:08 AM To: listsql listsql <[EMAIL PROTECTED]>

Re: Social Networking querys

duced a kind of 'open source' algorithm describing/explaining/demonstrating how this process can be implemented!!! yeah.. i know.. but it's nice to dream!! anybody interested in sharing ideas!!! -bruce -Original Message- From: Balazs Rauznitz <[EMAIL PROTECTED]>

Re: Social Networking querys

lieve has had a good deal of research from an academic point of view... looks like it's time for a google search! regards, bruce ps. i know, this has only a tangental relationship to mysql!!! -Original Message- From: Balazs Rauznitz <[EMAIL PROTECTED]> Sent: Feb 2, 2

build problem on solaris 8

Hi all, I got the following error during the configure phase: configure: WARNING: term.h: present but cannot be compiled configure: WARNING: term.h: check for missing prerequisite headers? configure: WARNING: term.h: see the Autoconf documentation configure: WARNING: term.h: section "Presen

Re: mysql on OS X

em that we'll start to see CPU use become significant... It'll be like getting two more servers for every server we already have. Best Regards, Bruce On 1/6/05 7:58 PM, "Scott Wilson" wrote: > Hello, > > I'm interested to hear peoples' experiences running m

Re: Fixing "the worst InnoDB corruption bug in 3 years" - when

ion" because we couldn't explain to a client why a problem occurred on beta software, but it's only labeling. MySQL beta typically is more stable than most folks release.1 or release.2 versions. This is because of the very large base of people around the globe using and testing MySQ

Disk Block size

1.8 for Solaris Sparc 64 bit what is the block size mysql uses for writes to disk, and is there a way to control that? Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fixing "the worst InnoDB corruption bug in 3 years" - when

ebruary is too long to wait for this fix to be included in an official binary. In my mind (as I am directly affected by this bug) this one is serious enough to release a new build asap. As a side note with demonstrated performance increases when using innodb_file_per_table why aren't mor

Fixing "the worst InnoDB corruption bug in 3 years" - when

uot; answer won't cut it when we have to deploy into production and MySQL's company line is to only use MySQL official binaries in production. If not 4.1.9 can we call it 4.1.8b and get it shipped (there's already a 4.1.8a). Best regards, Bruce -- MySQL General Mailing

Re: Monitoring replication in mysql

... If mysql isn't running the mysql client returns it's own error saying it's unable to connect). Best Regards, Bruce On 12/28/04 1:44 PM, "Bruce Dembecki" <[EMAIL PROTECTED]> wrote: > Tucker, Gabriel wrote: >> Anil >> >> Write a script that does a

RE: merging of two tables using temp tables???

0 |2 | 0 | NULL | NULL | NULL | | 560 |3 | 0 | NULL | NULL | NULL | | 560 |4 | 0 | NULL | NULL | NULL | +--+--++--+--+--+ 36 rows in set (0.00 sec) if i could figure out how to reorder the table, to group all the 'ID' together, followed by the 'type'

RE: merging of two tables using temp tables???

Cc: [EMAIL PROTECTED] Subject: Re: merging of two tables using temp tables??? If you post your two "original" SQL statements (the ones you use to build your example tables) I think I can help you to merge your results, possibly without the need for temporary tables. Also, what version o

RE: merging of two tables using temp tables???

making this too complex because i can't figure out how to properly/correctly accomplish the original merging process/function to combine the initial two tables thanks -bruce i have a situation where i create the following tables via two different select sql statements. +-+--+--

merging of two tables using temp tables???

27;t shed any light on this one... any ideas/thoughts/comments on how i can do this. thanks... -bruce ps... the actual select sql used to create the 2 tbls are listed: select u4.username as user, u3.itemID as ID, u1.ID as uID from universityTBL as u1 left join university_urlTBL as u2 on u2

RE: increasing mysql/table performance..

ok... here's a section of my tbl defs.. and the sql that accesses it.. are you saying that i should simply redefine the tbls, to create an index on the column name. as far as i can tell from reviewing mysql/google, i don't have to do anything differntly to the sql, in order to use the 'indexes'...

increasing mysql/table performance..

s. now i want to start figuring out how to speed up the app/table interactions... i've read/seen information regarding indexes within a table. i'm curious as to what i can do to speed up the response time/tbl interactions for the users thanks -bruce ps. if need to, i could provide sa

update/join question..

uck.. i'm missing something simple.. searching through mysql.com/google hasn't shed much light!! any ideas/comments/asssistance/thoughts/etc.. thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

strange group/max date question...

that i want the row that contains the max date. the query is only returning the max date, with the other elements in the row coming from who knows where in the table. any idea on how i can achieve the complete row containing the max date??? i've looked through google/mysql with no luck thank

RE: group by issue...??

paul i do a select ID from hTBL group by type and i still only get a single row for each type, where i would expect to get the ~5000 rows, grouped around the 3 different types. what's going on thanks... -bruce -Original Message- From: Paul DuBois [mailto:[EMAIL PROT

RE: group by issue...??

4 | | 160 | 160 | 1 | 0 |3 | 2004-09-11 > 12:23:15 | > +--+---+--+---+-++--+--- > --+ > > i was thinking that a subselect might work, but couldn't get it to work... > > thanks for any pointers

group by issue...??

gle line for each tblType... i was under the impression that i should get the same number of rows returned, but that they would be grouped together. can someone provide an explanation as to how this should work, and what's going on thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: date question..

sorry... still couldn't see how to apply that particular page to my question... still trying to get an answer/solution.. -bruce -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 2:18 PM To: [EMAIL PROTECTED] Cc: 'gerald_clar

RE: date question..

3 | 2004-09-11 12:25:15 | |4 | | 160 | 160 | 1 | 0 |3 | 2004-09-11 12:23:15 | +--+---+--+---+-++--+--- --+ i was thinking that a subselect might work, but couldn't get it to work... thanks for any pointers/comment

date question..

i have a tbl with the following... foo date1 foo2 date2 etc... how can i do a select to get the last or 1st row based on the (latest/earliest) date? can't seem to get it to work.. thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Backing up directly to tape.

How about mysqldump > /dev/nst0 Tucker, Gabriel wrote: Hello All I have been searching the archives and was unable to find an answer. I need the ability to backup MySQL instances directly to a tape device. Currently, I run a mysqldump to disk and have legato pick up the file. As I get to some l

RE: insert/select for multiple tables...

Wednesday, September 01, 2004 10:06 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: insert/select for multiple tables... bruce wrote: > hi... > > trying to figure out how to structure an insert/select for a multiple table > situation... > > sort of... > inse

insert/select for multiple tables...

the syntax for the multiple table insert... searching through google/mysql hasn't shed any light on this.. thanks for any pointers/comments... -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: left join issues!!!

. if you're getting the 4 rows, then i'll send the db/tabls i have to you so you can take a quick look it might be something simple that i'm just missing! thanks -bruce -Original Message- From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2

using temp tables...

to a temp table perform an operation on the information stored within the temp table i'm curious as to how it can be done within the mysql env. searching through google/mysql didn't spell this out to me... thanks -bruce -- MySQL General Mailing List For list archives: http://lists

RE: left join issues!!!

number of different left/right join combinations, as well as trying different ordering of the 'left join' statements... this should be pretty straight forward, but i'm beginning to think it might need to be done in a couple of different steps, assuming i can do it... thanks -bruce -

RE: left join issues!!!

NULL1 158 NULL2 159 NULL3 160 1 4 userTBL nameid tom 1 this is a sample of what the db/tbl looks like for auburn/universityTBL.ID=40 -Original Message- From: Lachlan Mul

RE: left join issues!!!

x27;s the rough structure of the db/tables... right now i have ~2000 records in the universityTBL... -Original Message- From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 6:02 PM To: [EMAIL PROTECTED] Subject: RE: left join issues!!! Bruce, What do you ge

RE: left join issues!!!

PM To: [EMAIL PROTECTED] Subject: RE: left join issues!!! Bruce, A couple of questions... Do you always expect one or more entries in the university_urlTBL for a universityID that is in the universityTBL? If so, then you don't need to left join the university_urlTBL from the universityTB

RE: left join issues!!!

Message- From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 5:21 PM To: [EMAIL PROTECTED] Subject: RE: left join issues!!! Hi Bruce, I haven't reconstructed your database to test for sure, but I think your problem is stemming from the way your joins are working.

RE: left join issues!!!

| 1 | 1 | 0 | NULL | www| | | 1 | 2 | 0 | NULL | www| | | 1 | 3 | 0 | NULL | www| | blah | 1 | 4 | 1 | tom | www| +---+-----+-----+---+--++ anyideas/assistance, etc would be appreciated.

left join issues!!!

orrectly, as i can display the userID as being NULL for the items that haven't defined a user, and the userID is set for the item where the user has been defined.... it should be doable, to create the 'select' using 'left join' statements, and in fact i had it working, or

using NOW() as a default..

solutions as to what i'm missing... thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: a question/issue...

ething i'm missing!!! thanks i can provide you with the initial sample test code... it's only 15-20 lines of code for both the parent/child.. but i'm trying to get a feel for the process to see how this might work. thanks! -bruce -Original Message- From: Jeremy Zawodny

RE: Purpose of "&" (was Re: mysqld_safe)

hi... within the linux/unix world, the '&' at the end of a shell/command normally has meant to run the command as a background process for further information, search google for '& background process linux' etc... -bruce -Original Message- From:

a question/issue...

/criticisms/etc thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql /dbi issues

force a change, and if i can't, then how can i rebuild libmysqlclient.so.10 such that it uses my version of openssl. i can't simply use the default rpm fom mysql thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: building mysql-5.0 clarification

oops... clarification, i'm using mysql-4.1.3. the reason i can't use the binaries/rpms is that i have a dependency conflict with openssl..., so i need to be able to rebuild to make everything work. unless anyone has a different solution... thanks -bruce -Original Message----- F

building mysql-5.0

erl (5.8.0) and communicate with a mysql-5.0 database... all of this was working before i decided to test out the mysql-5.0 searching mysql/cpan/google hasn't shed any light on this issue... thanks... -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

RE: insertion of multiple rows

temp table... any thoughts... -bruce -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 21, 2004 8:51 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: insertion of multiple rows Hi Bruce, You might be interested in the LOAD DATA INFILE syntax

insertion of multiple rows

sible duplicates if i have specified in the tbl design that the element should be unique? would the insert bomb or continue??? thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: [PHP] building php5.0 as an apache module, with mysqli functionality

to the httpd.conf/php.ini files, restart httpd and you should be up/running feel free to make any suggestions/changes.. this should help those who've been struggling to get this working -bruce -Original Message- From: Curt Zirzow [mailto:[EMAIL PROTECTED] Sent: Sunday, J

RE: [PHP] building php5.0 as an apache module, with mysqli functionality

ly doing ./configure make make install the "make" is where i have the "multiple define" errors my ./configure is ==>> ./configure --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc --with -mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config -

RE: i cant connect to mysql from other machine

dev.mysql.com/doc/mysql/en/Default_privileges.html. it discusses the art of setting privs/granting privs for users/databases. good luck/let us know the answers -bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 2:27 AM To: [EMAIL

building mysql from 4.1.3 source

iclly, i'm trying to find out what the command would be also, if i can't do it via the rpm, can i do it, using the mysql 4.1.3 src.gz file. here again, how would i go about building only the component/rpm that i'm looking for... thanks -bruce -- MySQL General Mailing List For

building php5.0 as an apache module, with mysqli functionality

th-apxs2..." works... which is what i would have expected if i didn't tie into the apache mods... any ideas/comments/thoughts/etc, would be appreciated, particularly if you've run across this issue and managed to solve it thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql persistent connection...

ntain the resourceID... thanks... -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Scripts

not sure if it's what you're looking for... but you can always do mysql>"system -uuser1 -ppassword mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:21 AM To: [EMAIL PROTECTED] Subject: Scripts Hi List, Let's suppose that I have a script to create one database (tables, indexes, etc). H

RE: table layout structure

ityID requires that i now duplicate data within the system... which i want to keep to a minimum!!! thanks.. -bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:13 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: table

table layout structure

ve "foo1_id" in table foo2 as it is a duplicate of "foo1.id" i'd really like to be able to do something like "unique key (id, name, foo1.id)"<<<<< any thoughts/comments/criticisms... thanks -bruce -- MySQL General Mailing List For li

table layout structure

ike to be able to do something like "unique key (id, name, foo1.id)"<<<<< any thoughts/comments/criticisms... thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql...transaction question

eck errors/rollback if ($@) { $dbh->rollback(); } else { # commit $dbh->commit(); } any comments/criticisms/thoughts/etc... thanks... -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql - transaction processing question

possibly cause an issue...??? i didn't get a clear understanding from mysql/google as to whether this might cause an issue... comments/criticisms/thoughts/etc... thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

database type questions... (bdb/innodb/myisam)

l properties of the "bdb" with the ability to commit/execute/rollback/etc... that this would solve my problems... any thought/comments/criticism/etc... thanks... -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

basic select question...

torTBL.name = "dr smith1"; Empty set (0.01 sec) mysql> select * -> from instructorTBL -> where instructorTBL.name = "dr smith1"; Empty set (0.00 sec) thanks... -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

another left join question - multiple "left join" statements

g at mysql/google, i'm still missing something... any comments/criticisms appreciated.. thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

basic question about joins....

ityTBL.name='sam'; ERROR 1066: Not unique table/alias: 'universityTBL' any thoughts/comments as to what's wrong... it's got to be something basic... perusing through google/mysql/etc.. hasn't shed any light on where the issue is... thanks for any comments/

RE: mysql sql files...

to clairfy it looks as though the "source" function/command allows you to use the script from inside the mysql env... disreagrd.... -bruce -Original Message----- From: bruce [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 5:22 PM To: [EMAIL PROTECTED] Subject: mysql

mysql sql files...

hi.. i can run sql files that have sql statements by : shell:>mysql -u -p http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql sql question

sday classtime instructorID instructorTbl name dept phone email universityID instructorID does this make sense... any thoughts/comments/critcisms i'm not a db guy by any stretch.. but this should scale to handle 100s of universities with no prob... thanks -bruce -Origin

RE: mysql sql question

, which in turn is based on a parent tbl... thanks... -bruce i can't see how this would work at all... unless you're saying the select will return "tom" and stuff that into the dept table as the "name" value. and where/how would the "collegeid"

RE: mysql sql question

rsion for the right syntax to use near 'select id from test where name="sammy"' at line 2 i've tried a number of different iterations.. any ideas as to why this doesn't seem to work... thanks -bruce ps. also, if i do/can manage to get this to work, shouldn

RE: mysql sql question

me = $ownername; -bruce -Original Message- From: Emmett Bishop [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: Re: mysql sql question Bruce, what you want it the insert into ... select statement. It's like this: insert into dog (name,

RE: mysql sql question

my bad... should have mentioned that both the owner and dog name are unique, but one owner can have multiple dogs... so just how does the "insert ... select" work.. it looks like it could actually do what i need, but i can't seem to get it working correctly.. -bruce -O

mysql sql question

l script where i can do this using multiple sql statements.. but i'm trying to see how to do it in a single statement... any comments/criticisms would be helpful... thanks... -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

granting user privs...

-> ON temp.* -> TO 'test'@'192.168.1.%' -> IDENTIFIED BY 'passwd'; mysql continues to say that 0 rows affected... the mysql docs and other sites i've seen seem to suggest that this is a valid way to add additional privs to a user.

RE: iptables and mysql...

s is not a mysql question, and please do not cross post. Any good book un Linux networking will cover this. Open port 3306. bruce wrote: >hi... > >i'm investigating what needs to be done to allow mysql on a server to be >used remotely by client machines. each machine is running

iptables and mysql...

at will be communicating with the mysql box... also, how would i test that the iptable/mysql configuration setup is working properly... i have rh8.0 and mysql v11.18-dist3.23.54 any pointers/comments/criticisms or actual iptable configs illustrating this would be extremely helpful!!! thanks -bruce

Mac OSX Tiger and 64 Bit

single machine with different databases - but it's aheadache to administer... I'd rather use my 65 bit hardware and MySQL's 64 bit builds and use the memory in the machine in a single instance... Comments welcome. Best Regards, Bruce -- MySQL General Mailing List For list archives

basic information on setting up a mysql db for remote access...

he here's how you do it process... i'm trying to get to the step 1, step 2, step 3, etc i already realize that if i screw this up..i might get locked out of the database...!!! thanks for any pointers/comments/criticisms/etc... -bruce -- MySQL General Mailing List F

RE: table-is-crashed bit?

d give it a shot. Specify a tmpdir that is on a disk/volume that gets little use and has plenty of space, if possible. Best of luck! -Bruce Bristol -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqlbindump feature request...

se for the information to dump... I want to specify a server id... Eg I want to dump from binary-log.23 all the information that has a server id value of 12. I was thinking something like: mysqlbinlogdump --serverid=12 binary-log.23 Best Regards, Bruce -- MySQL General Mailing List For list arch

Links to myisam database files

Hi all, I'm using 3.23.49a-max-log and as a temporary fix for a disk space problem, I shut mysql down,, moved some database files to different partitions on the system and symlinked them back into the datadir. Everything seems to work ok... So far... Mysql came up with no errors, selects and in

RE: basic mysql setup

and what the h*^* are you doing up at this time of night!! thanks... -Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Sunday, May 16, 2004 12:51 AM To: MySql Subject: Re: basic mysql setup on 05/16/2004 12:52 AM, bruce at [EMAIL PROTECTED] wrote: > > i&#

basic mysql setup

help you can provide with this!! bruce [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple Mysqld Stability and maintanability

It works. It works very well. As Jeremy said, just make sure you are very explicit in your configuration and startup Jeremy Zawodny wrote: On Tue, May 11, 2004 at 09:26:57AM +0700, Winner H Manurung wrote: Dear All, I was an Oracle dba, now my new company want to use Mysql 4.0.18. Does anybod

Storing App Settiings

stored as a string, or store one record with a separate column with the appropriate data type for each setting. How have others done this? What method is the fastest/most flexible/easiest to maintain and extend? --Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com

lower_case_table_names, Mac OSX, InnoDB and 4.0.18

7;t run with it), so we can not upgrade to 4.0.18. MySQL seems to be ignoring our my.cnf startup value for lower_case_table_names and InnoDB seems to be unable to find our tables if MySQL changes the case to lower case. Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OSX 10.3 Binaries and 64 Bit

of getting the source code and compiling it on our systems? Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Master refusing Replication connections

clients... Our next scheduled maintenance window isn't till Friday morning, I don't want to run on one server for a week here. Anyone got any ideas or suggestions on how I can resolve this issue? Will bouncing even help me? Best Regards, Bruce -- MySQL General Mailing List F

accumulating query

restart mysql I get back to 2 rows returned. I have reproduced this on two Windows 2000 boxes. What's going on? Why do I keep adding on to the result set? When I drop back down to 4.0.13 this problem disappears! Is this a bug in 4.0.18? Thanks, Bruce

UNION caches query?

45 |45 | 2004-02-11 16:30:00 | 2004-02-11 17:30:00 | A simultaneous event |45 |45 | 2004-02-11 16:30:00 | 2004-02-11 17:30:00 | On top of old smokey SNIP... Is there a cache setting that I should be turning off here...I should get 16 rows for each query. (SQL_NO_CACHE has no effect). Thanks, in advance, Bruce Altner

Re: Memory Problems on a G5/OSX/MySql4.0.17

> On Jan 28, 2004, at 12:01 PM, Bruce Dembecki wrote this wonderful stuff: >> >> So.. My tips for you: >> >> 1) Consider a switch to InnoDB, the performance hit was dramatic, and it's >> about SO much more than transactions (which we still don't do)! &g

Re: Memory Problems on a G5/OSX/MySql4.0.17

ons, but it turns out InnoDB is much better at large databases than MyISAM in many many situations. All I was saying is that InnoDB isn't JUST about transactions. Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Memory Problems on a G5/OSX/MySql4.0.17

ar I can push the InnoDB Buffer pool... As you can understand we don't like to bring down our servers for this type of testing. Clearly our performance isn't too bad or I would have focused on this sooner. Best Regards, Bruce Here are our memory related settings from our G5s: set

Re: Help:)

you need a smeicolon at the end of the line Don Matlock wrote: Thank you very much for the prompt reply. Yes you were correct, it was the fact that the password had not been entered at all...I did the mysql -u root -p when prompted for the password I just hit enter and was able to get in. Now I

Re: Running 4.0.17 and 5 on same machine

I'm doing just that right now. I built from source and put mysql4 in /usr/local/mysql and mysql5 in /usr/local/mysql5 with the my.cnf is /usr/l.ocal/mysqlX/var. In the my.cnf file I put the local sockets into /usr/local/mysqlX/tmp and mysql5 is using port 3305 with mysql4 on 3306. The toughte

relative performance between innodb and myisam

we have a bit of a debate going on at work. The gist of it is that there is a a performance hit when using innodb tables vs myisam tables. I understand the for a given dataload innodb will be larger, but is there a performance hit as well? If so, as a rough comparison, how much of a hit is it?

Counting total files

We have a database that has a quantity of files listed for each client record. We can count the number of clients, but how do we count the total number of files for all clients combined? -- Bruce Therrien <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives

Re[2]: Retrieving info from a Joined column

repare ( $query ); $sth->execute ($downloads,$user); Any ideas? On Sat, 29 Nov 2003 00:53:10 +0100 "Hans van Harten" <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > >> From: Bruce Therrien <[EMAIL PROTECTED]> > >> Date: 2003/11/28 Fri PM

Retrieving info from a Joined column

for all database entries and retrievals. Sample data 1223:1897:9807:36754:20875 Thanks, -- Bruce Therrien <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

<    1   2   3   4   5   6   >