Re: cobalt binary version

the MIPS based equipment lately. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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: 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 best bet on

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 following

Re: how force mysql to use certain indexes

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 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 considered

Re: Indexes on Nulls

ISAM did not. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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: 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 be able

Re: email only two columns

at queries the database and then sends the mail you want. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_kh

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.

stability documentation up to date?

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 ??

hen decide which is "better". -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://

DBD::mysql to support transactions?

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

multiple charsets per server?

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

Re: HOWTO: Get column types enum values using perl

doing an assignment, not a comparison. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://

Re: Setting a specific default value on a field

at'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-453-8497 AIM: vivekkhera Y!: vivek_kh

Re: Long deletes

her threads do their thing with not too much delay. Ideally, MySQL would allow the delete to be concurrent with other operations. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED]

Re: Having a hard time installing MySQL

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 PROTECTED] Rockville, MD +1-240-45

Re: mod_auth_mysql

-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, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-

Re: Multiple Column list index

ql.com/php/unsubscribe.php -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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: Binary distribution on FreeBSD4.0

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. Internet: [EMAIL PROTECTED] Rockville, MD

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: [EMAIL PROTECTED]

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 worry about

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 run out of

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 client to

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 personally

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

h 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. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.

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: 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. TS Is

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 with

Re: MySQL Install trouble on FreeBSD4.2

4.2-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: 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: 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 errors were,

Re: What proportion of sites use MySQL.

? How can you even tell when a site is database backed let alone what database it is using? You just can't do it. So therefore, sticking with the rule that 93.234% of all statistics are just made up, I made one up for you ;-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

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 messages they

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 table or a

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 Slave