On Tue, 14 Sep 2004 01:07:53 -0400, Seth <[EMAIL PROTECTED]> wrote:
> I am fairly new to MySQL and I have been trying to form a way to have select rows
> numbers put back to 0, sort of like a reset in some rows of the table.
>
> The table is ladder_1 and I am trying to have the fields
> rank,lra
I am fairly new to MySQL and I have been trying to form a way to have select rows
numbers put back to 0, sort of like a reset in some rows of the table.
The table is ladder_1 and I am trying to have the fields
rank,lrank,wins,loss,games,percent,streak,points,kills on all the rows updated back to
> Hi
>
>
> I have installed some software on aix5.2 .
> the list of software:
> apache-1.3.29-1.aix4.3.ppc.rpm
> php-4.0.6-5.aix4.3.ppc.rpm
> MySQL-3.23.47-3.aix4.3.ppc.rpm
> MySQL-client-3.23.47-3.aix4.3.ppc.rpm
>
> All of them was installed by using the command : rpm -i *.*
> then
>
> Apache and
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command : rpm -i *.*
then
Apache and php can work
but
A friend of mine, who is not a member of the MySQL email aliases, is working toward
her Bachelors degree. She is currently taking a database design course. She mentioned
her current assignment to me and I suggested she allow me to forward this request to
this email alias. I understand this is no
Thanks for the reply, much appreciated.
> this might be a Linux kernel bug. What kernel are you using?
/proc/version
Linux version 2.4.26-ow1 ([EMAIL PROTECTED]) (gcc version 3.2.2 20030222 (Red
Hat Linux 3.2.2-5)) #3 Wed Apr 28 13:39:23 NZST 2004
The problem had been happening approximately once a
The problem is solved.
The server has two network cards. One was not
connected. So I assume that the server was frequently
asking the card which was not connected for a
response. Therefore the performance of the server went
down and the response time for querys went up.
Thank you for your help
J
Is the MySQL server 4.1 - default installed? Did you change any
parameters (variables) for it?
Have you checked the network performance otherwise?
I can't really think of anything that the MySQL server is causing,
though the Linux server could be having an issue, with hardware or
something.
i wi
The problem is that before (like last friday) there
was no problem. The terminals (applications with
microcontrollers) were connecting rapidly to the
server. Today I checked and they will not connect
unless I increase the timeout for the response time of
the server inside the program code of the te
Well, it does not sound to be a problem with the MySQL server if you get
a good response from other computers but just not the microcontroller.
As far as improving the performance of MySQL is concerned, check the
MySQL docs and tons of info when you search google.
- Aman
Jonas Fischer wrote:
Hel
Don't do an "@usrDays", just stick the number in there so that the
statement you create looks exactly like the one you tested with.
If you get a "number" from a user from a form, just put that value into
the string. For instance if the user enters 43 into a field on the first
page, put 43 into
I'm wondering whether or not I should implement fulltext searching for 2 letter words
within a product database (HP, TV, G5, LG, etc)... My searchable text is currently
about 600Mb and a 3-letter fulltext index is consuming about 420Mb.
Is the trade-off for user convience vs. performance worth
Shawn - You answered the right question. Since a SQL
statement is closer to my grasp right now , today,
trying that approach.
I think this is something close to correct, though I'm
stuck on what to assign to @usrDays:=
SELECT DateEntry from Entry_Table,
WHERE DateEntry >= DATE_SUB(CurDate(),
Hello
When I am connecting to mysql server with another
computer I have no problems. But connecting with a
microcontroller the mysql server is sending the
response very slow. And it is getting slower and
slower. Right now the only way I found is to enlage
the timeout of the microcontrollers so tha
DVP - Thanks...
I created a cron job to run show innodb status every minute and dump it to a file. In
additional I turned on innodb_lock_monitor. Hopefully, if this happens again, I will
have a snapshot of the situation.
It's still a bit frustrating not being able to see what was the cause w
Great explanison. I guest this is the point. after
each time the table crashed during such process, it
always followed a error message saying something about
the memory violation.
Thanks a lot. your idea also open my mind and deeper
my understanding about mysql.
Monet
--- Dathan Vance Pattishall
http://dev.mysql.com/doc/mysql/en/Error-handling.html
I would look at your wait_timeout settings, if the mysqldump slept for
greater then this setting then this could be the cause of your error.
Why would the connection sleep? It has to flush the buffer to disk or
STDOUT.
DVP
Dathan Vance
Basically the application can get this message because another process has a
lock on the rows that the delete needs to cover for a time period then your
lock_wait_timeout. Is there some cron process? Is the table index properly?
What your average query transaction?
Active your slow query log to se
IN is a fantastic operator, but there are some limitations especially memory
wise.
Check out this algorithm
Say you're using an Integer with an average of 8 digits, i.e. in the 100s
millions, now you send an in list of say 20 of these 8 digits numbers. Since
the data is passed to mysql as a strin
Hi there,
I used very likely statement last week to update one
table. My IN value is around 20. I checked the manual
and there is nothing about any limitation on IN
values.
However, when i was running it, it worked very well
sometimes, while sometimes, the query crashed in the
middle and i have to
Hi,
I have a question about Mysql replication,
I wanted to know how can I replicate a part of a Table data between 2 databases
in mysql4, and not the all tables data.
I already set mysql replication between the databases, and its worked fine,
But I need to filter data to replicate based on custom
Yes it is possible and you only need to use LEFT join if you need all of
the records from "issues" whether there are records in users that match or
not.
Just JOIN the users table TWICE and assign each one it's own alias, like
this:
SELECT
FROM issues i
INNER JOIN users u1
on u1.id
Toro,
this might be a Linux kernel bug. What kernel are you using?
You have done very little processing, the log sequence number is only 400
MB.
Looks like a thread has been waiting for a disk read. The output shows that
the InnoDB 'event' it has waited for is already signaled. In Unix, an InnoD
Hello All
V4.0.16 on Sun Sparc 5.8
Innodb_lock_wait_timeout = 50.
A application using jboss got this error a few days ago. The SQL being used, AFAIK,
was a simple delete from table where date = {date}.
I am trying to determine why this happened. Searching back in the MySQL lists
archives, I
I have a table called issues and other table called users. Issues contains
two fields that are in effect userids that reference the users table. I
want to produce a report with a single query that grabs the names of both
users referenced in the issues table. Is this possible?
I knwo how to do t
At 19:41 +0300 9/13/04, Egor Egorov wrote:
"Dan Cumpian" <[EMAIL PROTECTED]> wrote:
According to the documentation, when delay_key_write is active the index
keys aren=92t written to disk until the table(s) are closed. When is a =
table
closed? Is it only when a connection is closed?
When connec
Stuart,
I feel you pains. I think I can speak for most of us to say "we've been
there, too"
First, You want to try to keep your column values on the LEFT side of any
inequality. MySQL just goes faster that way.
SELECT
WHERE EntryDate >= DATESUB(CurDate(), Interval 2 day
Just go to http://dbi.perl.org/
You will need to download DBI and DBD::Mysql. Then you could install it manually,
even no need to run the CPAN shell.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
Mayuran Yogarajah <[EMAIL PROTECTED]> wrote:
> Is there some way to trim the 50gb+ file down ?
Yes, dump the databases using mysqldump, then recreate the autoextend
InnoDB tablespace and then run the .sql script.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
I have forwareded your question to [EMAIL PROTECTED]
They will contact you soon.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
"Dan Cumpian" <[EMAIL PROTECTED]> wrote:
>
> According to the documentation, when delay_key_write is active the index
> keys aren=92t written to disk until the table(s) are closed. When is a =
> table
> closed? Is it only when a connection is closed?
When connection is closed, when FLUSH TABLES r
Haitao Jiang <[EMAIL PROTECTED]> wrote:
> We are using following steps to re-load and re-build a table every day:
>
> truncate the table
> disable index
> load data
> enable index
>
> What are the important parameters I should be watching out to make the
> "ebale index" step faster? Out table is
"Joel McConaughy" <[EMAIL PROTECTED]> wrote:
> I'm trying to implement a UDF that supports xpath evaluation on a column
> using the gnome libxml2 library. The library is thread-safe EXCEPT for
> the initialization and deinitialization routines which need to be called
> on a pre-process basis. My
Marten Lehmann <[EMAIL PROTECTED]> wrote:
> I'm experiencing a strange thing: When bind is running without
> "bind-address" everything works fine. But when I'm doing a "bind-address
> = ..." the clients get "Lost connection to MySQL server during query". I
> don't understand this, because ot wo
Patrick Connolly <[EMAIL PROTECTED]> wrote:
> I've been trying to contact MySQL AB using the "contact us" link. I
> got a auto-response to the effect that I'd get a real reply in 2 days,
> but that was a week ago. My question was about a login that seems to
> also go into a black hole.
>
> Has
Juan Fernandez <[EMAIL PROTECTED]> wrote:
> I am trying to install mysql without the server on fedora:
Don't install Fedora packages.
Install binary packages downloaded from www.mysql.com in RPM format.
You will probably need MySQL-shared and MySQL-client if you don't want
the server.
--
Howdy all,
I got this error while running a routine mysqldump
last night: Error 2013: Lost connection to MySQL
server during query when dumping table `contact_log`
at row: 41245
I didn't find any good information on this error at
mysql. Is there a page there that lists all error
codes? I found on
Juan Fernandez wrote:
I see 3 packges:
Mod_auto_mysql-20030510-3.i386.rpm
Mysql-3.23.58-4.i386.rpm
Php-mysql.
Which one to pick
Thanks !!
Mysql-3.23.58-4.i386.rpm
-- Alex
-Original Message-
From: Alex Greg [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 4:06 PM
To: Juan Fe
Shawn, partially discourage but mostly confused about
what I really need to do.
Bear in mind for a moment, that I'm working in a
somewhat untradional manner. Meaning a) very new to
database and SQL b) (and i realize this list is not
for programming languages) using a RAD that allows me
to point,
Were you able to solve you problem another way or just discouraged by my
response? I wasn't trying to make you feel bad, you just covered so much
ground in your original post that I really couldn't understand your issue.
Please, post again but with a little more background.
We all want to h
Hi,
>I have some questions. I need urgent solutions for these. Could you
spare some time for me for helping me. I hope you can.
>
> 1) Is MySQL 4.0 Classic version is free downlodable?. If so, can you give
me the url please?.
>
> 2) What will be the equivalent of Pro*C API's in MySql?. Fo
Ok, never mind . I guess a conditional loop is not
needed.
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have some questions. I need urgent solutions for these. Could you spare some
time for me for helping me. I hope you can.
1) Is MySQL 4.0 Classic version is free downlodable?. If so, can you give me the url
please?.
2) What will be the equivalent of Pro*C API's in MySql?. For th
A whole lot of context would be very useful in helping us understand your
issue:
What is the purpose of the Entry_Table table?
What were you trying to accomplish with the CountBack_Table table?
What were the intended purpose and the expected results of the query that
you couldn't write?
How doe
Since you do not seem to have subqueries available to you (pre 4.1.x),
have you looked at modifying your queries to use JOINs, temp tables, or
both?
What is it you are trying to accomplish, we can help you to build the
appropriate statement(s). Optionally, you can upgrade to a version that
su
I will say it AGAIN :-(
The ODBC drivers (your "client" if you go through them to access the
database) ARE NOT 4.1+ CLIENTS. The most recent version shows that they
are 3.xx.xx drivers which means that you are using a pre-4.1 client to
access a post 4.1 server. The articles you read describe
Hi!
On Sep 13, Marten Lehmann wrote:
> Hello,
>
> 4.1 offers some interesting new features like more secure passwords and
> subqueries. However, this release is still labeled "a-gamma"; on the
> other hand it shall be used for future development. What's that "a" for
> (usually for alpha) if it
I believe that everyone is using the same words to mean different things.
Bruce, when you say "grouped around" what result would you like to see?
Make up some sample data, or use some of your real data, and demonstrate
what you expected from the database when you say "grouped around". When we
u
I read through the parts of the manual that applied
but I might be missing something here.
I have a table where I'm trying to query the date with
a conditional statement. As you'll see , if 3 was the
condition then the statement should result in a list
of any entries made <= current date.
It j
Hi Marten,
Hello,
4.1 offers some interesting new features like more secure passwords
and subqueries. However, this release is still labeled "a-gamma"; on
the other hand it shall be used for future development. What's that
"a" for (usually for alpha) if it's also stated "gamma"? Is gamme the
la
I see 3 packges:
Mod_auto_mysql-20030510-3.i386.rpm
Mysql-3.23.58-4.i386.rpm
Php-mysql.
Which one to pick
Thanks !!
-Original Message-
From: Alex Greg [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 4:06 PM
To: Juan Fernandez
Cc: '[EMAIL PROTECTED]'
Subject: Re: problem
Hello,
4.1 offers some interesting new features like more secure passwords and
subqueries. However, this release is still labeled "a-gamma"; on the
other hand it shall be used for future development. What's that "a" for
(usually for alpha) if it's also stated "gamma"? Is gamme the last step
unt
Juan Fernandez wrote:
Hi !!
I am trying to install mysql without the server on fedora:
when I issue the command :
[EMAIL PROTECTED] snort-2.2.0]# cd ../mysql-3.23.52
[EMAIL PROTECTED] mysql-3.23.52]# ./configure --without-server
--prefix=/usr/local/mysql
everything is fine but after I issue the com
perror 144 shows
Table crashed.
Run myisamchk on the host file if you can.
95% full is not good.
Mysql needs free space to do database repairs, schema changes, and index
changes.
If you don't have as much free space as your largest table+index you
have a problem.
diegon wrote:
Hello everybody,
M
I am generating a backup of a database using mysqldump and using that dumped file to
repopulate another database.
The dump and import process work just fine, BUT I am having some problems in my
application with some enconding issues.
For example, one of the rows that mysqldump outputs is the
Csongor,
- Alkuperäinen viesti -
Lähettäjä: "Fagyal Csongor" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Monday, September 13, 2004 3:36 PM
Aihe: Re: Dump question: transactions vs. locking
> Hi Heikki,
>
> >Csongor,
> >
>
Hi Ed,
Maybe MyISAM is still a better choice for this use...?
For MyISAM and BDB tables you can specify AUTO_INCREMENT on a secondary
column (or three columns in your case) in a multiple-column index. In
this case, the generated value for the AUTO_INCREMENT column is
calculated as MAX(auto_incremen
Hi Heikki,
Csongor,
in InnoDB, it is better to use
SELECT ... FOR UPDATE
to lock the result set of a SELECT.
Thank you, I think I will go with this one.
A plain SELECT in InnoDB is a consistent, non-locking read that reads a
snapshot of the database at an earlier time. It does not lock anything.
Hi !!
I am trying to install mysql without the server on fedora:
when I issue the command :
[EMAIL PROTECTED] snort-2.2.0]# cd ../mysql-3.23.52
[EMAIL PROTECTED] mysql-3.23.52]# ./configure --without-server
--prefix=/usr/local/mysql
everything is fine but after I issue the command "make I recei
Hi,
I have had similar problems with "do-table", but never succeded finalizing
my bug-report.
I have added (on master) ...
"SET SQL_LOG_BIN = 0" as start of each action where not to replicate data
"SET SQL_LOG_BIN = 1" as start of each action where to replicate data
Further I have had some issue
I've been trying to contact MySQL AB using the "contact us" link. I
got a auto-response to the effect that I'd get a real reply in 2 days,
but that was a week ago. My question was about a login that seems to
also go into a black hole.
Has anyone else experienced similar?
--
___ Patrick
* Oliver Hirschi <[EMAIL PROTECTED]> [09/13/04]:
> Hi people
>
> Due to MySQL does not support "inner-selects", I generate a string (I
> programm java-client) with the values I used in an IN-operator for an
> update onto a mySQL database.
>
> The statement looks like this:
> UPDATE layer SET Stat
Yes. I also tried that. Are there any other suggestions?
What's about the different sections in my.cnf?
Should these statements beeing written under [mysqld_safe], too?
Victor Pendleton wrote:
In the slave's my.cnf have you tried just expliciting statement what tables
to ignore?
replicate-ignore-t
Hi people
Due to MySQL does not support "inner-selects", I generate a string (I
programm java-client) with the values I used in an IN-operator for an
update onto a mySQL database.
The statement looks like this:
UPDATE layer SET State=1
WHERE fpObjectID IN (1,3,4,5,20,34,56,24,56,11,45)
Now, the
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.2.0)
A fast test-data generator tool that comes with a library
of real-life data, presets and much more.
This new release consists of four versio
65 matches
Mail list logo
