- Original Message -
From: Antonio Fernández Pérez antoniofernan...@fabergames.com
Subject: Doubt with stored procedures
I have a doubt with stored procedures functionality. Is possible that
a stored procedure works with all databases form the server? I have
created a stored
2013/04/17 14:16 +0200, Antonio Fernández Pérez
I have a doubt with stored procedures functionality. Is possible that a
stored procedure works with all databases form the server? I have created a
stored procedure on dataBaseA and also works with dataBaseB. Is that
correct? Independently of the
Hi everybody,
Firstly thanks for your reply.
I'm using MySQL only in one server (I have only one), without replication
and without cluster configuration. I have defined the stored procedure as a
normal user, not as a root. And the call is make as a normal user also.
Occurs with MySQL 5.1.49 on
Sounds like you're missing the following in your my.cnf on server B (probably
all of them):
replicate-same-server-id = 0
log-slave-updates
While you're checking, might as well as make sure your auto-increment settings
are in there and correct also.
-Original Message-
From: Adarsh
: Adarsh Sharma [mailto:eddy.ada...@gmail.com]
Sent: Monday, September 24, 2012 10:39 AM
To: Stillman, Benjamin
Subject: Re: Doubt Regd. Circular Replication In Mysql
Yes I fixed , but i solve the issue by enabling log-slave-updates only
Why we use the below parameter :-
replicate-same-server-id = 0
Hello Benjamin,
On 9/24/2012 10:52 AM, Stillman, Benjamin wrote:
replicate-same-server-id = 0 keeps MySQL from replicating binary log entries
from itself. For instance, here's a rough overview:
You write to Server A.
Server A writes that to its binary log.
Server B reads Server A's binary log
I stand corrected and apologize. Numerous multi-master setup descriptions I've
read have said to set this (including the one linked in the original question).
However, as you said, the entry in the manual clearly says it defaults to 0.
Learn something new every day. Thanks Shawn.
On Sep 24,
24, 2012 11:56 AM
To: Shawn Green
Cc: mysql@lists.mysql.com
Subject: Re: Doubt Regd. Circular Replication In Mysql
I stand corrected and apologize. Numerous multi-master setup
descriptions I've read have said to set this (including the one linked
in the original question). However, as you
on your hands to
fix the broken replication.
-Original Message-
From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
Sent: Monday, September 24, 2012 11:56 AM
To: Shawn Green
Cc: mysql@lists.mysql.com
Subject: Re: Doubt Regd. Circular Replication In Mysql
I stand
Hello, comments inline. Regards, Karen.
I checked up in the mean time, and it does not make a truly consistent backup
of MyISAM - it locks all tables - yes, ALL tables - and then copies the
files. Given that MyISAM doesn't support transactions, that means that any
transactions (that
- Original Message -
From: Karen Abgarian a...@apple.com
This however means that the resulting snapshot will be consistent.
The fact of taking a backup really cannot create more consistency
than what the application has by design. If the application inserts
related rows in say two
Hi! Inline, again.
On Jun 9, 2011, at 4:58 AM, Johan De Meersman wrote:
True, but I have never seen an application that checks for inconsistency in
it's tables. Making sure all users have stopped using the app ensures no
in-flight transactions, and then you have a consistent database -
snip
A single table is always consistent. Data inconsistency occurs in sets of
interrelated tables, in other words, on the database level.
[JS] Not even a single table is always consistent (unless there is
transactions). Consider a single transaction that consists of two steps:
1. Delete
On Thu, June 9, 2011 11:59, Jerry Schwartz wrote:
snip
A single table is
always consistent. Data inconsistency occurs in sets of
interrelated tables, in other words, on the database level.
[JS] Not even a single table is always consistent
(unless there is
transactions). Consider a single
Hi Adarsh,
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
There is also a commercial alternative, InnoBackup, but I imagine you like
it free.
Cheers
Claudio
On Jun 7, 2011 7:59 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote:
Dear all,
Is
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
Dear all,
Is it possible to take backups of a table or complete database without
stopping the application that continuously inserts and select data from the
Hi
We use the --single-transaction switch thinking it does less locking or waiting
for a required table lock. You then get a snapshot without stopping.
Subject should have included the word 'hot'? Looking forward to other
suggestions.
Mark
On 2011/06/07 08:00, Adarsh Sharma wrote:
Dear all,
Both MYISAM Innodb Engines are used.
Thanks
Nilnandan Joshi wrote:
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma
adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote:
Dear all,
Is it possible to take backups of a
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
consistent backups of MyISAM tables? I
Johan De Meersman wrote:
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
Not getting U'r point marked as bold Underline
I checked up in the mean time, and it does not make a truly consistent backup
of MyISAM - it locks all tables - yes, ALL tables - and then copies the files.
Given that
The only case in which you recover automatically the disk space is with
MyISAM tables,
In case of other storage engines is depending on the specific engine.
And the only guaranteed way to have new optimized tables is *full* dump and
reload.
Rolando link is good.
Cheers
Claudio
2011/2/11
Do you have innodb_file_per_table turned on ???
If this is off, then all your InnoDB data is going in /var/lib/mysql/ibdata1
You actually need to the following to recover all free space from all InnoDB
tables
I commented on this in
Hello
the process of the restore is painful.
i see
even in windows, i dont know why made the backup in that way,
(i dindt change any option to make the backup in the mysql administrator)
if you say that the restore would be painful
thank for your time
Moon's Father wrote:
If you skip
Use --skip-extended-insert as another mysqldump option
-Original Message-
From: dr_pompeii [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2008 2:43 PM
To: mysql@lists.mysql.com
Subject: doubt: mysqldump in linux like windows
Hello guys
i have this situation
in widnows with the
Hi Rolando
thanks for the reply
it works, thanks,
new command used
mysqldump --opt --skip-extended-insert --password=XXX --user=root somedb
/home/Someuser/somepath/A.sql
but i see one difference
from windows
/*!4 ALTER TABLE `articulo` DISABLE KEYS */;
INSERT INTO `articulo`
If you skip the extend insert during mysqldump ,the process of the restore
is painful.
On Fri, Mar 21, 2008 at 5:05 AM, dr_pompeii [EMAIL PROTECTED] wrote:
Hi Rolando
thanks for the reply
it works, thanks,
new command used
mysqldump --opt --skip-extended-insert --password=XXX
Hi Ricardo,
Ricardo Conrado Serafim wrote:
Hi Group!
I've a doubt about indexes and I hope that you can help me.
If I've a table index with 5 columns (col_1,col_2,col_3,col_4,col_5) and
I do a query where the clause where use just col_1, col_2, col_4 and
col_5.
This query will use the
Ratheesh K J wrote:
Hello all,
I have a doubt on Index Merge.
We are currently using MySQL server 4.1.11. As a part of DB management I am
currently doing an analysis on all the Tables.
While looking into the table structures, their columns and Indexes I found that
most of the tables have
Eric,
Can you send us the actual show indexes from table and explain output that
isn't shortend?
Thank you for answer my question.
Actually, the real query and tables are much more complex than
the data in the previous message.
A just tryed to optimize the information for you better
Can you send us the actual show indexes from table and explain output
that isn't shortend?
Ronan Lucio wrote:
Hello,
I´m using MySQL-4.1.7, and I have a query that seems,
even using where clause, an specific table isn´t being optimized
properly:
I have four tables:
real_state: cod, name,
Ashok Kumar wrote:
Hi friends,
I'm now started to using the Redhat-Linux. Now i want
to start MySQL on Linux. I'm not having much idea
about Linux. I'm new to this. For Linux which MySQL
installation i've to choose from the site. there are
lot of binary distributions, i don't which one is
Shawn,
Thank you very much for your tips.
I´ll do that.
Ronan
- Original Message -
From: [EMAIL PROTECTED]
To: Ronan Lucio [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, January 18, 2005 6:36 PM
Subject: Re: Doubt about Performance
Ronan Lucio [EMAIL PROTECTED] wrote on 01
Greg,
Thank you very much for your help.
An index the full size of the distinct key is probably very quick
especially
if it only has 20 distinct values. OTOH, if you already know you have a
small number of distinct values, could you just store them normalized in a
different table?
Ronan Lucio wrote:
Hello,
Trying to keep the database and the application fast,
I´d like to clearify my mind about it.
Ronan:
I assume you mean has serious performance impact when you say weight. If
this is not what you meant, please correct/clarify.
1) Is a SELECT DISTINCT over 5,000 records a
Ronan Lucio [EMAIL PROTECTED] wrote on 01/18/2005 01:13:10 PM:
Hello,
Trying to keep the database and the application fast,
I´d like to clearify my mind about it.
1) Is a SELECT DISTINCT over 5,000 records a weight
query? (Supposing it has about 20 different option the the
Sasha,
I assume you mean has serious performance impact when you say weight.
If
this is not what you meant, please correct/clarify.
Yes, you´re right.
1) Is a SELECT DISTINCT over 5,000 records a weight
query? (Supposing it has about 20 different option the the
DISTINCT key).
Ronan Lucio [EMAIL PROTECTED] wrote on 01/18/2005 02:53:39 PM:
Shawn,
Your tips are realy good but I can´t use cache neither for
queries nor for pages because our site serves hundreds of
clients, each one with your own code make a different
query, returning different rows.
It would be
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 18, 2005 10:13 AM
To: mysql@lists.mysql.com
Subject: Doubt about Performance
Hello,
Trying to keep the database and the application fast, I´d
like to clearify my mind about it.
1)
On 27-Apr-2004 Paul DuBois wrote:
At 13:29 -0400 4/27/04, Keith C. Ivey wrote:
On 27 Apr 2004 at 13:59, Ronan Lucio wrote:
OK, I understood it, but I didn´t understand why is there an
option
TINYINT(n)
See http://dev.mysql.com/doc/mysql/en/Numeric_types.html
| Another extension is
At 11:53 -0300 4/27/04, Ronan Lucio wrote:
Hi,
If I create a column with the type TINYINT(2) UNSIGNED.
Will the content can have the value minor than 510 (like a number 499),
or will the content can have two values minor than 255 (like 11)?
I don't know what minor than means, but TINYINT is a
Paul,
I don't know what minor than means
Sorry by my english.
I´d like to say less than (or something like this).
, but TINYINT is a single-byte
type. The range for TINYINT is -128 to 127, and the range for
TINYTINT UNSIGNED in 0 to 255.
OK, I understood it, but I didn´t understand why is
On 27 Apr 2004 at 13:59, Ronan Lucio wrote:
OK, I understood it, but I didn´t understand why is there an option
TINYINT(n)
See http://dev.mysql.com/doc/mysql/en/Numeric_types.html
| Another extension is supported by MySQL for optionally
| specifying the display width of an integer value
At 13:29 -0400 4/27/04, Keith C. Ivey wrote:
On 27 Apr 2004 at 13:59, Ronan Lucio wrote:
OK, I understood it, but I didn´t understand why is there an option
TINYINT(n)
See http://dev.mysql.com/doc/mysql/en/Numeric_types.html
| Another extension is supported by MySQL for optionally
|
On Friday 21 March 2003 08:01, sivakumar wrote:
Hai, am having the problem in creating CD of my project(Online
Tutorial).While creating the CD only am having the problem. Actually am
working in SSH(linux),right.
I have to make a dump of my source code and mysql ..to copy (from server to
C:\
How are you dumping the database? It doesn't seem like you should have
problems going either direction, especially to a case-insensitive
filesystem.
Copying databases with something like
$ mysqldump database | mysql -hremote_server database
works for me, even if it is fairly slow.
-jeff
There are a few options here.
First off, when making the query, just put the NOW() statement into the
tableit's only a few extra keys to type, and it really isn't that
difficult.
The second option is using the TIMESTAMP type...take a look, it's probably
what your looking for :)
-
At 8:33 AM +0530 5/3/01, Sreevatsava Varada wrote:
Hi,
I've recently moved from MS-SQL Server 7.0 to mySQL. In MSSQL I
used to give the default value 'GetDate()' for a field in the
database with the datetime datatype. In mySQL I tried using Now().
But when I insert a new row the datetime
I've recently moved from MS-SQL Server 7.0 to mySQL. In MSSQL I
used to give the default value 'GetDate()' for a field in the
database with the datetime datatype. In mySQL I tried using Now().
But when I insert a new row the datetime field is taking :00:00
00:00:00 value. Please
subba reddy pidugu writes:
Hi !
We have small doub't regarding your software,
We are using WindowsNT operating system we are installed Mysql database after that.
we want how to create a databasae and create a user and how to set the password
specified user. please give answar as
At 10:50 27/02/2001 +, gopinath rajagopal n wrote:
Hi!
First you need to set the privileges rights on the MySQL server for
the NT machine, user and db's. Read the GRANT/REVOKE commands and
How works the privileges system in the MySQL Manual.
To connect you have several ways:
- A telnet
51 matches
Mail list logo