hello!
i wanted to create a virtual IP so i inserted the following line in the
/etc/haresources file:
server1 Ipaddress::192.168.1.1::eth0
but when i started heartbeat, i got the following error messages in the command
line:
Starting High-Availability services: 2006/01/24_23:11:44 ERROR:
On 1/24/06, James Harvard [EMAIL PROTECTED] wrote:
It's the Royal Mail. Ordnance Survey, the government mapping agency for the
UK, are in on it too.
To read their web site (as I have done a couple of years ago, and just now
too) you would think it had never occurred to them that people
Hello.
collation. PHP 4.4 doesn't provide API to work with
Connection Character Sets and Collations. PHP 5 adds
You can change the character_set_xxx variables using SQL
queries. I usually put 'SET NAMES' at the beginning of my
scripts.
立 周 wrote:
--- Gleb Paharenko [EMAIL PROTECTED]写道:
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
David Godsey wrote:
nativecode=2013 ** Lost connection to MySQL server during query
I think 2016 is Lost database connection
What I am doing is I have a PHP class object that calls a stored
procedure. I don't think I'm
Hello.
Make several checks that should help.
Be sure that no instances of MySQL are running on your computer and
check if 5.0.18 starts successfully. Specify another location of the
socket file. Temporary disable SELinux. See:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:system PRIVILEGED account
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
George Law gave me the answer:
http://bugs.mysql.com/bug.php?id=14993
I had read the link you suggested, however it didn't really explain why I
was getting the error.
Thanks.
David Godsey
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
David Godsey wrote:
Hello.
ERROR: 1 Can't create/write to file
'/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/db.MYI'
(Errcode: 13)
perror 13
OS error code 13: Permission denied
Check that user mysqlp has access to
/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql.
My web hosting server runs PHP 4.4 and MySQL 4.1. But
PHP 4.4 doesn't fully support MySQL 4.1. and i have
problems restoring a utf8 encoded database dumped from
a MySQL 4.0 server to the new 4.1 server. Do i have
any chance to get it working in this setup or should i
persuade the hosting
From the result set below I have 22 rows and the only difference is the
date. I was wondering if there was a way to get all of these results using
GROUP BY instead of having to use LIMIT??
As this table grows I'm going to want to get a LIMIT 0,77 but would like it
to be grouped by date. So
Jay Paulson [EMAIL PROTECTED] wrote on 01/25/2006 10:09:36 AM:
From the result set below I have 22 rows and the only difference is the
date. I was wondering if there was a way to get all of these results
using
GROUP BY instead of having to use LIMIT??
As this table grows I'm going to want
Hi,
is there a possibility to collect the sql statements issued to a mysql
db to analyse them??
perhaps there is an extra tool or script for this??
Thanks for any suggestions!
Hello,
MySQL has a few logs that can assist you in capturing statements:
1. The query log shows client connections and executed statements
2. The binary log shows all statements that change data (also used for
replication)
3. The slow log shows all queries that took more than long_query_time
Hi,
is there a possibility to collect the sql statements issued to a mysql
db to analyse them??
perhaps there is an extra tool or script for this??
Thanks for any suggestions!
In the last episode (Jan 25), Chen Abella said:
hello!
i wanted to create a virtual IP so i inserted the following line in
the /etc/haresources file:
You're on the wrong mailing list :) Try the documentation at
http://www.linux-ha.org/ , and the list archives at
FreeBSD / UNIX platform, MySQL ver.4.0.16
Prob. of growing /tmp file, solved by introducing a cron job to clean up
the folder intermittently. Prob.solve but new one created - mysql socket
wiped out. Could not restart the server with all the standard methods.
Complained of other running
The better way to do this would be to have the cart.prod_id be a
foreign key field that references products.id (available as of
3.23.44) and use ON CASCADE DELETE. But that alters your schema,
and you want to think very hard about the problems it might create
(and do it with your data on a test
Joseph E. Maxwell wrote:
FreeBSD / UNIX platform, MySQL ver.4.0.16
Prob. of growing /tmp file, solved by introducing a cron job to clean up
the folder intermittently. Prob.solve but new one created - mysql socket
wiped out. Could not restart the server with all the standard methods.
Complained
This call works fine on Oracle, Access, MS SQL. But Not works on MySQL.
MySQL 5.0.15, MySQL ODBC drive 3.51, The OP is Windows 2000/2003, Program in
VC++
In my SQLDescribeCol call on MySQL
I get correct value on:
ColumnName, BufferLength, NameLengthPtr, NullablePtr
I get corect value on
Has everyone forgotten that since v4.0, MySQL has a multi-table delete
statement?
http://dev.mysql.com/doc/refman/4.1/en/delete.html
Your original query was almost it (Adrian was on the right track, too):
DELETE cart
FROM cart
LEFT JOIN products prod
WHERE prod.id is null
or
If I have about 2Gb of raw text data to import everyday -- can I expect
that to take up about 2Gb in a mySQL database ... slightly more.. double?
Pretend there's no indexes for now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is there a command in mysql that will return the row number. I
tried rownum and rownum()
Clyde Lewis [EMAIL PROTECTED] wrote on 01/25/2006 01:41:30 PM:
Is there a command in mysql that will return the row number. I
tried rownum and rownum()
No, rows do not exist in the base data of a MySQL database. They are
called records and records may be stored in any order. Within some
Hi
on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running:
Yes/No)
i need to do some testing with my script and i got to make sure it reads that
value correctly.
regards
Morten
Excellent explanation. Thanks again.
CL
At 02:00 PM 1/25/2006, [EMAIL PROTECTED] wrote:
Clyde Lewis [EMAIL PROTECTED] wrote on 01/25/2006 01:41:30 PM:
Is there a command in mysql that will return the row number. I
tried rownum and rownum()
No, rows do not exist in the base data of a
Alternatively, you could try something like this :
SET @rownum = 0;
SELECT @rownum := @rownum + 1 AS rownumber_column,
some_real_columnnames
FROM your_table
LIMIT 100
-Original Message-
From: Clyde Lewis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 25, 2006 3:14 PM
To:
HI,
2006/1/25, Cummings, Shawn (GNAPs) [EMAIL PROTECTED]:
If I have about 2Gb of raw text data to import everyday -- can I expect
that to take up about 2Gb in a mySQL database ... slightly more.. double?
It all depends on your columns, indexes, and so on...
SLAVE STOP;
or
STOP SLAVE;
work equally well.
Or am I not understanding your question correctly?
-Sheeri
On 1/25/06, Morten Kallesøe [EMAIL PROTECTED] wrote:
Hi
on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running:
Yes/No)
i need to do some testing with my
Check out:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
(I've noticed this has come up a lot recently on the list. . .)
-Sheeri
On 1/24/06, Jonathan Mangin [EMAIL PROTECTED] wrote:
I got exactly that error message last
The quick answer is: it depends. If you read in the manual the
documentation for innodb and myisam tables, you'll see that they're
both stored in an operating-system (somewhat) independent way.
http://dev.mysql.com/doc/refman/5.0/en/moving.html
That references the page Gleb replied with, but
that would make both
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
go to No
i only want to stop the Slave_SQL_Running and keep the Slave_IO running
so my show slave status would report the following:
Slave_IO_Running: Yes
Slave_SQL_Running: No
it happens if the mysql recives an update
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
Thanks
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Are there any statistics that I can use to determine how high or low I
should set max_connections? I am using MySQL as the backend for a Java web
application that will need to accommodate a moderate amount of traffic.
Also, if max_connections is set too high relative to the needs of the
I think I have a problem with mysql related character sets and collation.
With language English (en-utf-8), MySQL charset UTF-8 Unicode and a MySQL
connection collation: ascii_general_ci. I can execute a sql statement in
phpmyadmin, like INSERT INTO mytable (id, name) VALUES ('5','Unterwinkel
I execute follow statement.
-
shellreplace @@session.sql_mode=0 @@session.sql_mode=1 -- 1.01
-
But string @@session.sql_mode=0 doesn't replace to @@session.sql_mode=1.
- Original Message -
From: Gleb
On Wed, 25 Jan 2006, [iso-8859-1] Morten Kalles?e wrote:
Hi
on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running:
Yes/No)
i need to do some testing with my script and i got to make sure it reads that
value correctly.
Please follow this link
On Mon, 23 Jan 2006, George Law wrote:
Just a quick question regarding mysql backups.
I know myisam tables are portal from machine to machine, but I know
there are some differences
Between innodb tables.
I am running mysql 5.0.18 on suse linux 10. I have innodb set up so it
stores each table
Hi Gleb,
localhost.(none) show session variables like %version%;
+-+--+
| Variable_name | Value|
+-+--+
|
38 matches
Mail list logo