Re: data types

-- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Dual Processor and MySQL !

On Sun, Apr 01, 2001 at 02:55:02AM +0330, Hamid Hashemi Golpayegani wrote: Therefore if I am using Linux for my MySQL server both of my CPU's will help to serv the MySQL queries if I am installing the SMP in my kernel right ?! Correct. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo

Re: ---- Virus Detected ----

On Sun, Apr 01, 2001 at 07:58:19AM +0200, Benjamin Pflugmann wrote: I got the warning too, and also run Linux. So this doesn't seems to be connected to the operating system. And neither to a certain thread: I got it on mails to abitrary threads. Same here. -- Jeremy D. Zawodny, [EMAIL

Re: Need examples of companies using mysql

quite a lot and even manage to generate money once in a while... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting

Re: safe_mysqld options

-- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: File size problem!

the database file size after I delete a lot of records? Thanks in advance. OPTIMIZE TABLE talble_name Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: Synchronization

On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote: I have two mySQL servers, one is in office, and other at home. I need to synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can somebody help me ? Does MySQL replication suit your needs? Jeremy -- Jeremy D

Re: mySQL for Sun Intel

-- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: MySQL vs MS-SQL performance

-SQL server to make the communication go somehow faster. Anyone had similar experiences to mine? Odds are that you didn't tune MySQL at all. Unlike most commercial database servers, MySQL "out of the box" isn't tuned for heavy usage. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Techn

Re: Replication troubles

ally nothing related in the *.err file on the slave? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check:

Re: Does repliation impact on performace?

. The slaves purpose is to act as a backup for the master. Will the slave slow down the master server? Is the performace of a master server in any way dependant upon the performace of its slaves? In my experience, the slave places a negligible load on the server. Jeremy -- Jeremy D

Re: SQL Market share

) and get in touch with him. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com

Re: size limitation

... But I'm sure they're out there somewhere. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http

Re: Let me see

p of MySQL. There's also some stuff on sports.yahoo.com and lots of other *.yahoo.com sites. Maybe a little description on how the DB works and all. If I had the spare time now, I'd do it... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878

Re: MySQL vs Microsoft SQL

who have mailed bug reports directly to the core developers and received a response in less than 12 hours... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: speed of list

On Wed, Mar 21, 2001 at 10:01:23PM +0100, Ren Tegel wrote: the email list seems to be very slow now and them... wouldn't it be an option to make a web-based list ? In addition to the e-mail version, or instead of it? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance

Re: HELP!!!

On Fri, Mar 23, 2001 at 09:16:48PM +, Daniel Adams wrote: Can anyone tell me how to fix this error: ERROR 1016: Can't open file: 'message.MYD'. (errno: 126) Fix the file permissions so that mysql can read the file. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance

Re: Multiple master replication

? Thanks Wayne A logical slave may only have one master. But there's nothing to prevent you from running multiple copies of MySQL on a physical machine. Each copy can be the slave of a different master. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328

Re: why 3 processes?

-- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Read/write table lock

nd what is the error message? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manu

Re: setting a new default nice value

the client? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php

Re: suggestions for implementing heavily used log tables with nightly delete

got a bit of time to hack on it, that may help. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http

Re: Will MySQL_Linux_Apache handle Yahoo level traffic data?

, Google or E-Bay? Same answer. 3 - Does MySQL have an equilivant to "stored proceedures? Not today, no. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439

Re: Traffic accounting

the customers accessing the same data, or separate data? If separate, you could run a server for each (assuming there are few customers) and run them each on different TCP ports. Then you just need to measure traffic to/from those ports. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo

Re: Alteon + forks

is. Can you provide a bit more detail? Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check

Re: ARCHIVING UNDER HEAVY LOAD

to archive in background mode. What about MySQL? See my message to Nathan with: Message-ID: [EMAIL PROTECTED] and the related thread for the discussion of a similar topic. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell:

Re: MySQL 3.23.35 is released

and/or slower basic select/insert queries. There have been a varitety of Innobase vs. MyISAM benchmarks posted in the past few days. I'm sure more will follow. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439

Re: MySQL 3.23.35 is released

On Sun, Mar 18, 2001 at 03:31:47PM -0500, [EMAIL PROTECTED] wrote: On 17-Mar-2001 Jeremy D. Zawodny wrote: Er. Is there any way you guys can actually form a stable branch, and a development branch? It would be nice to get a stable version of mysql with replication, and that's

Re: Unique/Index/Primary

in it. A UNIQUE one may not. A PRIMARY KEY is simply another way to say "UNIQUE" with the side-effect that the PRIMARY KEY is stored first in the index file for the table. So UNIQUE is a special case of INDEX, and PRIMARY KEY is a special case of UNIQUE. Jeremy -- Jeremy D. Zawodny, [EMAIL

Re: Updateing row contents

would like to update it, how can I do that? Using the UPDATE command. See the manual for details. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 --

Re: Mysql restarts at 100% CPU

On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p wrote: my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? What does the error log say? Anything? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878

Re: MySQL 3.23.35 is released

in their work to label the code "stable". I'd say their track record (and the thousands of satisfied users) says a lot about their judgment. Some may not agree with it, but that is how they've done things. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance

Re: MySQL 3.23.35 is released

n compile in the new features, there's little danger of them affecting you. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before p

Re: MySQL 3.23.35 is released

D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: forwarded message from Van

related to this sort of a setup that was fixed in a VERY recent version of MySQL? I noted a change in the logs for .33 or .34 but it wasn't very specific. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408

Re: Regexp matching

s "Health : {words] : {words]". I've tried combinations of [\w] and[a-zA-Z] but they're all or nothing-- either I get all of the results with one or colons or none of the results. Any help would be appreciated. What about "Health : [^:]*$" ? Jeremy -- Jeremy D. Zawodn

Re: MySQL Database and NAS

data, one server has no way of knowing that cached indexes are out of date based on updates by another server. Even with it's external locking support? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408

Re: How many rows does a table can hold?

be little need to split them out into their own tables. Speed shouldn't be an issue if it is indexed properly. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408

Re: Failover and Replication

in regards to rolling our own monitoring script? What about having a dual-master setup? It's a bit tricky to get right, but it certainly can work. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: MySQL takes too much memory

. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Any ideas why this would happen....

) and then (usernum), your bases are covered. Creating a sinle index on (userid) is not necessary. The docs will explain why... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: Innobase SHOW VARIABLES (Re: getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34)

On Tue, Mar 13, 2001 at 09:48:22PM -0800, Jeremy D. Zawodny wrote: On Wed, Mar 14, 2001 at 02:42:30PM +0900, Tatsuhiko Miyagawa wrote: On Mon, 12 Mar 2001 10:02:51 -0500 [EMAIL PROTECTED] wrote: I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql errors

Re: Innobase SHOW VARIABLES (Re: getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34)

On Wed, Mar 14, 2001 at 03:51:18PM +0900, Tatsuhiko Miyagawa wrote: Oops, really :-) Yes, he posted it in the message with Message-ID: [EMAIL PROTECTED] Jeremy On Tue, 13 Mar 2001 22:48:58 -0800 "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: I can produce a core/backtrace if

Re: Problem with replication

d into the docs or fixed. I'll find out if it is a bug or not first, I guess. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: Problem with replication

). The information in master.info is correct now, but still it gets an access denied. The password is right, the user is right, the hostname is right.. sigh. Hmm... Anything relevant in the server's error log? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878

Re: am I alone? (scale)

trouble. What OS are you on? Did you compile your own mysql, or are you using one of the provided binaraies? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: am I alone? (scale)

cpu time, the whole system will suffer and start to spiral down into places you'd rather not look. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: key lengths

), - UNIQUE(name(500)) - ); ERROR 1089: Incorrect sub part key. The used key part isn't a string or the used length is longer than the key part No key part can be greater than 255 in lenght. But multi-part keys can be longer (in total) than 255. Jeremy -- Jeremy D. Zawodny, [EMAIL

Re: locking oddity

ests to be very fast.. the default behaviour does not seem to meet this objective? Correct. If you always blindly give selects priority, it is possible (on a busy site) for inserts to take a very long time to complete. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (

Re: BDB tables on Linux

that they're created properly? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http

Re: About licence

. Pleace answer me, it is very important for me. Thank you. Piotrek MySQL is now under the GPL. So if you want to spend the money, you can purchase a support contract from mysql.com. There are details on their site. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance

Re: BDB tables on Linux

-related variables to /etc/my.cnf? You must compile the BDB support. It's currently not in the RPM. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: DBD::mysql

.. one of which being: what is the path to mysql? I don't have a path to mysql as it is not installed and I don't want to install it. Is there a way to install DBD::mysql without having to install mysql? You at least need the MySQL client libraries on that machine. Jeremy -- Jeremy D. Zawodny

Re: Long deletes

'end'. How big is your key_buffer? record_buffer? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http

Re: Sample .cnf files

package or are they somewhere else? Really? Is there no "support-files" subdirectory (or something similar) as their is on the Unix side of things? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408

Re: Security annoucement mailing-list ?

announcements list. It is already VERY low-traffic, and that seems like appropriate content. No sense creating another list just for the VERY occasional announcements when we already have one [mostly] for that purpose. Thoughts? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance

Re: LIMIT usage

Then the numbers will be SMALLER as you go into the future, so you can sort them easily. But there are many cases in which this isn't a good idea. So it may work for you, or it may not. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax

Re: auto_increment

first? Is there a way to bypass this? Logically, going from 45 to 1 or 2 or 3 isn't an "increment", it's a decrement. If you never want holes in the series, then auto_increment may not be the best option for you... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yah

Re: Temporary tables, BDB tables, and Innobase questions

the public bitkeeper repository. Instructions were posted on this list a while ago. Should be in the archives. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: mod_auth_mysql

http://modules.apache.org/ I have searched the list archives here and indeed turned up 254 instances of people having problems with mod_auth_mysql. Yeah, it's been pretty common. If nobody *IS* maintaining it, you could always take it over. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED]

Re: Index Usage weirdness

. This is documented in the manual (though maybe not with hard numbers). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before

Re: Re: Replication question.

http://www.mysql.com/doc/N/e/News-3.23.33.html you'll find an entry which says: Fixed bug in replication that broke slave server start with existing master.info. This fixes a bug introduced in 3.23.32. I'd suggest and upgrade to see if it solves your problem... Jeremy -- Jeremy D. Zawodny

Re: create table

-- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: ?difference between Primary Key, Key, Index, Unique

is a Unique Index. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php

Re: Index Usage weirdness

.id=c2.id ORDER BY c1.txt; How much data is there in those tables? What does the output of EXPLAIN on that query look like? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: Redirection of SELECT with replicated databases

that will redirect non-read-only queries to the master. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check

Re: ReisserFS

On Thu, Feb 22, 2001 at 03:22:13PM +, Simon Windsor wrote: Hi Has anyone user MySql on a ReisserFS file system ? Yes. Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? It "just works". :-) -- Jeremy D. Zawodny, [EMAIL

Re: installing on linux

the build process. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php

Re: The security concerns about MySQL

of the manual? My program is using MySQL3.22. Are there advisories out on MySQL? I'd suggest moving up to 3.23.xx. If you find problems with 3.22, you'll likely need to upgrade anyway... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530

Re: indexing

read them in "index order" without having to re-sort them. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posti

Re: XML support under mySQL

don't think that the mysqld process show know how to do it. Then again, it wouldn't be HARD to do. I just hope then if it happens, it is a compile-time default so that I can disable it on my servers. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328

Re: XML support under mySQL

D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: So, just how long should it take the make install to run?

quite a while... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php

Re: Mysql and Labview?

ql Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: client -- server versions ?

to 3.23 server, and am wondering if this is this cause. Have you tried it with a 3.23 client? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: Connecting to 2 separate MySql databases

on their servers. Yes. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php

Re: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x

been adapted to fit in with MySQL's table handler interface? Thanks! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting

Re: DROP COLUMN

OLUMN Personnel" and i get the error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. please help I think you've confused MySQL and Microsoft SQL Server. -- Jeremy D. Zawod

Re: Help, Server error.

anything I get this error: 010218 4:02:54 Aborted connection 17 to db: 'mysql' user: 'root' host: `localhost' (Got an error writing communication packets) Is it causing problems, or simply filling your logs? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk

Re: Performance of Heap table?!

of the query optimizers' tricks don't apply to HEAP tables because the keys are based on hashing rather than B-tree structures. The manual describes some of benefits and drawbacks of HEAP tables. You may want to double-check what it says and compare it to what you're doing. Jeremy -- Jeremy D. Zawodny

Re: Index not used for order by when more than 1 field selected, no where clause

question is: Is it a way to tune this threshold ? AFAIK, currently the only way is to change it within the source and recompile MySQL. It shouldn't be hard to make that a tunable parameter via /etc/my.cnf. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408

Re: Help, Server error.

was when we had a bad Ethernet card in a machine. It would randomly drop network packets, close connections, etc. Can you rule out network problems? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: MYSQL Question

On Sun, Feb 18, 2001 at 08:24:47PM -0500, J Colleary wrote: Does MYSQL support the CREATE PROCEDURES command, or have stored procedures? If so, how do I access them? Nope. This is documented in the manual. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk

Re: MySQl with SSH

on the database server via an SSH connection: ssh -f -L 12345:server.foo.com:3306 sleep 9 (or something relatively similar) Then I just tell the client to connect to localhost on port 12345. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878

Re: taxes

On Wed, Feb 14, 2001 at 01:32:24PM -0700, LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. Using MySQL? -- Jeremy D. Zawodny, [EMAIL PROTECTED

Who is using BDB tables in critical environment?

locking has improved the performance of my application, which was previous bound by MyISAM table locks. Is anyone ready to say such a thing? Or something close to it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell

Re: DELETING CACHE

any page visited while a person was logged in. Someone on a mailing list that deals with Java servlets probably can. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: Mysql Stability

on the hardware you are using. MySQL can easily handle multi-gigabyte databases on reasonably modern hardware with sufficient RAM. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: Should I switch to SCSI HD for mysql?

bound now? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php

Re: blob and replication questions

replicating blob data (ok: is doesnt say it is NOT possible). can this be done? does anybody have experience in replicatin blob-data (largeblobs)? BLOB fields replicate just fine in my experience. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878

Re: Page Locking in 3.23

On Sun, Feb 04, 2001 at 01:03:47PM -, Phil Taylor wrote: Hi I can't find any documentation that explains how to activate page level locking on BDB tables - is page level locking the default when a CREATE TABLE is done? Yes. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo

Re: sth-execute - screen/file output

o this. did i miss anything here? A couple of points: (1) You should really `use strict' in your Perl code. (2) The return value of $sth-execute is not what you expect. Check the DBI docs to learn what it really is. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo

Re: state: reading from net

the server's point of view, right? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com

Re: wait_timeout?

they appear to have anything particular in common? Same host/user/db? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting

Re: Load Balancing.

others would as well. Good luck, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com

Re: table history or tracabitity

track down the change. If not (and you have no backups from earlier), you're mostly out of luck. You could check the timestamp on the .frm file for the table to see when it was last changed, but that won't tell you WHO changed it. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo

Re: number of tables in a db

is implemented. Are you talking about a few hundred or a few million? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting

Re: Please can this newsgroup be added to the demon newsgroups

. They'd certainly know better than most of us (who don't use the same ISP that you do). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951

Re: mysql.server script

that it doesn't break anything, of course). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http

Re: To thread or not to thread this is the question ..........

machines? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php

  1   2   >