The original message was received at Thu, 7 Jul 2005 09:34:11 +0200 from
35.120.172.60
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
- Transcript of session follows -
... while talking to server 92.244.150.42:
554 5.0.0 Service unavailable;
I am using MySQL 4.0.22 and have a question about an efficient way to calculate
a running balance as part of the select. The natural way to do this would seem
(to me) to be something like:
set @balance:=0;
select payid,Custid,Paid,@balance:[EMAIL PROTECTED] from payments;
This does indeed
Hello.
mysql Ver 14.3 Distrib 4.1.1-alpha, for pc-linux (i686)
You have an old MySQL version which contains lots of bugs (it's
an alpha!). I strongly recommend you to upgrade to the latest release
(4.1.12 now) and use official binaries.
Hi,
In a table of 20,000 records I am
I have confirmed that this problem exhibits itself on the Mysql AB
compiled binaries that are compiled with gcc, both Standard and Max, but
does _not_ exhibit itself on the Mysql AB binary built with the Intel C++
Compiler 8.1 (mysql-standard-4.1.12-pc-linux-gnu-i686-icc-glibc23.tar.gz).
I have
Hello all!
I have two tables in my database: results(20 000 rows) and
data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
I need to find the samples of data_lab1 table that they are not in
results table.
I think the following query is the solution:
SELECT
Hello.
This issue has been raised in the list already before, however I don't
remember that good solution was found. And without queries which was
executed these log records don't give any useful information in most
production environments.
Francesco Dalla Ca' [EMAIL PROTECTED]
Hello.
Please can you send the complete query and table definition, because
I was unable to reproduce this weird behavior. What version of MySQL do
you use? What client do you use to execute queries? We can see below,
that there is no period before total_bandwidth:
mysql select (SELECT
Praveen KS [EMAIL PROTECTED] writes:
In a table of 20,000 records I am frequented with this error:
Error 1034:
Incorrect key file for table: ''; try to repair it
Frequency of this error: Three or four times a week.
I am logging the data it was trying to insert or update. After I,
Kasthuri Ilankamban [EMAIL PROTECTED] writes:
Hi, We are running mysql version 4.1.7 with innodb on i686 running
2.4.26 linux kernal with 8G memory. Mysql crashes consistently during
heavy usage with fatal innodb error. We are running a high volume front
end application which inserts 50M
Ady Wicaksono [EMAIL PROTECTED] writes:
Dear All
I use RedHat 9 with 2,5 Gbyte RAM, Intel(R) Xeon(TM) CPU 2.80GHz
(Hyperthread),
filesystem ext3 standar linux journaling filesystem.
Today my DB is crash :(, here is the log.
Could it be that our stacks and your heaps might have mixed? If
10 matches
Mail list logo
