Hi!
I installed the same rpms on a SuSE 9.2 box and tried to reproduce that
problem, but that problem didn't happen. It seems that this problem has
something to do with RHEL3, right?
Thanks.
Hao Xu
Hello.
If you are able to reproduce this problem on another box with a similar
I'd hate to use Microsoft's SQL server, but I feel like i've hit a
dead end with mysql.
If anyone can offer some advice on how to get mysql running on windows
ce, or can point me to some programmers who would be willing to port
the source code for me, please contact me.
-LiquidIce
[EMAIL
I haven't tried it yet, but I'll try it next time it happens, to see if
the problema disappears.
We actually have some connection problems that can be relevant to my
problem:
Warning: Lost connection to MySQL server during query in
/home/httpd/...some.php on line 9
We solved them by the
From: David Lloyd
journalling file system. It's not always that clear cut. I've just
switched a number of big customer databases to InnoDB and noone's
noticed any difference - if anything it's going faster.
For small tables (50,000 records) MyISAM is usually a lot faster. However,
MyISAM gets
Hi,
our MySQL server can handle 1000 connections. We have two JBoss instances.
Each configured with max. 100 connections in pool. furthermore we use php
which make on each call a connection to MySQL. After a while (some days) we
get this:
java.sql.SQLException
MESSAGE: Data source rejected
Hi, we're running 4.1.11 on two Debian woody machines and replication on the
'laterooms' database is working marvellously with the exception of altering
table structure. If I execute an ALTER TABLE ... ADD... no error is
generated, but the slave does not add the column.
Of course then INSERTS
At 11:14 19.04.2005, prasanna a wrote:
Hi
It means that mysqld has received many connect
requests from that host.If the erro on connecting to
But than we should get to many connections.
mysqld exedes the parameter max_connect_errors
How can there be an error?
(Default value is 10).
We change this
A new version of MySQL Community Edition 5.0.4-beta Open Source database
management system has been released. This version now includes support
for
Stored Procedures, Triggers, Views and many other features. It is now
available in source and binary form for a number of platforms from our
Hello,
I've got a table with a simple structure:
site_id, page_id,header_text,main_text..
I just need to duplicate existing records with a new site_id, so :
1,1,Hello,some text..
1,2,Hello Again, some more text...
gets copied to
2,3,Hello,some text..
2,4,Hello Again, some more text...
The model I described is indeed tailored more for tracking changes and
archiving historical records because those were the requirements of the
project I was implementing ;-) I just had to figure out the most optimal way
of addressing these requirements using MySQL 4.1.
MERGE tables are an
Hi,
I have a problem with mysqldump when I want to copy a table from a database.
I have mysql Ver 14.7, Distrib 4.1.9, for pc-linux-gnu.
I use the following command:
mysqldump -h host -u user -ppassword database_name table_name
table_name.sql
And get the following error message:
mysqldump:
Hi,
I am trying to create a query that returns a users availability for the next
ten days using version 4.1.11. A user has 8.5 hours available per day so a
users availability is equal to 8.5 less any bookings they have on that day.
I have a table called Bookings (see below), and each 'Booking'
Hello,
Yesterday I asked for some help to create a program in C++ integrated with
MySQL. Now I have installed MySQL 4.1.11 and I suppose I will need to
include mysql.h in my code. But this header use 'libmysql.dll', where I have
to define the path in Visual C++? Or where I have to copy this
On Tuesday 19 April 2005 13:17, Anna Henricson wrote:
Hi,
I have a problem with mysqldump when I want to copy a table from a
database. I have mysql Ver 14.7, Distrib 4.1.9, for pc-linux-gnu.
I use the following command:
mysqldump -h host -u user -ppassword database_name table_name
Hello.
See:
http://dev.mysql.com/doc/mysql/en/blocked-host.html
our MySQL server can handle 1000 connections. We have two JBoss
instances.
Each configured with max. 100 connections in pool. furthermore we use
php
which make on each call a connection to MySQL. After a
Hello.
Could be that the connect command fails, then I start trying and trying,
and then the server blocks because it receives too many connections? Then
the error message would be the one that I'm getting?
I also thought about this and therefore I gave you that advice. What
is
Hello.
You're sure that you are running an official binary?
Xu Hao [EMAIL PROTECTED] wrote:
Hi!
I installed the same rpms on a SuSE 9.2 box and tried to reproduce that
problem, but that problem didn't happen. It seems that this problem has
something to do with RHEL3, right?
From: Lee Denny
site_id, page_id,header_text,main_text..
I just need to duplicate existing records with a new site_id, so :
1,1,Hello,some text..
1,2,Hello Again, some more text...
gets copied to
2,3,Hello,some text..
2,4,Hello Again, some more text...
page_id is already
At 11:07 19.04.2005, Gleb Paharenko wrote:
Hello.
See:
http://dev.mysql.com/doc/mysql/en/blocked-host.html
thx. I know this. But some user comments are interesting, while we are
using nagios.
Regards,
Rafal
our MySQL server can handle 1000 connections. We have two JBoss
instances.
Each
Dear All,
I'm really happy to let you know that after a whole year of hard work
the University of St.Gallen has developed a new research
platform Alexandria based on MySQL and PHP.
http://www.alexandria.unisg.ch
I'm really would like to say thanks to MySQL AB who did support our
work in a
hai,
when ever the power goes or the system restarts when im entring data from my
vb application to mysql 4 database
it gets corrupted and i loose some data at the end please can any one help
me in this
regards
prathima rao
--
MySQL General Mailing List
For list archives:
i want to join mysql mail list
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
prathima rao wrote:
hai,
when ever the power goes or the system restarts when im entring data from my
vb application to mysql 4 database
it gets corrupted and i loose some data at the end please can any one help
me in this
regards
prathima rao
Get a backup powersupply with shutdown software.
thanks for the reply! I am not too concerned about cutting out the columns
as I may need to other information for later.
I was just wondering does it make a difference if both of the columns that
I am interested have entries that are NOT unique?
Also, at what point does one need a parser or use
Hello
I have sent this e-mail 2 weeks ago and did not get any answers. Please
allow me to give a second try.
I have Mysql 4.1.7 on Solaris / innodb tables
I have 2 innodb_log_files of 100M each. A group of statements (19000
insert) does that both logfiles are stamped with the same time. It might
Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any
error messages to post. Server just stops???
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: Joerg Bruehe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: MySQL General List mysql@lists.mysql.com;
[EMAIL
What were you doing when it failed? What type of connections was it
handling?
Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any
error messages to post. Server just stops???
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: Joerg Bruehe [EMAIL
I don't think anyone's replied with an actual great circle
calculation. Here's our zipcode table, populated with data
from zipcodedownload.com (and note the index on zipcode,
latitude, and longitude:
CREATE TABLE `zipcodes` (
`zipcode` char(5) NOT NULL default '',
`zipcode_type`
Hi,
Just as a speed note! It's faster to calculate a square and find those
records and then drop the corners with the circle calculation.
Scott.
-Original Message-
From: Eamon Daly [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 11:20 AM
To: Scott Haneda; MySql
Subject: Re:
Interestingly enough, I found another great circle
routine here:
http://www.meridianworlddata.com/Distance-Calculation.asp
and adapted it for MySQL like so:
SELECT
b.zipcode, b.state,
3963.0 * acos(
sin(a.latitude/57.2958) * sin(b.latitude/57.2958) +
cos(a.latitude/57.2958) *
Here are the sequence of queries that executed before the server crashed...
CREATE TEMPORARY TABLE COMETTRACKER.DELIVERY_TRACKING_ETA (
PACKAGEID BIGINT NOT NULL,
RECID_CTASKDATA BIGINT ,
RECTYPE INT(11) ,
USERID INT(11) ,
TIMETAG1 DATETIME ,
TIMETAG2 DATETIME ,
P_DATA1 VARCHAR(20) ,
P_DATA2
Talk about over complicating things... here's the above query simplifed.
I can not figure out why they were self joining the table three times:
SELECT b.zip_code, b.state,
(3956 * (2 * ASIN(SQRT(
POWER(SIN(((a.lat-b.lat)*0.017453293)/2),2) +
COS(a.lat*0.017453293) *
Hi,
I wrote some weeks ago to the mailinglist with the same problem. The
performance isn't still much better.
I try to find the optimal value for tmp_table_size (now set to 67108864),
cause we have some problems. Sometimes I see, that the result data will be
copied to tmp table:
Copying to
Hank wrote:
Talk about over complicating things... here's the above query simplifed.
I can not figure out why they were self joining the table three times:
Also, the index on zip_code, latitude, and longitude doesn't
make sense. Only the zip_code part of it was used, so it should
have been on
On 4/19/05, Keith Ivey [EMAIL PROTECTED] wrote:
Also, the index on zip_code, latitude, and longitude doesn't
make sense.
Yeah - I didn't even notice the indexes in the table def (I used my
own existing zip code table). That table def and query were obviously
created by someone pretty green
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: 5.0.4 (and 5.0.3) segfault when presented with a specific query
containing a subquery of
I'm trying to do an update to one of my tables, but I'm getting the
table name is full error. I've reviewed the manual
(http://dev.mysql.com/doc/mysql/en/full-table.html), but nothing seems
to apply. I looked at the output of myisamchk, and everything looks
fine. The table file is only
Both load data infile and mysqlimport both support the ignore option.
If you are loading a file into a table with a unique index and
duplicate rows in the file any duplicates will be silently ignored.
On 4/19/05, newbie c [EMAIL PROTECTED] wrote:
thanks for the reply! I am not too concerned
I am installing MySQL on a server with limited space available and I'd
like to minimize the footprint of the installed database. is there
information available on what parts of the installation I can safely
delete without harming functionality of the database?
I'd love to hear recommendations
Hank [EMAIL PROTECTED] wrote on 04/19/2005 01:33:51 PM:
On 4/19/05, Keith Ivey [EMAIL PROTECTED] wrote:
Also, the index on zip_code, latitude, and longitude doesn't
make sense.
Yeah - I didn't even notice the indexes in the table def (I used my
own existing zip code table). That table
Hi,
I've 2 tables of payments
1: payment emission (P: -- ID,ID_cli,tot)
2: part payments (A: -- ID,P_ID,val)
I'd like to retrieve all payment emissions, with all relative part
payments(with a left join), for all ID_cli
and I'd like to calculate the rest to pay...like tot-SUM(val).
but I
No, those indexes were intentional. If you read the section of the manual
on optimizing queries, you will encounter a page that mentions what are
known as covering indexes. The advantage to a covering index is that if
your data is numeric and in the index,
Except that the zip code field is
I'm used to doing something simple such as the following in sql server:
SELECT u.Username, p.UserID
FROM Users u LEFT JOIN
Person p ON u.UserID = p.UserID
However, I'm not seeing the same results in MySQL. I don't get all
the recs in the users table and NULLs in the userID
Rich Brant [EMAIL PROTECTED] wrote on 04/19/2005 03:05:51 PM:
I'm used to doing something simple such as the following in sql server:
SELECT u.Username, p.UserID
FROM Users u LEFT JOIN
Person p ON u.UserID = p.UserID
However, I'm not seeing the same results in MySQL.
I forgot the important part: what I want is to filter on a userID in the
person table such as -
SELECT u.Username, p.UserID
FROM Users u LEFT OUTER JOIN
Person p ON u.UserID = p.UserID
WHERE (p.UserID = 5) OR
(p.UserID IS NULL)
THis
on 4/19/05 9:32 AM, Keith Ivey at [EMAIL PROTECTED] wrote:
Hank wrote:
Talk about over complicating things... here's the above query simplifed.
I can not figure out why they were self joining the table three times:
Also, the index on zip_code, latitude, and longitude doesn't
make
The link below essentially means subquery support is useless for many
traditional purposes. You are stuck in a correlated subquery thus performance
is the query being run out-to-in (subquery run for every row?) instead of
in-to-out as desired. Does anyone know of a work around for this?
OK, I don't see much wrong with this version either.
Again I ask you:
Which version you are using?
Can you post some sample data and the incorrect results?
Here is a similar query that is working for me. This matches Projects with
the people who have the resources to complete them (Suppliers).
Rich Brant wrote:
I forgot the important part: what I want is to filter on a userID in the
person table such as -
SELECT u.Username, p.UserID
FROM Users u LEFT OUTER JOIN
Person p ON u.UserID = p.UserID
WHERE (p.UserID = 5) OR
(p.UserID
James Nobis [EMAIL PROTECTED] wrote on 04/19/2005
04:04:24 PM:
The link below essentially means subquery support is useless for many
traditional purposes. You are stuck in a correlated subquery thus
performance
is the query being run out-to-in (subquery run for every row?) instead
of
I need to move my MySQL databases to another machine.
The current machine the databases are on is running MySQL version 3.23. The new
machine is running 4.0. The machines have the same floating point format. The databases
are *very* large (several hundred tables, most around 4MB, a couple over
On Apr 19, 2005, at 1:35 PM, Jason Dixon wrote:
I'm trying to do an update to one of my tables, but I'm getting the
table name is full error. I've reviewed the manual
(http://dev.mysql.com/doc/mysql/en/full-table.html), but nothing seems
to apply. I looked at the output of myisamchk, and
Yes, I downloaded the 4.1 rpms from
http://dev.mysql.com/downloads/mysql/4.1.html
Hello.
You're sure that you are running an official binary?
Xu Hao [EMAIL PROTECTED] wrote:
Hi!
I installed the same rpms on a SuSE 9.2 box and tried to reproduce that
problem, but that problem
Thank you so much Vivian! Your first solution was exactly what I was looking
for! It works perfectly!
Thanks so much!
Richard
Vivian Wang [EMAIL PROTECTED] wrote:
create table temp select * from viewvisitor order by lastviewtime desc;
select app, itemid, ownerid, visitorid,
On 4/16/05, Scott Gifford [EMAIL PROTECTED] wrote:
Jeff Kolber [EMAIL PROTECTED] writes:
How are sites doing the search by zip and coming up with results within x
miles? Is there some OSS zip code download that has been created for this?
The ones I'm familiar with use this:
Hello,
I have been attempting to uncover a fast method for retrieving unique
items from every column in a table. The table has approximately 60
thousand rows. Each row has an index associated with it, and running
'explain select distinct class from dlist' shows that it is using the
index.
In the last episode (Apr 20), Willie Gnarlson said:
I have been attempting to uncover a fast method for retrieving unique
items from every column in a table. The table has approximately 60
thousand rows. Each row has an index associated with it, and running
'explain select distinct class from
57 matches
Mail list logo