Hi all:
I have read somewhere that mysql allows inserts into a table
without "holes" to go concurrently with the reads from that table.
starting at v 3.23.7. I'm running 3.23.41-nt and have tried to
accomplish that, but couldn't. My reads seem to only start after
the inserts are completed. Is th
Yes, they are in production and users are being trained this week. So far,
so good. BTW, the servers are twin P-IV's w/512mb RAM running Win2K Server.
-Original Message-
From: Jason Brooke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 7:03 AM
To: Gerald R. Jensen; [EMAIL P
Try SELECT my_table WHERE ident1 = $id1, ident2='$id2';
Note the single quotes around $id2
Clive
Mon PC wrote:
>
> I'm sending variables in an HTML request such as
> http://localhost/connexion.php?ID1=&ID2=
>
> When the variable ID2 is numeric, everything is OK and the query made by
> PHP (su
I'm sending variables in an HTML request such as
http://localhost/connexion.php?ID1=&ID2=
When the variable ID2 is numeric, everything is OK and the query made by
PHP (such as SELECT my_table WHERE ident1 = $id1, ident2=$id2;) works very
well.
The column ident2 in mySQL is defined as a VARCHAR(
Hi,
Is there any way to check whether I should add new datafile before my
database runs out of free space in the existing ones?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
Heikki,
Here's the details from the .err log:
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the
Hi!
> "Rock" == Rock VZ <[EMAIL PROTECTED]> writes:
Rock> Hi,
Rock> How much memory does mysql executable take in the ram?
Rock> What is its code memory foot print?
It depends on how you compile MySQL and how you set up the buffers.
MySQL can run with as little memory as 64K + code size Th
> My linux is Hed Hat and I have a problem with my
> database: when I tried to connect with mysql, this
> message appear:
>
> "can't connect to local mysql server through socket
> /var/lib/mysql/mysql.sock (111).
>
> Please, someone help me.
>
> Thanks.
>
> Cristiana.
This could be because mysql
My linux is Hed Hat and I have a problem with my
database: when I tried to connect with mysql, this
message appear:
"can't connect to local mysql server through socket
/var/lib/mysql/mysql.sock (111).
Please, someone help me.
Thanks.
Cristiana.
> I just installed my first Master/Slave setup Tuesday ... followed the
> instructions in the Manual
>
(http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Ad
> ministration.html#Replication).
>
> It was a snap!
>
> Gerald Jensen
How's it going for you - is it in production u
I just installed my first Master/Slave setup Tuesday ... followed the
instructions in the Manual
(http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Ad
ministration.html#Replication).
It was a snap!
Gerald Jensen
- Original Message -
From: "Kamesh P S" <[EMAIL PROTE
> can anybody please desc
> from the scratch (user rights)
> of configuring 2 mysql servers in
> master/slave fashion for replicatiom.
http://www.mysql.com/doc/R/e/Replication.html
Not that difficult to find...
--
Luis Calero Muñoz
$email{luis} = '[EMAIL PROTECTED]'
$who{luis} = 'sys
Hi anybody,
am a newbie to mysql and i want to install
master/slave mysql server for replication.
can anybody please desc
from the scratch (user rights)
of configuring 2 mysql servers in
master/slave fashion for replicatiom.
thanx in advance.
bye
kamesh
_
I only want to run 1 copy of mysql.. just bind 2 two different ip
addresses.. one localhost.. and one of my external addresses.. i want to
only have one copy running thou.
DJ
- Original Message -
From: "Chris Bolt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 27
Hello Friends,
I am using a different technology named zolar. It has
its parser file, which should be kept in the cgi-bin
directory in linux. so, whenever we call any file
written using this technoloy we will call as:
http://hostname/cgi-bin/zolar/file-name
I am using mysql 3.22.3
¤Þ¨¥ [EMAIL PROTECTED]:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and include the entire text
Hi!
allways when i want to open an special table i get error 144 and in
phpmyadmin it's said that the table is in use
anybody there who can help me
thanx
Alexander Jäger
-
Before posting, please check:
http://www.mysql.co
> Hi,
> How could I retrieve data from MySQL and put it to data array? here is
example
>
> Table Sale
> Field1 --> Date
> Field2 --> Sale Amount
> ---
> Date Sale Amount
> 1/1/2001 1000
> 1/2/2001 2000
> 1/3/2001 3000
>
>
> $data_array=array (
> array('1/1/2001',1000),
> array(
My pc is linux os, install mysql , one table have a field longtext, and
when it become 26M, when insert recode, it report "get 127 error table
handle".
I do not know what can let mysql occured this error, and how to protect
it.
when it occur error, I have to stop the mysql, repaire it
> I have been trying to get mysqld to run under 2 ip addresses
> (localhost and an external ip address). Using the bind-address
> option twice doesnt seem to work, nor does lisiting 2 ip addresses
> in the option. I hope mysqld has this functionality to be able to
> run under certain ip addre
Hi !
I got a power failure on my database machine and now I cant start it
since I got a error 22 when I start it.
How do I fix this? And what does error 22 mean?
I looked at http://www.mysql.com/doc/R/e/Repair.html but nothing there
seems to fix it.
//eric
21 matches
Mail list logo
