Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

Hi, Someone suggested I try the -amd64 kernels which provide 64 bit but when I try to boot it I get various errors about this CPU does not support long (something) please use a 32-bit OS - the 64 bit install CD says the same message. So I assume these are not 64 bit CPUs. They almost

Re: MySQL Customer Survey :: an exercise in frustration

Hi, And, what's up with the vertical white lines on dark blue background as a section divider? My eyes actually hurt looking at the survey page. It makes it *very* difficult to read the questions. Regards, Jeremy Daevid Vincent wrote: I started to take this but gave up, here's a few

Re: MySQL Customer Survey :: an exercise in frustration

I just finished it. There were 56 questions, not counting the final give us your name stuff for the prize. Most of the questions were mandatory. This seems to be a fill out the form type of survey system rather than a self-adjusting system based on the answers to your previous questions.

Re: Oracle is acquiring...............................

Hi, I wouldn't say the Sleepycat/BDB acquisition had anything to do with MySQL. BDB is much more useful *outside* of MySQL, and has a much bigger market there anyway. The BDB storage engine is all but useless. As for Innobase/InnoDB, their motives are still unclear. :) Regards, Jeremy

Re: Arabic text storing problem

Hi, Thanks for the link Is there standalone jar/zip Just for auto_ef Also see Perl module Encode::Guess. There are others out there as well. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives:

Re: mysql eluding query debugging?

Hi Moritz, Thus, my questions: - what's wrong with that query? I know they are big tables, but according to EXPLAIN, this should be fast enough, because mysql's seeing the indexes just fine. As others have said, likely nothing wrong with the query per se. It just sounds like you're

Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

be enough). Regards, John -- / Humanique / Webstrategie en ontwikkeling / http://www.humanique.com/ - Humanique zoekt een ervaren Web-ontwikkelaar (PHP). Bekijk de vacature op http://www.humanique.com/ - Jeremy Cole wrote: Hi John, Your attachment for the php code got stripped somewhere. Can you

Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

Hi John, Your attachment for the php code got stripped somewhere. Can you post it somewhere (http preferable)? In either case it's going to result in a full table scan, so they are actually both a bad strategy long term, but they should in theory perform as you would expect, with with

Re: Could drbd randomly flip bits? Was: Database page corruption on disk occurring during mysqldump on a fresh database and Was: Spontaneous development of supremely large files on

Hi Maurice, If you're running into corruption both in ext3 metadata and in MySQL data, it is certainly not he fault of MySQL as you're likely aware. There are absolutely many places where corruption could occur between MySQL and the physical bits on disk. The corruption you're seeing does

Re: Could drbd randomly flip bits? Was: Database page corruption on disk occurring during mysqldump on a fresh database and Was: Spontaneous development of supremely large files on

Hi Maurice, Do you mean a Serially-Attached SCSI aka SAS controller, I assume? Is this a custom build machine or a vendor integrated one? Regards, Jeremy Maurice Volaski wrote: On Sep 17, 2007 13:31 -0400, Maurice Volaski wrote: In using drbd 8.0.5 recently, I have come across at least

Re: Could drbd randomly flip bits? Was: Database page corruption on disk occurring during mysqldump on a fresh database and Was: Spontaneous development of supremely large files

Hi Maurice, If you're running into corruption both in ext3 metadata and in MySQL data, it is certainly not he fault of MySQL as you're likely aware. I am hoping they are not related. The problems with MySQL surfaced almost immediately after upgrading to 5.0.x. It's possible that they are

Re: The current version is 5.0.48, no?

Hi Maurice, Yep, it's very very confusing these days. Unfortunately for all of us, MySQL's sales organization seems happy with the situation. Blame them. And, yes, you're correct, compared to MySQL Enterprise, 5.0.45 is indeed out of date now. The releases are sequential, but the

Re: Is bad hardware confusing MySQL and InnoDB?

Hi Maurice, You say the MySQL data wasn't on the stuck volume, but were the InnoDB logs? What is the disk configuration? It sounds to me like bad hardware/software, which, unfortunately MySQL and InnoDB cannot protect you from... Regards, Jeremy Maurice Volaski wrote: Some processes on a

Re: Conflicting server IDs on slaves

Hi David, This sounds strange, and should NOT occur because of a server_id conflict. Regards, Jeremy David Schneider-Joseph wrote: Thank you. We had a situation recently where two slaves had a conflicting server ID for several minutes, and shortly thereafter the master started reporting

Re: excessive time spent in statistics status

Hi Shawn, Lucio, SELECT STRAIGHT_JOIN FROM ... LEFT JOIN ... WHERE ... ... Just to correct a point here... if a query uses only LEFT JOIN or RIGHT JOIN, the join order is fixed by the query's order itself, so using STRAIGHT_JOIN should have no effect whatsoever. Equally important,

Re: DIAGNOSTIC MYSQL

Hi Krishna, No, nothing like what you're asking for exists free or open source. Look into Groundwork and Nagios, though they will not do any really fancy monitoring directly out of the box, with a bit of configuration you can get most of what you want. Regards, Jeremy Krishna Chandra

Re: bitwise logic

Hi, You can actually unpack them using some fairly cryptic stuff. I would only use this to unpack them once to re-store them as INT. Here's an example: CREATE TABLE ip (packed CHAR(4)); INSERT INTO ip (packed) VALUES (0xB16212C); mysql SELECT * FROM ip; ++ | packed | ++ |

Re: Really strange index/speed issues

Hi Chris, Chris Hemmings wrote: Hello, I have a table, currently holding 128,978 rows... In this table, I have a section column (int) and a price column (int). Every row has a section of 1 currently, every row has a price, ranging from 1 to 10,000. I have an index on both columns

Re: Integrity on large sites

Hi Naz, Just to throw out (plug) an ongoing project: http://www.hivedb.org/ From the site: HiveDB is an open source framework for horizontally partitioning MySQL systems. Building scalable and high performance MySQL-backed systems requires a good deal of expertise in designing the system

Re: best filesystem for mysql

Hi Jeff, There isn't really a clear winner in any case, but the tests done in the article linked to are highly suspect. It would be much more interesting to see real tests done with real hardware... Nonetheless, the usual answer I would have is to lean towards ease of administration and

Re: IS NULL Question

Hi John, Are you sure they are actually NULL and not NULL (i.e. the string NULL)? Try this: SELECT first, last, ISNULL(suffix), LENGTH(suffix) FROM persons LIMIT 5; Regards, Jeremy John Kebbel wrote: I'm having problems understanding NULL. I grasp what a NULL value is, but I can't get NULL

Re: Why doesn't the InnoDB count() match table status?

Hi Daevid, Ugh. How about not going berserk on the public mailing list? We can understand that you're upset that you didn't read the manual before starting a MyISAM to InnoDB conversion. You didn't do your research and now you're being hit by a very simple (and not really all that

Re: Making a prefixed install / hard-wired global configuration files?

Hi Nick, This should do it: --sysconfdir=DIR read-only single-machine data [PREFIX/etc] Regards, Jeremy Nick Hill wrote: Is there an easy way to build MySQL client library, server and start-up script so that /etc/my.cnf is ignored? I need to build client and server so that it in

Want a Free Ride to MySQL Conference and Expo 2007?

shortly thereafter. You can enter by visiting: http://www.provenscaling.com/freeride/ Good luck, and we hope to see you at the conference! Regards, Jeremy Cole Owner / MySQL Geek Proven Scaling LLC -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List

MySQL Camp: Proven Scaling offering Free Ride

Hi All, As you may know, MySQL Camp, a gathering of the best minds in MySQL, is coming up soon, in just over three weeks. It will be held at Google HQ, in Mountain View, California, November 10-12. You can find out more information about the conference here: http://mysqlcamp.org/ Proven

Re: MySQL service startup time

Hi Rob, I have an application self-installer program which also installs MySQL and sets it up. This is all on Windows. I have a problem in that when the installer runs 'net start MySQL', it returns immediately but the MySQL daemon is not ready for connections immediately. As the next step in

Re: Newbie - CREATE VIEW Question

Hi, Say I have the following tables; siteID,name -- site1, XYZ site2, RSQ ID,site,data 1, site1, M 2, site2, Q 3, site2, Y 4, site1, P ... etc. And I want to create a view like this; siteID,name,data --

Re: enum query results strange.

Hi, both queries would have the limit on them, so they would only return 10 rows. but yes, there are probably about 10x as many records with true than with anything else. If there are only six possible values, and one values occurs ten times as often as the other five values, that means it

Re: Problems with: MySQL 5.0.21 - 64bit

Hi Gabriel, Yesterday MySQL died again... there is nothing in the log files... (be it mysqld.log, .err, or /var/log/messages). The hosting provider is running an application called 'big-brother' and a lot of sef-faults appear in the logs from this. I don't know if thins is the cause... if this

Re: howto set mysql to readonly

Hi Jehan, OK so it seems to be a bad idea ... I was expecting that I missed a magic command like set readonly on all databases ... I think you did: SET GLOBAL read_only=1; This will keep all non-SUPER and non-replication users from writing to the database. Regards, Jeremy -- high

Re: Importing 3Gb File

if necessary in the mysql.server or mysqld_safe script (those both run as root, so can adjust ulimits upwards). Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Copy large amount of data from non-normalized to normalized table

} as index, p${col} \ FROM old_event_data; done done Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: procedure analyse() returns bad type?

, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: procedure analyse() returns bad type?

), num_info.integers, num_info.decimals); else sprintf(buff, DOUBLE(%d,%d), num_info.integers, num_info.decimals); It should likely use num_info.integers+num_info.decimals for the M. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list

Re: help with storing a large binary number as bigint

format, you will need to do the byte-swapping before/after the bin2hex. (In pure PHP, it might be easier after.) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: question+comment : Re: set DEC as a column name : forbidden

be used as such, they wouldn't need to be reserved words, would they? :) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

be capable of doing that calculation using its new precision math support. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

many digits to show by default. You can influence that quite easily: mysql select 1.0/666; +-+ | 1.0/666 | +-+ | 0.00150150150 | +-+ 1 row in set (0.00 sec) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349

Re: aha! replication breaking due to duplicate queries

quite a few times where the slave hiccups and apparently runs the same query twice. Is it possible that this is what you're seeing? Is your system replicating a mix of large (images, maybe) and small (single-row) updates? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349

Re: Streaming LOB Data

to save some of the memory is to run it as: INSERT INTO tbl (id, image) VALUES (id, LOAD_FILE(filename)); This of course would require that you have the file available on the MySQL server to load in. LOAD_FILE() will return the contents of the file. Regards, Jeremy -- Jeremy Cole MySQL Geek

Re: Outfile syntax and out of memory

a complete file. I get a out of memory error after a hour or 2!! This is because the mysql client program is trying to read the entire result into its own memory. Try adding the '-q' option to mysql: mysql -q queryfile.sql outfile.txt Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc

Re: updates during database dump

dumped, while the dump is running. In general, you want a consistent snapshot of all tables from the same point in time, and you will want to use one of the above options to get it. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List

Re: bind-address by name under 5.0.18

like a very strange way to configure a machine. To each, his own. :) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Silicon Valley MySQL Meetup Group: Storage Engines in Depth

dates, the topics, and RSVP at Meetup.com: http://mysql.meetup.com/101/ I hope to see you there! Regards, Jeremy Cole MySQL Meetup Organizer Silicon Valley -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: bind-address by name under 5.0.18

trivial, with the caveat that it will have to use the first address returned by gethostbyname(), so if you have multiple IPs assigned to a hostname (for e.g. round-robin DNS) it will be interesting. :) This is probably a 5-10 line patch, including error checking. Regards, Jeremy -- Jeremy Cole

Re: bind-address by name under 5.0.18

every day. Are you having a problem with it? Does it not work for you? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Byte Swapping

-- it seems very odd b. stop storing the data raw... do the swap before storing Can you give more details about what you're doing? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Silicon Valley MySQL Meetup: MySQL Optimization, Monday, Feb 13, 2006 @ 7:00pm in Santa Clara, CA

in: http://mysql.meetup.com/101/poll/ If you have any questions about the group or the event, please feel free to contact me directly. See you on Monday! Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http

Re: Help...I am desparate

. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL with InnoDB on a readonly filesystem.

, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Server take 20s to connect

the 'host' command to determine where the problem is. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting no of different rows by group by clause

Hi Abishek, I want the output as: LHR 3 AKL 2 AWL 1 This should do it: SELECT name, COUNT(*) as num FROM tab_name GROUP BY name ORDER BY num DESC Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http

Re: A key question

while the market is open. :) If you could provide the exact query you were running, I could confirm that it would or would not help. :) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: A key question

count(*) from ontime_all; +--+ | count(*) | +--+ | 33395077 | +--+ 1 row in set (0.00 sec) Could be a lot faster, even, but these are MERGE tables so it's really 65 tables that are being checked... Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349

Re: LIKE problem?

0 60797 60797 p 3048 58573 61621 Sounds like a corrupt index. Try CHECK TABLE and REPAIR TABLE. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Delete all but the newest 100 records?

Hi Brian, Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 Yahoo employs MySQL geeks? Always wondered what db that big index runs on... :) Do note that Yahoo! is a lot more than a search engine. :) The big index is not running in MySQL, but a whole lot more is. And yes, we

Re: Delete all but the newest 100 records?

are a MySQL-extensions to DELETE, not part of the SQL standards. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database equivalent to NorthWind for M$ SQL

://dl.flightstats.us/ You can try out a front-end to the data: http://flightstats.us/ It's all public domain. Read about where it comes from: http://flightstats.us/about.php Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek Desk: 408 349 5104 -- MySQL General Mailing

Re: could a Trigger execute a outside command?

sleep 60; } * Upon receiving the SIGALRM, the Perl script will be woken up early and get to its work immediately. If something fails for any reason, you go back to the old behaviour of checking every 60 seconds. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek Desk

Re: zip code search within x miles

usually excludes most BLOB/TEXT fields, so you wouldn't normally include a BLOB/TEXT in a covered index discussion. Covered indexes work fine with CHAR/VARCHAR and are quite common. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives

Re: weird characters from mysqldump?

? Looks like an application of the GIGO (Garbage In, Garbage Out) principle to me. The above data wouldn't have happened to come from a Microsoft Office application, would it? Looks like Smart Quotes etc., strikes again, to me. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek

Re: Duplicated records

90575 1 56575334JulieAnt25 5 5 439584414 2004-10-03 00:00:00 2004-10-03 00:00:00 0 How do I issue a query that finds duplicated Batch number? SELECT Batch, COUNT(*) as Nr FROM QA GROUP BY Batch HAVING Nr 1 Regards, Jeremy -- Jeremy

Re: How to find missing record?

doesn't. This should do it: SELECT Open.id, Open.day FROM Open LEFT JOIN Close ON Open.id=Close.id AND Open.day=Close.day WHERE Close.id IS NULL Regards, Jeremy -- Jeremy Cole (currently in Bangalore) Technical Yahoo - MySQL (Database) Geek Desk: 408 349 5104 -- MySQL General Mailing List For list

Re: How to import data from Dbase3?

/ You should be able to load a file, e.g. foo.dbf, by doing: tools/mysqlgisimport -S foo | mysql -u myuser -p mydb It will automatically create a table suitable for the dBase file and load the records in with the above command. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek

Re: long PHP mysql_connect times

this: $ host foo.example.com Then, take the IP that gives you and do the same: $ host 1.2.3.4 Mainly you're looking for the delay in this second step. -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: long PHP mysql_connect times [Resolved]

, disconnect once at the end. All the extraneous connect/disconnect puts extra, unnecessary load on the database server. I would have never though of / figured that one out. Nobody knows... the troubles I've seen... :) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek

Re: Help with LIKE

Hi Mevers, SELECT * FROM woorden WHERE string LIKE % woord % It's not going to be efficient (at all) but you can do: SELECT * FROM woorden WHERE foo LIKE CONCAT('%', woord, '%') Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives

Re: replication errors

using an ALPHA version and expecting it to work perfectly, and when it doesn't, doubting MySQL and replication? If you want it to be stable, use a STABLE version. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http

Re: select where multiple joined records match

it into CREATE TABLE/INSERT statemnts to test things. The concepts are solid.) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Empty 'Relay_Master_Log_File'?

MASTER on the slave. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Importing ArcView Shapefile into a Database

to be imported. You can grab the source code of libmygis at: http://jcole.us/software/libmygis/ If you have any questions or need help getting it to work (hey, it's new!) please feel free to drop me a line. Same goes for feature requests. :) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database

Re: Importing ArcView Shapefile into a Database

don't have a Windows compiler suite handy. It would probably mostly compile on Windows. ;) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Importing ArcView Shapefile into a Database

Hi, Sweet! Thank you Jeremy! FYI, make sure you grab the libmygis-0.3.tar.gz or later instead of any other version. I had some silly mistakes that made the DBF file required instead of optional. I've also ported to Mac OS X in 0.3. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL

Re: Compound Order By

? ORDER BY city, name http://dev.mysql.com/doc/mysql/en/sorting-rows.html I hope you're wearing a flame-retardant suit, because the flames are about to fly. :) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Syntax diagram, where is it located in the doc?

'(' expr IN_SYM BOOLEAN_SYM MODE_SYM ')' | BINARY expr %prec NEG Maybe this is more along the lines of what you're looking for... snip all of the random functions Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http

Re: Logging Data: Should I use MyIsam or InnoDB?

) in case you ever need it. myisampack can help you with that. I hope that helps! Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Logging Data: Should I use MyIsam or InnoDB?

-- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select @qty1=@qty+qty from goods2 , result 0 ?

Hi Shuming, select qty, @[EMAIL PROTECTED] allqty from goods2 That should be @qty1:[EMAIL PROTECTED] You are doing a comparison using =, which is returning false (0). Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives

Re: merge tables for big log files ?

is an atomic operation and can be done while the server is up and running full-speed without any problems. Regards, Jeremy -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jeremy Cole [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Training and Consulting Manager

Re: Some amazing query numbers from MySQL 4.0

to the MySQL dev team =) Thanks! Regards, Jeremy -- To learn more about consulting, visit http://www.mysql.com/consulting/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jeremy Cole [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, On-Site Consultant