Hi Gleb,
localhost.(none)> show session variables like "%version%";
+-+--+
| Variable_name | Value|
+-+--+
| protocol_vers
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
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
http://dev.mysql.com/doc/
I execute follow statement.
-
shell>replace @@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: "Gl
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
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
applica
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:http://lis
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
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 it
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 la
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
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...
http://dev.mysql.com/doc/ref
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: [EM
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
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
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. With
Is there a command in mysql that will return the row number. I
tried rownum and rownum()
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:http://lis
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 prod.o
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 Dat
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
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
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 processes.
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
http://lists.linux-ha.org
> 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
se
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!
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 t
>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 basi
> 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 hostin
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.
[EM
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:
>> native
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:system PRIVILEGED account
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
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
Nathan
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'
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]>
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 peopl
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:
38 matches
Mail list logo
