Hi,
Is it possible to have a transaction with an update statement pointed to
the master and a select statement pointed to the slave. If the isolation
level of this transaction is REPEATABLE_READ or SERIALIZABLE, will a
commit involve 2PC?
Thanks,
Darpan
--
MySQL General Mailing List
For list
Hi,
I have exported a database using mysqldump from MySQL 5.0.27, and I have
tried importing it in a MySQL 5.0.41, but it gives the following error:
ERROR 1071 (42000) at line 483: Specified key was too long; max key length
is 1000 bytes
Isn't mysqldump exporting the data correctly?
Can I
Are you using MySQL Administrator for Windows ?
Are you using it against MySQL running in Linux ?
If so, you may prefer MySQL Administrator for Linux.
Just a couple more thoughts ...
- Original Message -
From: cfaust-dougot [EMAIL PROTECTED]
To: Weiqi Wang [EMAIL PROTECTED],
Question: How do I restore 1 database from amysqldump of all databases?
Obviously a newbie. I've searched the list but couldn't find the answer.
Can someone help?
Waldo Tumanut
Database Analyst
CONFIDENTIALITY NOTICE: This
When the mysqldump ran against all databases, the USE db-name command should
have appeared above each section of that databases dump. Try using Perl or the
head or tail Unix command to hunt down the Database you are dumping. Read all
lines until the next USE db-name command.
Example: If you
I am running a fairly large Innodb database on mysql 5.x and would like
to know what would be the best variables to monitor (for Nagios)- for
instance: threads
connected,Innodb_data_pending_reads,Innodb_data_pending_writes, slow
queries etc
Aborted_clients
Aborted_connects
Hello all,
I'm trying to do some processing on the front end to optimize my query on
the backend. I would like to generate a list of id's for this query like
so:
SELECT REPLACE('3,4,5,6,7,8,9',',',' OR element_id=') INTO @tmp;
Then use it like:
mysql select @tmp;
Hi Dave,
Dave G wrote:
Hello all,
I'm trying to do some processing on the front end to optimize my query on
the backend. I would like to generate a list of id's for this query like
so:
SELECT REPLACE('3,4,5,6,7,8,9',',',' OR element_id=') INTO @tmp;
Then use it like:
mysql select @tmp;
Thank you Baron, I'll give that a shot, and thanks for the IN() list tip
... much appreciated.
Dave
Hi Dave,
Dave G wrote:
Hello all,
I'm trying to do some processing on the front end to optimize my query
on
the backend. I would like to generate a list of id's for this query
like
so:
Thanks for your response, Rolando. I know all the DML to create the
database is in the mysqldump. I was looking for a command or command
options, if there are any, to extract the DML for the database, like what
you can do with mysqlbinlog.
- Message from Rolando Edwards [EMAIL PROTECTED] on
Prepared Statements with the IN function worked beautifully. Performance
is slightly degraded, but I get the functionality I want and can live with
the slight performance hit.
Thanks again.
Dave
Hi Dave,
Dave G wrote:
Hello all,
I'm trying to do some processing on the front end to
On Tue, 10 Jul 2007 [EMAIL PROTECTED] wrote:
=Thanks for your response, Rolando. I know all the DML to create the
=database is in the mysqldump. I was looking for a command or command
=options, if there are any, to extract the DML for the database, like what
=you can do with mysqlbinlog.
=
=
Is it possible to use user variables in an update statement, I can find only
scant docs on it, but they do not pertain to what I am trying to do.
Given this select:
SELECT user_id, order_status, quantity_chosen, month_price, each_price,
sales_tax, sales_tax_rate,
@NEW_each_price:=(each_price +
On 7/10/07, Octavian Rasnita [EMAIL PROTECTED] wrote:
I have exported a database using mysqldump from MySQL 5.0.27, and I have
tried importing it in a MySQL 5.0.41, but it gives the following error:
ERROR 1071 (42000) at line 483: Specified key was too long; max key length
is 1000 bytes
Hi Scott,
Scott Haneda wrote:
Is it possible to use user variables in an update statement, I can find only
scant docs on it, but they do not pertain to what I am trying to do.
Given this select:
SELECT user_id, order_status, quantity_chosen, month_price, each_price,
sales_tax, sales_tax_rate,
No.
Transactions involve only one machine.
Furthermore, writing to the master and then reading from a slave runs the
risk of replication delays. Granted, delays are usually sub-second, but if
something big goes thru replication, it can get behind. Your application
should understand the delay
hey all. Let me throw out a quick question. We are upgrading from some version
of 4.1 to the latest version of 5.0. MySQL recommends that you dump and
re-import data with this type of move. Not only do they recommend the
dump/import - it would be nice to optimize all our tables at the same
#!/usr/bin/perl
#dump all files
@db=`mysql -e -ppassword show databases | sed s/-//g | sed s/
//g`;
foreach $db(@db){
chomp($db);
`mysqldump $db -ppassword $db.sql`;
}
#multiple files will load simultaneously. multiple processes should run
much faster
foreach $db(@db){
A quick script solution:
create a dump pr. table in db.
#!/bin/bash
for tbl in `echo use db;show tables;|mysql -s -u user -ppassword`
do
mysqldump -u user ppassword db $tbl $tbl.sql
done
and the other way:
cat tbl.sql| mysql -u user -ppassword db
On Tue, July 10, 2007 15:47, Rolando
How do I view and backup my procedural code?
In oracle it would be something like
Select text from user_source where name='MY_PROCEDURE' order by line;
I did mysqldump, and didn't see any of the functions or procedures
created.
In Oracle they'd be backed up either via RMAN or EXP.
Thanks,
In the last episode (Jul 10), Andrey Dmitriev said:
How do I view and backup my procedural code?
In oracle it would be something like
Select text from user_source where name='MY_PROCEDURE' order by line;
I did mysqldump, and didn't see any of the functions or procedures
created.
In
Hi All,
We have an application where we load data on a daily basis and then do some
analysis and the move this data into different tables.
Data is comming in files. The date format in the file is dd-mon-
hh24:mi:ss', but as you all know, in mysql , the default date format is
-mm-dd
22 matches
Mail list logo