- On May 20, 2016, at 8:38 PM, Bernd Lentes
bernd.len...@helmholtz-muenchen.de wrote:
> Hi,
>
> i'm currently creating a replication and got in contact with the binlog. I use
> row-based logging. I read already the doc but i still have some questions.
> Maybe you can help me.
>
> An excer
Hi,
i'm currently creating a replication and got in contact with the binlog. I use
row-based logging. I read already the doc but i still have some questions.
Maybe you can help me.
An excerp from a relay-log:
# at 329
#160520 17:00:01 server id 1 end_log_pos 259 Query thread_id=94
exec
- Am 1. Apr 2016 um 21:56 schrieb shawn l.green shawn.l.gr...@oracle.com:
> Correct. MyISAM is not a transactional storage engine. It has no concept
> of COMMIT or ROLLBACK. Changes to it are controlled by a full table lock
> and as soon as the change is complete, the table is unlocked and is
- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:
>> Is the mix of MyISAM and InnoDB a problem with Row-Based-Logging or
>> with Statement-Based-Logging or with both ?
>>
>>
>
> Both.
>
>
>>
>> I don't understand the example:
>> Does "begin transaction" and "COMMIT"
Sorry for pm !
- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:
>>> You would be better served by first converting your MyISAM tables to
>>> InnoDB to stop mixing storage engine behaviors (transactional and
>>> non-transactional) within the scope of a single transacti
- Am 1. Apr 2016 um 17:52 schrieb shawn l.green shawn.l.gr...@oracle.com:
>> What is true ? when the transaction started or when the first read is
>> performed ?
> Until you need to establish a snapshot of the data, then you don't need
> a snapshot position.
>
> The transaction physically
- On Apr 1, 2016, at 3:12 PM, Bernd Lentes
bernd.len...@helmholtz-muenchen.de wrote:
Btw:
i read about isolation levels. REPEATABLE READ is the default for InnoDB.
http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:
"...so that all queries within a transaction s
- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
> "Unsafe" in that sense replies to the fact that certain commands can
> have a different effect when processed from the Binary Log than they did
> when they were executed originally on the system that wrote the Bina
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
>> So i should use the default (autocommit=1)?
>
> no, you should what is appropriate for your application
>
> if you don't care about inserts/updates triggered by let say a
> webrequest are half written due a crash
- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
>>
>> I read that the converting is not difficult. But has the code of our webapp
>> to
>> be changed ? It's written in php and perl.
>> What i understand is that inserts/updates/deletions in InnoDB tables have to
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
> Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
>>> You would be better served by first converting your MyISAM tables to
>>> InnoDB to stop mixing storage engine behaviors (transactional and
- Am 25. Mrz 2016 um 21:54 schrieb shawn l.green shawn.l.gr...@oracle.com:
> Hello Bernd,
>
> Sorry for the delay, I wanted to make sure I had enough time to address
> all of your points.
>> He proposed to have two hosts, and on each is running a MySQL instance
>> as master AND slave. But
- On Mar 23, 2016, at 11:11 AM, william drescher will...@techservsys.com
wrote:
>>
>> Hi William,
>>
>> thanks for the try. Good idea !
>> Did you change anything ?
>>
>>
>> Bernd
>
> Yes, in the original document there were some characters that
> were put on the screen as asian pictograph
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
> sent for Bernd, and to see if it works from another sender
> --
> Lentes, Bernd wrote:
> Hi,
>
> i know that there is a list dedicated to rep
- On Mar 19, 2016, at 3:28 PM, Reindl Harald h.rei...@thelounge.net wrote:
> Am 19.03.2016 um 15:23 schrieb Reindl Harald:
>>
>>
>> Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
>>> one further question:
>>> if some of my e-mails get through (like this
Dear list admin,
i need your help. I'm trying to write an e-Mail to the list for already one
week. I always get it back because it's classified as spam.
The mail is formatted as plain-text, include neither links nor attachments. I
don't understand why it's classified as spam. Neither our domain
Hi,
one further question:
if some of my e-mails get through (like this one) and others don't, it does not
depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail ?
Bernd
Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer Gesundh
- Am 18. Mrz 2016 um 15:34 schrieb Reindl Harald h.rei...@thelounge.net:
> Am 18.03.2016 um 15:25 schrieb Lentes, Bernd:
>>
>> - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be:
>>
>
> as i already told you offlist
> senderscore.com
e: +49 (0)89 3187 1241
fax: +49 (0)89 3187 2294
Wer Visionen hat soll zum Hausarzt gehen
Helmut Schmidt
- Am 9. Mrz 2016 um 12:56 schrieb Reindl Harald h.rei...@thelounge.net:
> Am 09.03.2016 um 11:44 schrieb Lentes, Bernd:
>> i tried yesterday several times to send an e-Mail to
u as spam, that's
> usually caused by something on your side :-)
>
> - Original Message -
>> From: "Chris Knipe"
>> To: "Lentes, Bernd"
>> Cc: "MySql"
>> Sent: Friday, 18 March, 2016 14:46:26
>> Subj
Hi,
i tried yesterday several times to send an e-Mail to this list. E-Mail is
formatted as plain-text, has no links included and no attachment but is
declined as spam. This is what is bounced:
: host lists-mx.mysql.com[137.254.60.71] said: 552 spam
score exceeded threshold (#5.6.1) (in repl
Bernd wrote:
> a password ?
>
> Hi,
>
> this is my system:
>
> mysql> status
> --
> mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1
>
> Connection id: 142883
> Current database: mysql
> Current user: root@localhost
> SSL:
Hi,
this is my system:
mysql> status
--
mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1
Connection id: 142883
Current database: mysql
Current user: root@localhost
SSL:Not in use
Current pager: less
Usin
Hi,
i've been already reading the documentation the whole day, but still confused
and unsure what to do.
We have two databases which are important for our work. So both are stored
hourly. Now I recognized that each database has a mixture of MyISAM- and
InnoDB-tables. A backup of this mix does
Hi,
we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
access one particular table.
Automysqlback 3.0 says: mysqldump: Got error: 1142: SELECT,LOCK TABL command
denied to user 'backup'@'localhost' for table 'cond_instances' when using LOCK
TABLES.
root has these rights
Hi,
I have the problem that i have to backup several databases who include a mix of
InnoDB- and MyISAM-tables.
I'd like to use mysqldump. The manpage proposes different options for MyISAM-
and InnoDB-tables. What is about --single-transaction ? --single-transaction is
recommend for InnoDB-table
Carlos mennens wrote:
>
> Can you guys recommend something for me here? I don't really
> know enough about MySQL 'grant' permissions to determine
> which would work or if the 'backup' user would require high
> level privileges.
>
Hi,
Set the rights of the script file to rwx-- . So only
hello,
i'm new to MySQL, so i have currently some basic questions.
I have a MySQL-Server with 15 users. Every User can create databases. I expect
that the amount of data which has to be backuped will increase constantly. What
i want:
I'd like to have a backup on a regular basis. I think i will
Carsten Pederseb wrote:
>
> First, don't mess around with the grant tables. Many years
> ago, that was indeed the way to control user access, but
> things have progressed since then. How old is that MySQL book?
It's from 2005 and about MySQL-version 5.
>
> Remove the manual edits you have
hello ML,
i'm new to MySQL, so i have a very basic question. I have to install a database
server for about 15 persons. The server is intended for testing and evaluating.
The users should be able to create their own databases and tables. And they
should be able to give grants on their own object
30 matches
Mail list logo