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?
>
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
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,
>
--+
2 rows in set (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
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 Cli
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]>
u have heavy load, I
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]>; <[EM
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 a
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,
> Ple
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 PROTE
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 ver
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]&g
d 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.
words to bypass filter: sql queries
Andrei Cojocaru
[EMAIL PROTECTED]
---
lumns that are used in the query 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]
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?
Als
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?
Als
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: Mo
gt;
>>From: Sasha Pachev <[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-Versio
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
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
>MHotMailBCA4429B00C94004370AC0
ROTECTED]>
>Delivered-To: mailing list [EMAIL PROTECTED]
>Message-ID: <[EMAIL PROTECTED]>
>In-Reply-To: <[EMAIL 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
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
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 Ap
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
>MHotMailBCA3
dle_connections_sockets(0);
...
(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
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 defaul
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,
>
> M
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 cat
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
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 u
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 man
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
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
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)
ht
rminal app?
> (various Unix 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
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!
36 matches
Mail list logo
