Hi,
Please provide details like what tables are you using, the entire my.cnf
and the information from the mysqld.err when the crashes occurred.
--Alex
On Wed, 04 Jan 2006 06:11:24 +0530, Jonathan Chong <[EMAIL PROTECTED]>
wrote:
Hi everyone
I run a relatively popular forum that get
I refer a question about "sql security" option of create procedure syntax at
2005-12.
But i can't quite understood with that answer.
Can you give me a example to describe the effect of set "sql security" option ?
Logg, Connie A. wrote:
I was asked (told) by my security people to use a port < 1024. I am
running with 1000 other places, and was running with 1000 on both of
these machines.
-Original Message- From: Jeremy Cole
[mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03, 2006 4:25 PM
To:
Hi everyone
I run a relatively popular forum that gets overloaded on match days.
On normal days, the site is coping fine, but when there are plenty of
users on the forum (about 50-70 odd) the load goes up and the site
crawls, before crashing, and the server rebooted
The forum software is phpBB.
I was asked (told) by my security people to use a port < 1024. I am running
with 1000 other places, and was running with 1000 on both of these machines.
-Original Message-
From: Jeremy Cole [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 03, 2006 4:25 PM
To: Logg, Connie A.
Cc: mysql@
Hi Connie,
060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port:
Permission denied
060103 15:54:02 [ERROR] Do you already have another mysqld server
running on port: 1000 ?
You can't bind to a port less than 1024 unless you're running as root.
I suspect that's the problem here.
I am trying to start mysql and I keep getting the following error. There is no
other server or anything else using port 1000. I have checked netstat and the
port is not active.
60103 15:54:02 mysqld started
060103 15:54:02 InnoDB: Started; log sequence number 0 386242
060103 15:54:02 [ERROR]
Howdy all,
First off, We're running 5.0.15.
Theres a particular update statement that we run that
updates data in several tables. On our mac OSX test
server (also running 5.0.15) the query executes
quickly and without any errors or warnings.
On our linux box, which is our production box, we get
I just issued a "show status" query and the numbers are what MySQL returns.
Strange.
Failed attempts (aka aborted_clients) : 8154
Aborted (aka Aborted_connects): 319
Total (aka Connections) : 4626
So phpMyAdmin is basing the % calculations on these numbers, that's why we
see the weird percentage.
John Hoover <[EMAIL PROTECTED]> wrote on 12/31/2005 04:18:34 PM:
> I need some advice re my choice of a storage engine for transaction-
> safe processing and including tables that are not transaction-safe
> within transactions.
>
> The problem: We need to insert related records into several
> d
I need some advice re my choice of a storage engine for transaction-safe
processing and including tables that are not transaction-safe within
transactions.
The problem: We need to insert related records into several different tables
and be sure that all the insertions succeeded. It seems that t
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
Daniel Kasak <[EMAIL PROTECTED]> writes:
Bryan Cantwell wrote:
Trying to migrate to MySql 5 from Sybase asa. I have a tables that
have column values that are calculated based on other columns in the
table. How can I accomplish the sa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 5.0.0 Beta, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released. You will notice that there is a new
version numbering scheme for this release that more closely aligns with
the server version that the JD
I used phpMyAdmin to look at the stats for my MySQL server.
here's what they show...
http://www.2-bit-toys.com/db_info/server_status.html
What concerns me mainly are the stats at the top-right...'Failed attempts'
and 'Aborted.'
When would these situations occur? Is it normal to see these?
I'm
Hello Chander,
thank you very much.
I tried to do in your way ad the installation works!
I downloaded the perl(DBI) .rpm and I installed it the first time using the
command:
rpm -Uvh perl-DBI-1.50-1.i386.rpm
but I got back an error about one glibc library not founded, so I use this
format:
rpm -
Morning Jon,
You will not be too successful in using MySQL logging to trace this. You
need to be able to connect to the server at the very least before this
would help.
I don't know much about MailScanner but I would be checking a couple of
things, 1) do you have a firewall in place? is the port
MySQL List,
I have recently switched over from Windows to Ubuntu Linux, in order to
emulate as much as possible the environment I have on my web hosting
service. The goal is to be able to develop and test my web sites more
completely at home before uploading them.
I have successfu
Yes, potentially there are "gotchcas". It all depends on your current
MySQL server version and the version you are upgrading to.
Assuming you are upgrading 3.23 to 4.0, what I would do is look at the
official documentation regarding upgrades from exactly this scenario:
http://dev.mysql.com/doc/ref
Jon Miller wrote:
System:
Red hat 7.2
My SQL modules:
MySQL-devel-4.0.13-0
php-mysql-4.1.2-7.2.6
MySQL-shared-3.23.55-1
MySQL-server-4.0.13-0
MySQL-client-4.0.13-0
CAMysql-9.0-220
Msql-Mysql-DBI-perl-bin-1.1823-1
I would like to log or turn on the facility to do a verbose logging to
troublesh
In article <[EMAIL PROTECTED]>,
Daniel Kasak <[EMAIL PROTECTED]> writes:
> Bryan Cantwell wrote:
>> Trying to migrate to MySql 5 from Sybase asa. I have a tables that
>> have column values that are calculated based on other columns in the
>> table. How can I accomplish the same in MySql?
>>
> Thi
You can force the installation (--nodeps) when installing the RPM package.
Even if you build DBI (and not install it from RPM) it won't be in the
RPM database, and you'll get the same error.
You should be able to get a FC2 RPM for the DBI module - download that
RPM and install it, then instal
InnoDB does purge deleted rows from the ibdata files. Certain
PostgreSQL advocates have been spreading a claim that InnoDB would not
do that, but the claim is false.
If your ibdata file keeps growing indefinitely, please check with SHOW
INNODB STATUS that you do commit all your transactions.
The online documentation would be a good place to start.
http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
> -Original Message-
> From: Jon Miller [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 01, 2006 7:44 PM
> To: mysql@lists.mysql.com
> Subject: need to upgrade
>
> I need to u
Hello everybody,
This is the first time I try to install MySQL 5.0, I think I followed the
steps showed by the documentation in the right way, but when I run the
command:
rpm -i MySQL-server-Version-.i386.rpm
I get back the error:
error: Failed dependencies:
perl(DBI) is needed by MySQL-
Hi all
I followed Gleb's advice (see below), removed all filters, restarted the db
servers -> same behaviour. Still replications work if there are changes made
on A. Then these changes are replicated A->B->C. When making changes on B, i
can see them in the bin-log on B and the relay-log of C but
Heikki Tuuri wrote:
Carl,
InnoDB does purge deleted rows from the ibdata files. Certain
PostgreSQL advocates have been spreading a claim that InnoDB would not
do that, but the claim is false.
Could You explain more about reusing space previously taken by deleted
rows? Is this concept simil
I have been using mysql client for some time when I got this error:
mysql> select * from mytable;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 1045 (28000): Access denied for user ''@'' (using
password: YES)
ERROR:
Can't connect to the server
mysql>
> # mysqlmgr add database www1
> # mysqlmgr add user www1 password xxx
> # mysqlmgr allow user www1 database www1 read write define
I suppose in some cases this is OK, and I'm sure you will test thoroughly! :-)
One thing to bear in mind is that if you define a user and then revoke
his
System:
Red hat 7.2
My SQL modules:
MySQL-devel-4.0.13-0
php-mysql-4.1.2-7.2.6
MySQL-shared-3.23.55-1
MySQL-server-4.0.13-0
MySQL-client-4.0.13-0
CAMysql-9.0-220
Msql-Mysql-DBI-perl-bin-1.1823-1
I would like to log or turn on the facility to do a verbose logging to
troubleshoot an issue I'm havi
Hello list
I've just install v4.1.
Every thing works fine exept SQLyong shows all non-latin characters as
question marks and the old Mysql-Front can't connect with tables after
mysql_fix_privilege_tables.
How can I change character_set_client=greek or UTF8 than to latin?
I thing this will solve my
Carl,
InnoDB does purge deleted rows from the ibdata files. Certain PostgreSQL
advocates have been spreading a claim that InnoDB would not do that, but the
claim is false.
If your ibdata file keeps growing indefinitely, please check with SHOW
INNODB STATUS that you do commit all your transac
John,
this SQL statement:
INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT (
CUID
) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID
FROM `TV_LOG_ALL`
group by 2,3;
sets locks on all the records it scans in TV_LOG_ALL. If you have a small
buffer pool, then the InnoDB lock table may indeed gr
Using this tool (VeriTas Backup Exec for windows server v9.1) to backup the
database crashes MySQLd-nt, has anyone else come across this issue at all?
regards
33 matches
Mail list logo
