Re: cobalt binary version

what's there now, since they seem to be ignoring the MIPS based equipment lately. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivek

Re: Re: Help with FreeBSD 4.2 Native Threads (was: Compile broken:

Your filter really makes having a discussion difficult. I think I'll just go away. > "m" == mysql <[EMAIL PROTECTED]> writes: m> Your message cannot be posted because it appears to be either spam or m> simply off topic to our filter. To bypass the filter you must include m> one of the fol

Re: Help with FreeBSD 4.2 Native Threads (was: Compile broken: mysql-3.23.38/mit-pthreads)

> "DF" == David Favor <[EMAIL PROTECTED]> writes: DF> The problem is the Web hosting service I use does not have this DF> package installed. In other words, there is no libpthreads.* in DF> any of the library directories. But FreeBSD native threads do not need any libpthreads.* files. Your

Re: how force mysql to use certain indexes

p to the language interpreter and optimizer to do it efficiently. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vive

Re: MySQL 3.23.37 released

> "MW" == Michael Widenius <[EMAIL PROTECTED]> writes: MW> We are just now building the first MySQL-Max binaries with support for MW> Berkeley DB and InnoDB tables. The first one will be a Linux x86 RPM Does this imply that BDB tables are stable enough for production use, or is it still con

Re: Indexes on Nulls

dexes on nullable columns. ISAM did not. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: v

Re: Mysql speed :)

#x27;3',2 and resulting in a parse error. The fix was to call $sth->execute($start+0,$howmany+0) and then DBI did the right thing. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTE

Re: Running crash-me against remote M$ SQL Server

> "GC" == Gerald Clark <[EMAIL PROTECTED]> writes: GC> Perl/DBI, or any mysql client on Linux should connect to mysql on NT GC> with no problem. Why would you need ODBC? Except that perl/DBI requires an underlying C library for the DBMS in question. I understand that the sybase libs might

Re: email only two columns

il. Perhaps you need to write a program that queries the database and then sends the mail you want. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-45

stability documentation up to date?

not stable. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.

Re: MySQL 3.23.36 is relased

> "MW" == Michael Widenius <[EMAIL PROTECTED]> writes: MW>* Added `SET TRANSACTION ISOLATION LEVEL ...' How about documenting this? http://www.mysql.com/doc/S/E/SET_TRANSACTION.html is quite uninformative as to what the different levels mean. --

Re: mysql_auth HELP!

be sure to download the instructions with it. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---

Re: MySQL vs PostreSQL ??

ed to evaluate them both yourself probably with some benchmarks and then decide which is "better". -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD

DBD::mysql to support transactions?

ary... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vi

mysql_convert_table_format ignores my.cnf password setting

connect to database vkmlm: Access denied for user: 'khera@localhost' (Using password: NO) >Fix: supply --password=SomeThing on mysql_convert_table_format command line. >Submitter-Id: >Originator:Vivek Khera >Organization: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

multiple charsets per server?

e the japanese charset while leaving the other tables and DBs alone (using default Latin1)? Is this possible withour running multiple instances of mysqld? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [

Re: mysqldump Error

see what it has to say. Also, what are your mysql permissions (from the GRANT commands you've issued) for your currently logged in user? Also, is the mysql daemon process allowed to write to the directory you are asking it to write to? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: HOWTO: Get column types & enum values using perl

an if ($$types[0] == &Mysql::FIELD_TYPE_STRING) you are doing an assignment, not a comparison. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-

Re: Setting a specific default value on a field

le the position of B can be left what's wrong with INSERT INTO goo (A,B) VALUES (NOW(),A) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-45

Re: Having a hard time installing MySQL

build mysql from ports. I'd highly recommend upgrading to FreeBSD 4.2-STABLE so that you also get the very important C++ library/compiler fixes. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PR

Re: Long deletes

ete things in batch size of $limit (I use 200 rows), and sleep between the deletes to let other threads do their thing with not too much delay. Ideally, MySQL would allow the delete to be concurrent with other operations. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Viv

Re: Multiple Column list index

MAIL PROTECTED]> M> To unsubscribe, e-mail <[EMAIL PROTECTED]> M> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL

Re: mod_auth_mysql

ote I have to add is that if you also use php4 with mysql built-in, then absolutely make sure that php is built to use the system mysql library and not its own copy. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, In

Re: Binary distribution on FreeBSD4.0

s d> probably an easy fix but here goes. When I try and run Your best bet on FreeBSD is to build the MySQL port form /usr/ports. It is really well done. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Inte

Re: Off topic, help please!

trate if it is incorrect. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera htt

Re: Linking MySQL with other programs

>"-lm" has been specified in the linker option line. Before or after the -lmylsqlclient flag? It needs to be after. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EM

Re: taxes

> "MK" == Mikel King <[EMAIL PROTECTED]> writes: MK> guys I think you are making this a way bigger problem than it MK> really is...e-merce crap is generally taxed based on the location MK> of the vendor; much the same way in which mail order businesses MK> are taxed. You really only have to w

Re: table too big to dump?

> "BR" == Brian Reichert <[EMAIL PROTECTED]> writes: BR> When I try to do a mysqldump on the localhost, I get an out-of-memory BR> error: BR> # mysqldump -uroot -proot customer audit_trail_271 BR> mysqldump: Out of memory (Needed 8164 bytes) BR> mysqldump: Got error: 2008: MySQL client

RE: problems running mySQL via Telnet

> "TT" == The Tilghman <[EMAIL PROTECTED]> writes: TT> You're trying to use a Telnet client with a MySQL server. Instead, TT> use a MySQL client with a MySQL server and a Telnet client with a TT> Telnet server. Mixing protocols doesn't really work for anybody. well, you can use the telnet

Re: Boolean Datatype

> "RD" == Russ Davies <[EMAIL PROTECTED]> writes: RD> Thanks for the suggestion, but this would still mean converting the data RD> type from within ASP (the 'True' type) down to a char ('T') would it not? then use ENUM('False','True') instead. Enum can have any string you want. I person

RE: MySQL Memory Requirements...

> "DK" == Daniel Kirk <[EMAIL PROTECTED]> writes: DK> 30gb eide hdd DK> Will the machine fall over because it doesn't have enough ram/CPU DK> power (for about 20k users per week as below)? any ball park DK> comments eg no worries, close call, not a chance? Your bottleneck on a database is

Re: problems migrating from mysql 3.22.22 to 3.23.32

> "NR" == Noah Romer <[EMAIL PROTECTED]> writes: mysql> insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue) NR> values (334,18,20010131145149,'bug_status','NEW','RESOLVED'); NR> ERROR 1064: You have an error in your SQL syntax near NR> 'when,field,oldvalue,newvalue) values NR>

Re: mySQL IS winning

> "RH" == Rolf Hopkins <[EMAIL PROTECTED]> writes: RH> That also depends on your definition of *PRODUCTION* status. If you are RH> going to make a profit using MySQL then you need to purchase a license. Not any more; MySQL is GPL in the current version. --

Re: mySQL is winning

I beleive, is that Oracle finds MySQL such a threat to their business that they have to put out a migration kit to make it easy for people to switch to their product. It shows that the popularity of MySQL is being taken seriously by the majors. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: Running two "Makes"

> "EJD" == Evan James Dembskey <[EMAIL PROTECTED]> writes: EJD> is it possible to install Gnu make onto teh Dec in a way that it does not EJD> interfere at all with the rest of the system? If so, how do I do it? When you install gnu make, call it "gmake". Then run "gmake" when you need it.

Re: Backup?

ing? See mysqlhotcopy that comes with recent mysql versions. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera

Re: idle CPU

> "TS" == Tim Samshuijzen <[EMAIL PROTECTED]> writes: TS> We're running a large database on a dedicated server. TS> When I look in the list of active processes, I notice that a TS> complicated query takes up no more than about 30 % of CPU. TS> During this time the CPU is more than 60 % idle

Re: Problem with the UPDATE

> "GLC" == Gerald L Clark <[EMAIL PROTECTED]> writes: GLC> You do not say what version you are running. GLC> Older versions did not allow updating the primary key field in that GLC> manner. he's not updating the primary key field.

Re: MySQL Install trouble on FreeBSD4.2

nuary (ie, update FreeBSD to 4.2-STABLE). -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vi

Re: What causes table corruption? (isamchk -r required)

> "jds" == j d stumbles <[EMAIL PROTECTED]> writes: jds> I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes jds> updating the tables concerned continuously, via REPLACE INTO, INSERT INTO jds> or UPDATE statements. I've never had table corruption on a Solaris box, even

Re: BSDI 4.2?

> "AH" == Alan Halls <[EMAIL PROTECTED]> writes: AH> Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an AH> error during the make command. Using extreme powers of mental telepathy, we might be able to guess your problem. However, if you told us exactly what the erro

Re: What proportion of sites use MySQL.

cs are just made up, I made one up for you ;-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

Re: mySQL vs Oracle

> "AR" == Ann Ricchiazzi <[EMAIL PROTECTED]> writes: AR> I am trying to choose between mySQL and Oracle for a Linux server. My AR> specific questions are: AR> 1) Will mySQL handle 3000 hits/day well? You need to define what a "hit" is. Is it a simple select on the primary key of a single t

Re: INSTALLATION QUESTION on Cobalt Raq3

> "l" == lkeeton <[EMAIL PROTECTED]> writes: l> First does anybody know the website address for that searchable l> site that allows you to search on mysql archive emails. I would l> appreciate if I could get that. I also am looking for opinions on Does anyone read the footers on the message

Re: inserts with now() resulting in replication-problems

> "JK" == Jan Kirchhoff <[EMAIL PROTECTED]> writes: JK> If the Slave gets out of sync (loses the connection to the server), connects JK> again and tries to catch up, it processes those two queries *within one JK> second* which would result in an duplicate primary key on the slave. The JK>

Re: bug in 3.23.22-beta

> "MS" == Marc Swanson <[EMAIL PROTECTED]> writes: MS> As you can see the date field has been updated to the current date/time even MS> though the update query was only supposed to modify the text field. For MS> claarity the date field started out with 2001-01-07 08:00:00 and ended up MS> wi

Re: [Make Crashes and Burns on myisam - "Don't know how to make mi_test_all"]

> "MW" == Matt Wagner <[EMAIL PROTECTED]> writes: >> As far as I know, just try building it on an i386 running BSDI 4.1 MW> Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he MW> could give Aaron here some pointers. Try using gmake for bsd systems. The makefiles are proab