Hi List!
Hope you can help me with my problem...
I am trying to incorporate commit and rollback in my sql
statements... I have tried it in my web application which runs
on weblogic and it work fine. However, when I migrated my web
app to Tomcat, it failed to rollback when it encountered an
er
try this:
selectwhere WHATEVER LIKE 'whatever%'
notice the '%' at the end not the beginning...hope this is what you
wanted...
lekker dag verder boet.
- Original Message -
From: "Chris Knipe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 18, 2002 5:54 AM
Subject:
30.328 1 select count(*) as C from articles_category c inner join
db_news.articles a using (article_id) inner join media m using (media_id)
where 1
Query Explanation
table type possible_keys key key_len ref rows Extra
c index PRIMARY PRIMARY 841551 Using index
a eq_ref PRIMARY,
At 23:43 -0400 8/18/02, Randy Johnson wrote:
>I have the latest stable mysql installed with innodb support.. is it
>possible to have all myisam tables but one that i need to have innodb table
>type for row level locking and transactions
Yes.
-
At 17:03 +0200 8/18/02, Bruno Batarelo wrote:
>I belive that I have a little bit bigger problem with MySQL, and for now, no
>one told
>me a solution. Problem is with BLOB fields. That type of field behaves OK if
>I use INSERT INTO statement. But the problem is that it is impossible to use
>INSERT
I have the latest stable mysql installed with innodb support.. is it
possible to have all myisam tables but one that i need to have innodb table
type for row level locking and transactions
Randy
-
Before posting, please chec
Seems to be getting more critical now as well.
Aug 19 01:54:27 netsonic mysqld[48323]: warning: can't get client address:
Bad file descriptor
Aug 19 01:54:59 netsonic last message repeated 13 times
Aug 19 01:54:59 netsonic last message repeated 2 times
>From what I can see, it's spitting out the
PHP's more than likely just loosing persistent connections to the DB.
It's a coding thing I think... You need to call mysql_connect() on every
page where you need to use the database, even if you use mysql_pconnect().
If there's a mysql specific error, I think MySQL would most definitely write
s
I also have a problem with lost connections.
I have small mysql database (version 3.23.49 on FreeBSD 4.5)
I have created a website interface to enter and retrieve data.
I used ASP to do this. Sometimes when I go to the website
I get the error "can't connect or lost connection to server."
The my
Well, first of all this belongs in the myODBC thread as the implementation
of BLOB fields in mySQL is excellent in my opinion. But to answer your
question, you cannot simply put a binary file into a variant type (or any
other type) variable and have it get updated. You need to use the ADO stream
o
I would like to allow articles to be searched and
returned in grouped categories - similar to cnet.com
See example here:
http://cnet.search.com/search?timeout=3&q=mysql
Grouping is not a problem - but it becomes a problem
when there are thousands of results and I only want to
display the first f
Hi all,
I'm testing using a HEAP table to maintain transient state in a high
volume TP environment. So far, it looks promising, and I want to ask
anyone about similar experiences and solicit some input.
Some background:
* I have one table; the row length is ~200 bytes and the table will
typicall
Hi.
On Sun 2002-08-18 at 21:58:04 +0200, [EMAIL PROTECTED] wrote:
> Hello.
>
> On Sun 2002-08-18 at 18:53:46 +0200, [EMAIL PROTECTED] wrote:
> > To Whom it May Concern,
> > I sincerely doubt it's relevant, but i'm running MySQL 3.23.52 on
> > Linux 2.4.18 (RedHat build 5). Client and se
>Hello.
>
>On Sun 2002-08-18 at 18:53:46 +0200, [EMAIL PROTECTED] wrote:
>> To Whom it May Concern,
>> I sincerely doubt it's relevant, but i'm running MySQL 3.23.52 on
>> Linux 2.4.18 (RedHat build 5). Client and server are on the
>>same machine
>> and communicate via a Unix domain s
Hello.
On Sun 2002-08-18 at 18:53:46 +0200, [EMAIL PROTECTED] wrote:
> To Whom it May Concern,
> I sincerely doubt it's relevant, but i'm running MySQL 3.23.52 on
> Linux 2.4.18 (RedHat build 5). Client and server are on the same machine
> and communicate via a Unix domain socket.
>
Hi there,
I've encountered a problem trying to insert large strings into a MySQL
database. I'm running mysql Ver 11.15 Distrib 3.23.39, for dec-osf4.0f
The details follow.
Round 1:
When I tried to insert very long text strings into a LONGTEXT column of a
MyISAM table I was getting errors tha
Hello.
On Sun 2002-08-18 at 17:03:03 +0200, [EMAIL PROTECTED] wrote:
> I belive that I have a little bit bigger problem with MySQL, and for now, no
> one told
> me a solution. Problem is with BLOB fields. That type of field behaves OK if
> I use INSERT INTO statement. But the problem is that it i
Hi!
On Aug 17, Grzegorz wrote:
> Hi.
>
> I'd like to know is it safe to tune mysql-4.0.2/myisam/ft_parser.c
>
> #define true_word_char(X) (isalnum(X) || (X)=='_')
>
> to
>
> #define true_word_char(X) (isgraph(X) && (X)!='@')
Not really. The parser won't recognize boolean search ope
Hello,
Some basic points about these problems:
1) have you another application/mysqld listening on the same tcp port?
2) have you tried different versions (switching between 3.23 and 4.x
series, for example)
3) try compiling from the source with a bit different configuration
parameters
4) do your
In the last episode (Aug 18), Reid Sutherland said:
> Hi everyone,
>
> 'processlist' displays the current list of mysql threads as seen by
> mysql. I'm looking for that same list but in real thread PID form.
> Right now I need to be able to tell which thread is which at a system
> level. Then
On Sat, 17 Aug 2002, Jeremy Zawodny wrote:
> On Fri, Aug 09, 2002 at 04:20:42PM -0400, David Miller wrote:
> > On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
> >
> > Hi Jeremy;
> >
> > I didn't think my server would be doing any name resolution, particularly
> > while replace()ing millions of rows i
Hello all;
Is myisamchk known to have problems in tables with lots of rows?
I've a table with a simple, single, 32 bit integer as a key. I have about
200 million rows in it. I can run myisamchk -o -e names three times in a
row and receive this message each time:
Duplicate key 1 for record at
My dear friend,
If you put the problem in this way .maybe it's a good ideea to go to the
church and make some rosary for solving your problem.
Bye
- Original Message -
From: "Chris Knipe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 18, 2002 9:06 PM
Subject: Re: L
Fair enough,
But then why is MySQL the *only* thing I am having problems with? MySQL's
not the only application running on the box, it's not the only application
opening / closing tcp sockets, its not the only thing opening / closing file
sockets
*shrugs*... Maybe I should just rm -rf / and
For sure "Bad file descriptor" error occur because your kernel it's not
able to create handler for the new open file(don't forget...socket it's also
a file ) which must be open.
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECT
spiros,
you have configured too much memory to buffers in my.cnf. In Linux you
should keep the memory allocation significantly below 2 GB.
Error 4 means an interrupted system call. I am not sure what that would
mean.
Please upgrade to 4.0.2 which has better error messages, and reduce memory
all
I was testing an apparent performance issue while I got a strange perl
message , claiming it (with perl/DBI)
DBD driver has not implemented the AutoCommit attribute at perlscript.pl line
1064, line 12911.
Issuing rollback() for database handle being DESTROY'd without explicit
disconnect(),
> ...or you have too many open files in the system.You reach the max. number
> of files which can be opened by the OS.Try to increase file-max from
> /proc/sys/fs.
>
Highly doubtful. It's a brand new server installation, exactly the same as
all my others, and it's not doing half as much as the
To Whom it May Concern,
I sincerely doubt it's relevant, but i'm running MySQL 3.23.52 on Linux
2.4.18 (RedHat build 5). Client and server are on the same machine and
communicate via a Unix domain socket.
Perhaps it is a conscious decision, but it would seem an odd one: When
usi
Hi,
- Original Message -
From: "Chris Knipe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Victoria Reznichenko"
<[EMAIL PROTECTED]>
Sent: Sunday, August 18, 2002 6:08 PM
Subject: Re: Lost connections on Freebsd
> Lo Michael,
>
> I digged a bit more, and while ru
Lo Michael,
I digged a bit more, and while running under debug mode, MySQL doesnt crash,
it does complain about a bad file descriptor on /etc/hosts.allow.
If this is the cause of the failure, there might be a possibly bug in the
code, because I really think it's arb that the entire MySQL needs t
heikki,
> > Anyone i running MySQL with InnoDB
> > on FreeBSD-Alpha?
> >
> > I get the mysqld compiling/running
> > ok. DB dump is restored ok locally.
> > Locally everything wirks. But it
> > crashes on the incoming network connection.
> >
> > unaligned access:
I belive that I have a little bit bigger problem with MySQL, and for now, no
one told
me a solution. Problem is with BLOB fields. That type of field behaves OK if
I use INSERT INTO statement. But the problem is that it is impossible to use
INSERT INTO when I need to send a string full of binary ch
Greetings
There is a persistant problem while trying to insert a string from within VB
6.0 application to the LONGBLOB field. I use ADO and code for adding new
record is as followes:
TabelaTekst.AddNew
TabelaTekst!Polje = BinaryString
TabelaTekst.Update
and error is: "Multiple-step operatio
Hi.
On Sun 2002-08-18 at 11:13:36 +0100, [EMAIL PROTECTED] wrote:
>
> I asked a question and had a response and answer within the hour - I
> will try my lucj and ask another
Well, but never forget that you ask for other's time, so be sure to
have made your homework first and really cannot come
Hi!
> "Chris" == Chris Knipe <[EMAIL PROTECTED]> writes:
Chris> Lo Victoria
Chris> FreeBSD 4.6-STABLE (Master), MySQL 3.23.51
Chris> Windows 2000 Professional (Slave):, MySQL 3.23.49-nt
Chris> I've recompiled the master about three times now, and it still crashed.
Chris> Eventually, it cam
Hi,
Try installing it in Safe Mode.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
On Sun, 18 Aug 2002 [EMAIL PROTECTED] wro
Hi
I asked a question and had a response and answer within the hour - I
will try my lucj and ask another
In my table I have amongst other things two fields ProjectPrice and
ProjectBalance and in this example they are currently
Projectprice = 100
Projectbalance = 90
Now I only want my select st
To whom it may concern,
I had a bad starts!!!
I was trying to start working with MySQL with Windows 98 so I downloaded
the file "myodbc-21.50.39-win95.zip" to install the drivers for ODBC, after
unzip this file (obviously) I executed the file "SETUP.EXE" receiving the
following message:
Hello,
I am using innodb tables via mysql max
if i do a select * for update
and then do an update statement
will this unlock the record for another update or will it wait for me to do
a commit?
thanks,
Randy
query,sql
-
40 matches
Mail list logo
