Re: RE - Order By Problem

If "surname" is a field, then use it without the single quotes ('), otherwise it is treated as a literal string and 0 is the correct result: select locate(' ',surname,1) from advisers andy thomas wrote: Yes, this is the approach I was thinking of using but: select locate(' ','sur

mySQL Cluster

I'm trying to find documentation on how to setup MySQL cluster Any ideas? Vadim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

DB size estimation

quirements for the index files What is the rule of thumb to use? Thanks Vadim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: User variables + SUM + GROUP BY = strange behavior

well, it seems to be fine without SUM and GROUP BY... E.g., "SELECT @a:=Charge, @b:=Cost, @[EMAIL PROTECTED] as Margin ..." produces expected results. Emmett Bishop wrote: Vadim, if I'm not mistaken, you can't set a variable then use it in the same statement. See

User variables + SUM + GROUP BY = strange behavior

Sorry, the message got garbled, here is a more digestible look: -Original Message- Hello all, Could anyone comment on User Variable behavior in the example below? Thanks, Vadim. = mysql> SELECT ->

User variables + SUM + GROUP BY = strange behavior

Hello all, Could anyone comment on User Variable behavior in the example below? Thanks, Vadim. = mysql> SELECT -> LEFT(CallTime,10) AS CallDate, -> @a := SUM(Charge), -> @b

Re: Killing overactive mysql selects

Start another Mysql shell session; then do "show processlist"; identify the thread ID of the offending process, then do "kill ". Not sure how graceful this method is, though. I use it to kill overlooked hanging connections from time to time. Cheers, Vadim. Scott Haneda w

Re: SELECT DISTINCT.. ORDER BY.. DESC - bug??

adding an index improves SELECT .. ORDER BY .. ASC, but slows down SELECT.. ORDER BY .. DESC at least by a factor of 10. If this is not a bug, what is it? ---- Vadim P. wrote: Hi all, Sorry to be so persistent, but I am bringing this up again since noone from the MySQL d

SELECT DISTINCT.. ORDER BY.. DESC - bug??

--+ 14 rows in set (1.06 sec) === Thanks in advance! Vadim. mysql query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "ORDER DESC" vs. "ORDER ASC" exec time

h ASC/DESC on an equivalent query I just tried. So maybe something is making DISTINCT + reverse index scan slow even if it's not packed... Matt - Original Message - From: "Vadim P." Sent: Monday, March 29, 2004 8:15 PM Subject: "ORDER DESC" vs. "ORDER ASC&quo

Re: High load with a few queries

e you have a new portion of data to be uploaded, first you have to start Perl, then have it load the script, then establish a new connection to the DB server - all these steps are totally redundant, but they do overload your box. Hope this helps. Vadim. Chris wrote: Hi Guys, Iv got a script th

Re: "ORDER DESC" vs. "ORDER ASC" exec time

The timing is consistent both ways - have tried both queries back-to-back alternatively many times. I'm pretty sure that it is not caching that causes the discrepancy. So, this turns out to be a known issue after all... Somehow I missed it. Thanks, Donny! Vadim. - Original Me

"ORDER DESC" vs. "ORDER ASC" exec time

Hi all, Just noticed that a simple query that returns only 14 rows is 10X slower when "ORDER .. DESC" is used compared to "ORDER .. ASC". The table has about 700,000 records, indexed on the field the table is being ordered by. Is this expected behavior? MySQL 4.0.18 running under OpenBSD 3.4

Re: InterBase vs. Mysql

://www.sqlmanager.net Best regards, Vadim Vinokur EMS HiTech http://www.ems-hitech.com - Original Message - From: "Maciej Bobrowski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 4:27 PM Subject: InterBase vs. Mysql > > Hi, > > I am a My

ANN: EMS MySQL Manager User's Guide

The EMS HiTech company is very glad to inform you that today we uploaded the MySQL Manager User's guide. It's a 58 page PDF document with pictures contained detailed information about all the MySQL Manager features. You can download this file from http://www.mysqlmanager.com/download.phtml The E

Re: strange fulltext behavior

" and match (header) against ("reagan"); ++ | 1988120101 | | 19990610115359 | | 2515123714 | | 1988112201 | | 1988112201 | ++ 5 rows in set (0.08 sec) Regards, Vadim P. Victoria Reznichenko wrote: > > Przemyslaw, > Wednesday,

Re: Bug in fulltext search in latest mysql-4.0.2 source

Sergei Golubchik wrote: > rebuild your indexes (the proper way to do it is to issue > REPAIR table_name USE_FRM Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick? TIA, Vadim. /* sql, mysql to satisfy the spam

Re: MySQL load problems - gcc-2.96?

Mike, BTW, have you been able to build Mysql 4.0 under RH7.x from the development tree lately? I keep getting some missing definitions messages as of last week, when I performed a regular 'bk resync'. Prior to that, all had been just fine. TIA, Vadim P. Mike Robinson wrote: > &

Re: MySQL load problems - gcc-2.96?

Mike, what kind of problem? What exactly goes wrong with PHP4? Thanks, Vadim Mike Robinson wrote: > > I am able to reproduce this problem very easily, including on > Redhat-7.2. Basically, any app using the libmysqlclient.so > compiled with gcc-2.96 connecting to a server compile

Re: Help! Error building 4.0.2 under RH Linux 7.2

he new fulltext search features) - without any known issues... That's why I got somewhat too comfortable using v2.96... Regards, Vadim. crashke wrote: > > Hi Vadim, I don't know but have you read the instructions on the > Mysql-website? > > To determine if you shoul

Re: Help! Error building 4.0.2 under RH Linux 7.2

Just tried building Mysql-3.x.x cloned from the Development Tree on the same machine - works like a charm. Still no luck with 4.0.2 Is there any known issue regarding building 4.0.2 under RedHat7.2? Thanks, Vadim. "Vadim P." wrote: > > The Dev. Tree Source MySQL 4.0 no

Help! Error building 4.0.2 under RH Linux 7.2

The Dev. Tree Source MySQL 4.0 no longer builds on this machine, giving lots of errors. Had been able to build from the same source w/o any problems up until a few days ago, when I 'bk resync'ed the source. Any ideas? Thanks for your help!

Re: FULLTEXT search pattern syntax

sident bush") +("donald rumsfeld")' in boolean mode); ==> 1979 rows in set (2.52 sec) -- select tdate, left(header,125) from archivel where match (header) against ('+("president bush") -("donald rumsfeld")' in boolean mode); 19

Re: FULLTEXT search pattern syntax

Of course, I forgot to mention 'IN BOOLEAN MODE'. ... MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN MODE) ... > "Vadim P." wrote: > > Hi, > > It's not quite clear from the manual,

FULLTEXT search pattern syntax

ments are not allowed, with or without parentheses... Could someone confirm, please? On a general note, it would be nice to have the formal syntax of FT search patterns in the manual. TIA, Vadim. [sql query - to satisfy the darn spam filter] -

FW: I need an example on DELETE /UPDATE with JOIN syntax

.col1 = t2.col1 and t2.col2 is NULL This syntax does not work in MySQL. # I need help! # Thank you very much for you time. Vadim Kulikov 877-428-3279 [EMAIL PROTECTED] P.S. Someone left a comment with the example on how you can do delete with join under MYSQL help si

FW: I need an example on DELETE /UPDATE with JOIN syntax

-Original Message- From: Vadim [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 27, 2002 4:49 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: I need an example on DELETE /UPDATE with JOIN syntax Greetings: My company migrated to MySQL a few mo

I need an example on DELETE /UPDATE with JOIN syntax

.col1 = t2.col1 and t2.col2 is NULL This syntax does not work in MySQL. # I need help! # Thank you very much for you time. Vadim Kulikov 877-428-3279 [EMAIL PROTECTED] P.S. Someone left a comment with the example on how you can do delete with join under MYSQL help si

FW: Does MySQL provide an access to system tables ? Are there any ?

:: Thank you very much for your time. Vadim Kulikov 877-428-3279 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Update syntax

What's the correct syntax for it ? Or is there another way to accomplish that. Thank you, Vadim Kulikov [EMAIL PROTECTED] Thank you, Vadim Kulikov 818-428-1001 - Before posting, please check: http://www

Re: GUI for Windows

MySQL Manager, http://www.mysqlmanager.com/ A lot of features including Export/Import Data, Visual Query Builder, Extract/Print Metadata, Syntax HighLight, BLOB Editor and so on. HTH, Vadim - Original Message - From: "John Mayson" <[EMAIL PROTECTED]> To: "MySQL Li

Re: GUI for MySql

Powerful MySQL Manager for Win32. http://www.mysqlmanager.com Regards, Vadim - Original Message - From: "Joe Fan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 31, 2001 9:44 AM Subject: GUI for MySql > What GUIs exist for MySql and

Re: FULLTEXT search with hyphens in data

Just a thought - if your serial numbers have fixed format, then programmatically remove the hyphen and store the number without it. Add it back when displaying data on the screen. That way FULLTEXT will work on the whole number without splitting it into two parts. Vadim. Marty McCoy wrote

Re: Looks like any user can read the mysql db!

Jose-- Are you running mysqld as 'root'? Run it as 'mysql' and change the group membership of the data directory and its contents to 'mysql'. Vadim. Jose de Leon wrote: > > Here are the perms on the mysql db files /var/lib/mysql/mysql > > Also,

Re: --with-raid

big files (like Linux with pre-2.4 kernel). Vadim. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAI

Re: WHERE OR Syntax

Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes OR so Also, use 'IN' instead of a series of 'OR' - this will make the query a lot faster. e.g. listings.Area IN ('19','24','25',...) Vadim. JD Daniels wrote:

Re: Help with MATCH AGAINST

ted a fulltext index *exactly* the way you list the fields in MATCH(). In your case it would be FULLTEXT(specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour). Vadim. - Before posting, please check: http://www.mysql.c

Re: How long should sql-bench/run-all-tests take?

Patrick-- yes, it might take hours, nothing wrong with your setup. Vadim. Patrick Goetz wrote: > > I recently installed MySQL 2.23.37 from the unstable Debian package on a > dual-processor PII 350 w/ 128MB SDRAM running linux 2.4.2 > > For fun (since I've never trie

Re: Database size

RedHat 7.1 uses kernel 2.4, which *does not* have a file size limitation of 2Gb. I have a few tables bigger than 2Gb (3.23.37 / RedHat 7.1) It takes forever to index them, though... Vadim. Dhiin Data - Erik Dhiin wrote: > > Hi, > > I have a problem, my database has reached Linu

Re: Database size

Erik, You mentioned 40Gig files on Intel platform - what OS/DBMS did you use then? How about the performance? Thanks, Vadim. Terry Katz wrote: > > Erik, > If your running Linux on an Intel machine (which I assume it is), then > you've hit Linux's limit for IA32 and 2

Re: max FULLTEXT index size?

f the tables, for the 6th straight day now. I'm getting desperate. What's the completion state of v.4.0? Will it also improve query performance on big tables? Thanks, Vadim. Sergei Golubchik wrote: > > Hi! > > On Apr 19, Braxton Robbason wrote: > > Hi all, > &g

Re: Lazy

Excellent post, Neil! I'm with you! (Sorry to be using up the bandwidth with this "me too" stuff, but couldn't help it :)) Cheers, Vadim Neil Davis wrote: > > Guys, > > Amen. When I was 13 and got my first commodore 64, I decided to teach myself > BASIC. A

Re: Install:MySQL, RedHat7, Dell Poweredge 2400 dual PIII 700 MHz

No, it should work just fine 'out of the box' with SMP kernel. Most likely you have a permission problem. Check permissions of your MySQL data directories. I have a dual P866 Dell Poweredge 2400 / RH Linux 7.0 / MySQL 3.23.29a. Works just fine. Cheers, Vadim. Lars Freymark wrote: