Re: How does update low priority work?

2002-06-27 Thread Andrei Cojocaru
Is there any way to tell mySQL to return immediatly? Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 02:44 Subject: Re: How does update low priority work? Andrei, Thursday, June 27

Re: Regarding Store Procedures

2002-06-26 Thread Andrei Cojocaru
There are no stored procedures in mySQL Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Pradeep.C.Pangi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 05:17 Subject: Regarding Store Procedures Hi All, I am new to MySQL, can any body tell

How does update low priority work?

2002-06-26 Thread Andrei Cojocaru
If you execute UPDATE LOW PRIORITY table_name .. does mySQL automatically return or does it wait for the update to execute? (that is, is it async or sync)? Andrei Cojocaru [EMAIL PROTECTED] - Before posting, please check

Re: InnoDB, possible bug?

2002-05-21 Thread Andrei Cojocaru
(0.00 sec) Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 12:40 PM Subject: Re: InnoDB, possible bug? Andrei, how many rows in ne satisfy (1) ne.playerid=28575, (2) ne.type=2? What

InnoDB, possible bug?

2002-05-20 Thread Andrei Cojocaru
please explain this to me and give me any advice on how to fix it? Thanks for your help in advance. words to bypass filter: sql queries Andrei Cojocaru [EMAIL PROTECTED] - Before posting, please check: http

Re: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
If I were you I would not store a binary file into the database, I'd store the information required to fetch it from somewhere else like the mySQL manual suggests Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Sherzod B. Ruzmetov [EMAIL PROTECTED] To: Sameer Maggon

Re: Performances with BLOB fields in mySql

2002-05-20 Thread Andrei Cojocaru
Well how large is the BLOB field? Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 2:51 AM Subject: Performances with BLOB fields in mySql My application (C++, mySql++, WINNT) is very time-critical

Re: MySQL new-bee...

2002-05-20 Thread Andrei Cojocaru
Try: /usr/bin/mysql -uroot then when you're connected type: grant all on *.* to root@localhost identified by 'newpassword'; flush privileges; and that should work Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Suresh Pun [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Re: Binary Data mysql_real_escape_

2002-05-20 Thread Andrei Cojocaru
are you null terminating the string? Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Sameer Maggon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 7:51 AM Subject: Binary Data mysql_real_escape_ Hi, Please see the code given below

Re: MyISAM internal algorithms

2002-05-20 Thread Andrei Cojocaru
I believe mySQL uses B-Trees (not binary trees), that's about all I know :) Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Jan Peuker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 2:59 AM Subject: MyISAM internal algorithms Hi MySQL-Team, my

Re: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
wouldn't use it. Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Sherzod B. Ruzmetov [EMAIL PROTECTED] To: Andrei Cojocaru [EMAIL PROTECTED] Cc: Sameer Maggon [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:37 AM Subject: Re: store JPG in MySQL DB Hi

Re: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
I wouldn't know how likely it is to crash, but it will happen eventually, nothing is perfect :( Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Sherzod B. Ruzmetov [EMAIL PROTECTED] To: Andrei Cojocaru [EMAIL PROTECTED] Cc: Sameer Maggon [EMAIL PROTECTED]; [EMAIL

Re: Mysql Client

2002-05-20 Thread Andrei Cojocaru
try the command line version of the client first then a GUI based one Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Federico Coco [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:57 AM Subject: Mysql Client I'm testing MySQL Client on Win98

Problem with InnoDB + indexes

2002-05-19 Thread Andrei Cojocaru
on the newsentries10 table and it doesn't use them at all. Could someone please explain this to me and give me any advice on how to fix it? Thanks for your help in advance. Andrei Cojocaru [EMAIL PROTECTED] - Before posting, please

Indexes on UPDATE/DELETE

2002-02-12 Thread Andrei Cojocaru
Hello fellow mySQL users, I'd like to know if UPDATE/DELETE statements use indexes on the where statement the same way as SELECTs. If I build a SELECT using the WHERE statement that I use in an UPDATE/DELETE statement, can I use that accurately to determine what indexes mySQL will use?

Indexes on UPDATE/DELETE

2002-02-09 Thread Andrei Cojocaru
Hello fellow mySQL users, I'd like to know if UPDATE/DELETE statements use indexes on the where statement the same way as SELECTs. If I build a SELECT using the WHERE statement that I use in an UPDATE/DELETE statement, can I use that accurately to determine what indexes mySQL will use?

How to apply a patch?

2001-04-16 Thread Andrei Cojocaru
Hello sorry for my ignorance but how do I apply a patch [diff file] to the mysql source? Thanks for your help. -Andrei Cojocaru _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Re: How to apply a patch?

2001-04-16 Thread Andrei Cojocaru
PROTECTED] References: [EMAIL PROTECTED] X-Mailer: VM 6.72 under 21.1 (patch 12) "GTK" XEmacs Lucid Andrei Cojocaru writes: Hello sorry for my ignorance but how do I apply a patch [diff file] to the mysql source? Thanks for your help. -Andrei Cojocaru Hi! Enter mysql sour

Re: Please assist me?

2001-04-16 Thread Andrei Cojocaru
I suggest you get 3.23.36 it's the latest. From: "Thomas Morton" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Please assist me? Date: Mon, 16 Apr 2001 14:35:50 +0100 MIME-Version: 1.0 Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id

Re: Problem - Possible Bug?

2001-04-16 Thread Andrei Cojocaru
as I said before I can give you root access on the machine which I believe would be easier for you to disagnose the problem. From: Sasha Pachev [EMAIL PROTECTED] To: "Andrei Cojocaru" [EMAIL PROTECTED] Subject: Re: Problem - Possible Bug? Date: Mon, 16 Apr 2001 08:31:54 -0600 MIME-Ve

Re: Problem - Possible Bug?

2001-04-16 Thread Andrei Cojocaru
[EMAIL PROTECTED] To: "Andrei Cojocaru" [EMAIL PROTECTED] CC: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Problem - Possible Bug? Date: Mon, 16 Apr 2001 08:25:26 -0600 MIME-Version: 1.0 Received: from [209.181.82.108] by hotmail.com (3.2) wit

Re: MYSQL Problem

2001-04-16 Thread Andrei Cojocaru
Okay just checking a few basic things, have you indexed your table properly? There is a manual section about performance, also make sure to play around with the mysql configuration file (global one in /etc/my.cnf) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL Problem Date: Mon,

Problem - Possible Bug?

2001-04-15 Thread Andrei Cojocaru
... (gdb) info locals No locals. ... (gdb) up #11 0x804b29d in _start () ... (gdb) info locals No symbol table info available. If any of the developers would like access to my machine, I can provide it through ssh and you can see for yourself. I hope the solution to this problem is found soon. Than

Re: www.kwwda.org

2001-04-15 Thread Andrei Cojocaru
I suggest PHP it's the easiest to learn. From: "Rolf Hopkins" [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: www.kwwda.org Date: Mon, 16 Apr 2001 09:57:15 +0800 MIME-Version: 1.0 Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id

Re: Problem with mysql++, Aborted (core dumped)

2001-04-15 Thread Andrei Cojocaru
I suggest you try the mySQL C API and see if that works first. -Andrei Cojocaru From: Luis E. Cruz Campos [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Problem with mysql++, Aborted (core dumped) Date: Mon, 16 Apr 2001 12:17:40 -0400 MIME

Re: Linux limited to 256 connections by default?

2001-02-01 Thread Andrei Cojocaru
well I believe this has to do with the file descriptors, but I use RH 7.0 and you can change the file descriptor max under /proc/sys/fs/file-max and inode-max On Thu, 1 Feb 2001, Chuck Carson wrote: I was under the impression ulimit controlled this, but someone just told me that by default,

RE: Mysqld eats up RAM and CPU

2001-01-30 Thread Andrei Cojocaru
on my server which runs an online game the values are all in the megabytes On Wed, 31 Jan 2001, Tony Shiu wrote: I wonder the normalization and indexing of tables, Awa the complexity of queries submitted to server. For those variables you mentioned I use in production without significantly

Re: AND on a many to many table, with arbitrary ANDs

2001-01-30 Thread Andrei Cojocaru
if my understanding is correct just have two joins using ors for the categories :-) On Tue, 30 Jan 2001, Beasley, Julien wrote: Hello everyone, I am in the process of building a search engine on a database. I have two tables that have a many-to-many relationship: A story table and a

RE: Are index file only for querying?

2001-01-30 Thread Andrei Cojocaru
does not matter you are signed up for this mailing list, to unsubscribe send an email to [EMAIL PROTECTED] with any subject or text message your heart desires, but make sure you use the email that you are subscribed with on the mailing list On Wed, 31 Jan 2001, Ha Linh Don wrote: HEllo, My

Re: Very slow to connect

2001-01-29 Thread Andrei Cojocaru
increase the number of connections allowed, that might be it On Mon, 29 Jan 2001, Leonardo Dias wrote: I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it

gemini

2001-01-29 Thread Andrei Cojocaru
Where can we find more information about gemini and when it will be done exactly (date)? -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Does this list support replication questions??

2001-01-29 Thread Andrei Cojocaru
nope sorry On Mon, 29 Jan 2001, Ricardo Kleemann wrote: Hi everyone, I have twice posted a problem with replication and have since seen 2 or 3 others post with similar replication questions and problems. However I have yet to see ANYONE respond to any of those posts. I dont

Re: really really new

2001-01-28 Thread Andrei Cojocaru
there is the mysql command-line client, it's under bin under the mysql base directory, it's called mysql on UNIX and mysql.exe on win32 :-) command line all the way!

Re: MySQL and GUI or CLI, was: really really new

2001-01-28 Thread Andrei Cojocaru
shells.) i think i need a GUI to start though, don't you? At 11:48 AM -0700 1/28/01, Andrei Cojocaru wrote: there is the mysql command-line client, it's under bin under the mysql base directory, it's called mysql on UNIX

Changes in 3.23.3x

2001-01-28 Thread Andrei Cojocaru
Where can I see a list of changes that were made in 3.23.3x versions of mySQL? -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: select-Problem

2001-01-28 Thread Andrei Cojocaru
so you want to list all of them starting with the highest level and going up to the lowest level? On Mon, 29 Jan 2001, Oliver Joa wrote: Hi, I have a recursive Problem. I have a Table with columns "id", "name" and "pid". E.g: name1 name11 name12 name121 name122 name13