Re: does anyone else have problems sending mails to this list ?

Am 22.03.2016 um 02:05 schrieb Jan Steinman: please refrain from answering when you have no clue how DNS blacklists are working and what about others are talking Well, excuse me! Someone put on their bossy pants this morning! A simple “That’s not what’s going on here” would have been

Re: does anyone else have problems sending mails to this list ?

> please refrain from answering when you have no clue how DNS blacklists are > working and what about others are talking Well, excuse me! Someone put on their bossy pants this morning! A simple “That’s not what’s going on here” would have been much nicer. J -- MySQL General Mailing List

Re: does anyone else have problems sending mails to this list ?

Am 20.03.2016 um 20:22 schrieb Reindl Harald: Am 20.03.2016 um 20:16 schrieb Jan Steinman: From: Reindl Harald Date: 17 March 2016 at 06:27:22 PDT Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new

Re: does anyone else have problems sending mails to this list ?

Am 20.03.2016 um 20:16 schrieb Jan Steinman: From: Reindl Harald Date: 17 March 2016 at 06:27:22 PDT Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed

Re: does anyone else have problems sending mails to this list ?

> From: Reindl Harald > Date: 17 March 2016 at 06:27:22 PDT > > Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: >> i still can't send my question to the ML. Our outgoing Mailer has a new IP >> which is not listed >>

Re: does anyone else have problems sending mails to this list ?

Hi, i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed (http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#), our domain is not listed

Re: does anyone else have problems sending mails to this list ?

Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed (http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#), our domain is not listed

Re: does anyone else have problems sending mails to this list ?

Am 09.03.2016 um 11:44 schrieb Lentes, Bernd: 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

Re: does anyone else have problems sending mails to this list ?

Bernd, > : host lists-mx.mysql.com[137.254.60.71] said: 552 spam > score exceeded threshold (#5.6.1) (in reply to end of DATA command) > > Any ideas ? Whatever provider you are using to send mail has been blacklisted? It happens with some ISP who are not diligent

does anyone else have problems sending mails to this list ?

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

FW: MySQL Problems

Hi, We are running on opensuse that defaults to a mariadb instead of mysql install, so we were running icinga 1.9.2 / idoutils 1.9.2 on a opensuse ppc system, with mariadb 5.5.33. This generated a lot of errors in de database (with restarts): InnoDB: Assertion failure in thread

RE: Concurrent read performance problems

[mailto:vegiv...@tuxera.be] Sent: Sunday, August 11, 2013 2:16 PM To: Brad Heller Cc: Johnny Withers; MySQL General List Subject: Re: Concurrent read performance problems Good to hear. A word of warning, though: make sure you don't have more connections allocating those buffers than your machine can

Re: Concurrent read performance problems

On my phone now, but it smells of file-based sorting, making disk access the bottleneck. Can you provide the explain? Brad Heller b...@cloudability.com wrote: Hey list, first time posting here so apologies if this is the wrong forum for this but I'm really out of options on how to solve this

Re: Concurrent read performance problems

Yes sorry, here's the explain. It was taken from MariaDB 5.5.32. Looks like there is a lot of filesort goin' on here. Also note that I'm only using the first two fields of the covering index (intentionally).

Re: Concurrent read performance problems

Just because it says filrsort doesn't mean it'll create a file on disk. Table schema and full query would be helpful here too http://www.mysqlperformanceblog.com/2009/03/05/what-does-using-filesort-mean-in-mysql/ On Aug 11, 2013 1:28 PM, Brad Heller b...@cloudability.com wrote: Yes sorry,

Re: Concurrent read performance problems

True, which is why I said I suspected file-based sort :-) At one million rows, that seems to be an accurate guess, too. Still on the phone, though, and in bed. I'll read the thread better tomorrow, but you might get some benefit from cutting out the subselect if that's possible. If you have

Re: Concurrent read performance problems

Johan, your suggestion to tweak max_heap_table_size and tmp_table_size fixed the issue. Bumping them both to 512MB got our performance back on-par. I came up with a way to avoid the contention using a complex set of temp tables, but performance was abysmal. By reverting to the more

Re: Concurrent read performance problems

Good to hear. A word of warning, though: make sure you don't have more connections allocating those buffers than your machine can handle memory-wise, or you'll start swapping and performance will REALLY go down the drain. A query/index based solution would still be preferred. Could you for

Concurrent read performance problems

Hey list, first time posting here so apologies if this is the wrong forum for this but I'm really out of options on how to solve this problem! *Short version:* 1. High concurrent reads, performing the same well-indexed query type to the same two tables. 2. No additional traffic at all--just

Re: problems with relationships created by mysql

oops..sorryproblem seems to be with base...so i meant to post it in base mailing list On Mon, May 13, 2013 at 9:37 AM, rounak jain rounak.m...@gmail.com wrote: I have connected MySql to Base. I created some relationships in MySql. They are properly visible in the Relationships chart in

Problems compiling 5.6.10 under CygWIN for Windows

I'm using CygWIN to compile MySQL 5.6.10 for Windows. Using the source code (Generic Linux (Architecture Independent), Compressed TAR Archive) Version 5.6.10. I have no problems compiling (Generic Linux (Architecture Independent), Compressed TAR Archive) Version 5.5.29 source code

problems with mysql and php after system software upgrade

During a recent system software upgrade (CentOS) on the front-end of our computing cluster, the mysql area was upgraded without our realizing that it was going to be. Now, php and mysql do not communicate well with one another. The version of mysql on the system after the upgrade is 5.1.61.

RE: problems with INNODB tables

: problems with INNODB tables Thanks for your answer. I read http://mysql.rjweb.org/doc.php/memory where it tells you to do one thing if using MYIASM tables and another if using INNODB tables. We are using both. Any suggestions? Thanks for any help. Malki Cymbalista Webmaster, Weizmann Institute

RE: problems with INNODB tables

...@weizmann.ac.il 08-9343036 -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Monday, April 23, 2012 9:42 PM To: Andrés Tello; Malka Cymbalista Cc: mysql@lists.mysql.com; Shlomit Afgin; Ronen Hayun Subject: RE: problems with INNODB tables Check your memory usage

Re: problems with INNODB tables

Cymbalista Cc: mysql@lists.mysql.com; Shlomit Afgin; Ronen Hayun Subject: RE: problems with INNODB tables Check your memory usage according to http://mysql.rjweb.org/doc.php/memory -Original Message- From: Andrés Tello [mailto:mr.crip...@gmail.com] Sent: Monday, April 23, 2012 9:00

Re: problems with INNODB tables

fine. Each time On Mon, Apr 23, 2012 at 9:10 AM, Malka Cymbalista malki.cymbali...@weizmann.ac.il wrote: We are running MySQL version 5.0.45 on a Linux machine. Over the past few months we have been having several problems: 1. Our mysql processes have increased the memory used from about

RE: problems with INNODB tables

Check your memory usage according to http://mysql.rjweb.org/doc.php/memory -Original Message- From: Andrés Tello [mailto:mr.crip...@gmail.com] Sent: Monday, April 23, 2012 9:00 AM To: Malka Cymbalista Cc: mysql@lists.mysql.com; Shlomit Afgin; Ronen Hayun Subject: Re: problems

Re: Problems Connecting with SSL

of which are generally accessible from remote clients over SSL. However, one of my FreeBSD mySQL clients is having problems connecting to any of the servers. Running mySQL under truss reports the following: Looking at this output tells something went terribly wrong: file descriptor 2

Re: Problems Connecting with SSL

Sorry, but I have to start with a negative remark: Why, oh why, don't you mention the version number you are using? I hope it is some roughly current 5.1, but I'd rather like you to tell it. Doh! Right you are! Sorry, that was totally my bad. mysql select version(); ++ |

Re: Problems Connecting with SSL

Interesting that you can request advice from finland vs calling from redwood shores CA for technical advice first take a look at: http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html once you've determined the algorithm you will want to implement take a look at SSL 1,2,3 and TLS

Re: Problems Connecting with SSL

perhaps a misconfiguration on the failing client .. can you go to successful client, enable DEBUG level debugging and log the connection and then go to the failing client..enable DEBUG level debugging and log the connection to the failing client this would determine deltas between the

Re: Problems Connecting with SSL

Hi! Martin Gainty wrote: [[...]] joerg ..any thoughts on this matter?? Sorry - none. I never dealt with the inner workings of the SSL library. Just seeing file descriptor 2 (standard error) used for socket operations makes me assume *very* strongly that something went wrong well before

Problems Connecting with SSL

I have three mySQL server, all of which are SSL-enable and all of which are generally accessible from remote clients over SSL. However, one of my FreeBSD mySQL clients is having problems connecting to any of the servers. Running mySQL under truss reports the following

Problems storing a blob using php.

Debian squeeze, mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using readline 6.1, PHP 5.3.3-2 with Suhosin-Patch (cli) (built: Oct 21 2010 18:58:27). I'm not sure if this group or the php one is more appropriate but thought I would try here first as it is perhaps a mysql setting I

Re: Performance problems on MySQL

Hi, We're chaning it to INT(9). Apparently someone remembered to change the type of data in this field from an alphanumeric value to an INT(9). I'm going to change this asap. Thanks BR AJ On Mon, Sep 6, 2010 at 5:17 AM, mos mo...@fastmail.fm wrote: At 04:44 AM 9/3/2010, Alexandre Vieira

Re: Performance problems on MySQL

Hi List, In a 20m interval in our max load I have: OS WAIT ARRAY INFO: reservation count 637, signal count 625 Mutex spin waits 0, rounds 19457, OS waits 428 RW-shared spins 238, OS waits 119; RW-excl spins 13, OS waits 8 (The values are the difference between the start and end of this 20m

Re: Performance problems on MySQL

On 9/3/2010 3:15 PM, Johnny Withers wrote: It seems that when your index is PRIMARY on InnoDB tables, it's magic and is part of the data thereby it is not included in the index_length field. I have never noticed this. I don't think adding a new index will make a difference. You could try

Re: Performance problems on MySQL

At 04:44 AM 9/3/2010, Alexandre Vieira wrote: Hi Johnny, mysql EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694'; ++-++---+---+-+-+---+--+---+ | id | select_type | table | type | possible_keys | key |

Re: Performance problems on MySQL

Hi Johnny, mysql EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694'; ++-++---+---+-+-+---+--+---+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

Re: Performance problems on MySQL

On 02/09/2010 6:05 p, Alexandre Vieira wrote: Hi Jangita, I'm 15779 innodb_buffer_pool_pages_free from a total of 22400. That's 246MB of 350MB free. | Innodb_buffer_pool_pages_data | 6020 | | Innodb_buffer_pool_pages_dirty| 1837 | | Innodb_buffer_pool_pages_flushed |

Re: Performance problems on MySQL

Ok, so I'm stumped? What kind of hardware is behind this thing? -JW On Fri, Sep 3, 2010 at 4:44 AM, Alexandre Vieira nul...@gmail.com wrote: Hi Johnny, mysql EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';

Re: Performance problems on MySQL

, doesn't follow any specific pattern. All working concurrently. A big bottleneck is: 8 queries inside InnoDB, 28 queries in queue 1 read views open inside InnoDB Increasing innodb_thread_concurrency might help without causing any problems to the overall performance. Makes total sense if you read

Re: Performance problems on MySQL

1 read views open inside InnoDB Increasing innodb_thread_concurrency might help without causing any problems to the overall performance. Makes total sense if you read: http://peter-zaitsev.livejournal.com/9138.html Thanks in advance. BR AJ On Fri, Sep 3, 2010 at 2:31 PM, Johnny Withers

Re: Performance problems on MySQL

in queue 1 read views open inside InnoDB Increasing innodb_thread_concurrency might help without causing any problems to the overall performance. Makes total sense if you read: http://peter-zaitsev.livejournal.com/9138.html Thanks in advance. BR AJ On Fri, Sep 3, 2010 at 2:31 PM

Re: Performance problems on MySQL

of inserts and deletes. Data manipulation is random, doesn't follow any specific pattern. All working concurrently. A big bottleneck is: 8 queries inside InnoDB, 28 queries in queue 1 read views open inside InnoDB Increasing innodb_thread_concurrency might help without causing any problems

Re: Performance problems on MySQL

manipulation is random, doesn't follow any specific pattern. All working concurrently. A big bottleneck is: 8 queries inside InnoDB, 28 queries in queue 1 read views open inside InnoDB Increasing innodb_thread_concurrency might help without causing any problems to the overall performance

Re: Performance problems on MySQL

causing any problems to the overall performance. Makes total sense if you read: http://peter-zaitsev.livejournal.com/9138.html Thanks in advance. BR AJ On Fri, Sep 3, 2010 at 2:31 PM, Johnny Withers joh...@pixelated.netwrote: Ok, so I'm stumped? What kind of hardware is behind

Re: Performance problems on MySQL

causing any problems to the overall performance. Makes total sense if you read: http://peter-zaitsev.livejournal.com/9138.html Thanks in advance. BR AJ On Fri, Sep 3, 2010 at 2:31 PM, Johnny Withers joh...@pixelated.netwrote: Ok, so I'm stumped? What kind of hardware is behind

Re: Performance problems on MySQL

It seems that when your index is PRIMARY on InnoDB tables, it's magic and is part of the data thereby it is not included in the index_length field. I have never noticed this. I don't think adding a new index will make a difference. You could try moving your log files to a different disk array

Performance problems on MySQL

Hi list, I'm having some performance problems on my 5.0.45-log DB running on Solaris 8 (V240). We only have one table and two apps selecting, updating, inserting and deleting massively and randomly from this table. The table is very simple. All SELECTs,INSERTs,UPDATEs and DELETEs have only one

Re: Performance problems on MySQL

Can you show us the table structure and sample queries? On Thursday, September 2, 2010, Alexandre Vieira nul...@gmail.com wrote: Hi list, I'm having some performance problems on my 5.0.45-log DB running on Solaris 8 (V240). We only have one table and two apps selecting, updating, inserting

Re: Performance problems on MySQL

What is the hardware spec? Anything else running on the box? Why are you replicating but not making use of the slave? Can you post the output of SHOW CREATE TABLE? Regards John On 2 September 2010 12:50, Alexandre Vieira nul...@gmail.com wrote: Hi list, I'm having some performance problems

Performance problems on MySQL

John, Johnny, Thanks for the prompt answer. mysql SHOW CREATE TABLE clientinfo;

Re: Performance problems on MySQL

On 02/09/2010 4:46 p, Alexandre Vieira wrote: John, Johnny, Thanks for the prompt answer. ... We also run some other applications in the server, but nothing that consumes all the CPU/Memory. The machine has almost 1GB of free memory and 50% of idle CPU time at any time. TIA BR Alex

Re: Performance problems on MySQL

Hi Jangita, I'm 15779 innodb_buffer_pool_pages_free from a total of 22400. That's 246MB of 350MB free. | Innodb_buffer_pool_pages_data | 6020 | | Innodb_buffer_pool_pages_dirty| 1837 | | Innodb_buffer_pool_pages_flushed | 673837 | | Innodb_buffer_pool_pages_free |

RE: Performance problems on MySQL

Cc: mysql@lists.mysql.com Subject: Performance problems on MySQL John, Johnny, Thanks for the prompt answer. mysql SHOW CREATE TABLE clientinfo

Re: Performance problems on MySQL

for your delete queries? DELETE FROM clientinfo WHERE units='155618918'; -Original Message- From: Alexandre Vieira [mailto:nul...@gmail.com] Sent: Thursday, September 02, 2010 8:46 AM To: John Daisley; joh...@pixelated.net Cc: mysql@lists.mysql.com Subject: Performance problems on MySQL

collation problems

Hi listers mysql server here is mysql-server-5.1.48-2.fc13.x86_64 this morning i created a message with a literal string in chinese in it. the messages in the application i used are stored in a mysql database, when you submit them, like in a sent folder. With this chinese literal in it, i,

Re: collation problems

can u please list out the table structure...as collation can also be set at column level regards anandkl On Tue, Aug 31, 2010 at 6:00 PM, mysql my...@ayni.com wrote: Hi listers mysql server here is mysql-server-5.1.48-2.fc13.x86_64 this morning i created a message with a literal string in

Re: collation problems

Hi Ananda table structure is: mysql show full columns from suomi_contacts2; +--+--+---+--+-+---+-+-+-+ | Field| Type | Collation

Re: collation problems

can u please give the output of desc suomi_contacts2; 2010/8/31 mysql my...@ayni.com Hi Ananda table structure is: mysql show full columns from suomi_contacts2;

Re: collation problems

On 2010-08-31 15:17, Ananda Kumar wrote: desc suomi_contacts2; mysql desc suomi_contacts2; +--+--+--+-+---+-+ | Field| Type | Null | Key | Default | Extra |

Re: collation problems

did u try changing the collation for history column to UTF8 and try the update. 2010/8/31 mysql my...@ayni.com On 2010-08-31 15:17, Ananda Kumar wrote: desc suomi_contacts2; mysql desc suomi_contacts2;

Re: collation problems

Hi Ananda not sofar. But if you recommend it, i will give it a try. thanks so much. suomi On 2010-08-31 15:41, Ananda Kumar wrote: did u try changing the collation for history column to UTF8 and try the update. 2010/8/31 mysql my...@ayni.com mailto:my...@ayni.com On 2010-08-31 15:17,

[SOLVED] Re: collation problems

Hi Ananda that worked fine: mysql alter table suomi_contacts2 modify history longtext character set utf8 collate utf8_bin; Query OK, 6327 rows affected (0.34 sec) Records: 6327 Duplicates: 0 Warnings: 0 mysql mysql update suomi_contacts2 set history = concat(now(), ' ', '' ,'concerne:

Re: master-slave replication sync problems.

On Thu, Aug 26, 2010 at 6:04 AM, Norman Khine nor...@khine.net wrote: hello, i have a working master-slave replication, the problem i find is that if i restart the MASTER there is a difference in the MASTER_LOG_FILE and MASTER_LOG_POS on the SLAVE. what is the correct way to keep the two

master-slave replication sync problems.

hello, i have a working master-slave replication, the problem i find is that if i restart the MASTER there is a difference in the MASTER_LOG_FILE and MASTER_LOG_POS on the SLAVE. what is the correct way to keep the two slaves in sync even after i restart the server. the way i do it now is to:

Re: master-slave replication sync problems.

since u r starting slave by postion beyond master, and if some of the changes are already present on slave, it would error out with duplicate. You need show slave status\G; slave stop; show slave status\G;..wait for few min..than again show slave status\G;just to make sure...slave is in

Re: master-slave replication sync problems.

That is really bad, you will loose changes. You shouldnt have to do anything when rebooting either the master or slave. If the master is down, then the slave recieves no updates. If the slave is down, when it comes back up it checks the master log pos and plays thro any changes that are

Re: master-slave replication sync problems.

True, But some times, this does not work and u need to know the master bin-log file and position to start, so that there is no loss of data. regards anandkl On Thu, Aug 26, 2010 at 6:39 PM, a.sm...@ukgrid.net wrote: That is really bad, you will loose changes. You shouldnt have to do anything

Re: master-slave replication sync problems.

i see, so the best is to just stop slave and then check the master status, and when the master status syncs then i start the slave? On Thu, Aug 26, 2010 at 3:09 PM, a.sm...@ukgrid.net wrote: That is really bad, you will loose changes. You shouldnt have to do anything when rebooting either

Re: master-slave replication sync problems.

Yes, You need to note down the master bin-log file name and position on the slave, this is a must. regards anandkl On Thu, Aug 26, 2010 at 7:34 PM, Norman Khine nor...@khine.net wrote: i see, so the best is to just stop slave and then check the master status, and when the master status

Re: master-slave replication sync problems.

Quoting Norman Khine nor...@khine.net: i see, so the best is to just stop slave and then check the master status, and when the master status syncs then i start the slave? Well Im willing to hear from others experiences, but if you really shouldnt have to do anything. If you want you can

Re: master-slave replication sync problems.

Smith, I never said, this wont work.Some times, there are chances of lossing data. regards anandkl On Thu, Aug 26, 2010 at 8:48 PM, a.sm...@ukgrid.net wrote: Quoting Norman Khine nor...@khine.net: i see, so the best is to just stop slave and then check the master status, and when the

Re: master-slave replication sync problems.

-slave replication sync problems. To: mysql@lists.mysql.com Date: Thursday, 26 August, 2010, 6:34 PM hello, i have a working master-slave replication, the problem i find is that if i restart the MASTER there is a difference in the MASTER_LOG_FILE and MASTER_LOG_POS on the SLAVE. what is the correct

Re: master-slave replication sync problems.

Quoting Ananda Kumar anan...@gmail.com: Smith, I never said, this wont work.Some times, there are chances of lossing data. regards anandkl If you have experience of this fair enough. Theres no reason it should make any difference, as everything is based upon the binlog file and

Re: master-slave replication sync problems.

Quoting jitendra ranjan jitendra_ran...@yahoo.com: Hi,   The best way to use sync the master and slave is using mk-checksum tools. just google it and use the the tools for online sync of master and slave.   Jeetendra Ranjan MySQL DBA Yes, data integrity isnt guaranteed with MySQL

RE: master-slave replication sync problems.

Slave_SQL_Running: Yes -Original Message- From: Norman Khine [mailto:nor...@khine.net] Sent: Thursday, August 26, 2010 6:05 AM To: mysql@lists.mysql.com Subject: master-slave replication sync problems. hello, i have a working master-slave replication, the problem i find

Re: master-slave replication sync problems.

*** Slave_IO_Running: Yes Slave_SQL_Running: Yes -Original Message- From: Norman Khine [mailto:nor...@khine.net] Sent: Thursday, August 26, 2010 6:05 AM To: mysql@lists.mysql.com Subject: master-slave replication sync problems. hello, i have a working

Problems posting to the list lists.mysql.com

Hello, I tried to response to a posting on the list named in the subject. But it is rejected with the following message: SMTP error from remote mail server after end of data: host lists.mysql.com [213.136.52.31]: 552 spam score exceeded threshold (#5.6.1) Neither this emailaddress is

Re: Problems posting to the list lists.mysql.com

At 10:51 AM 2/15/2010, Frank Becker wrote: Hello, I tried to response to a posting on the list named in the subject. But it is rejected with the following message: SMTP error from remote mail server after end of data: host lists.mysql.com [213.136.52.31]: 552 spam score exceeded

Re: Problems posting to the list lists.mysql.com

Is the MySQL mailing list admin subscribed to the list? I have also sent a message or more telling about this issue, with no response. -- Octavian mos mo...@fastmail.fm wrote in message news:6.0.0.22.2.20100215120015.02cd4...@mail.messagingengine.com... At 10:51 AM 2/15/2010, Frank Becker

Problems with slave_skip_errors on replication

Hi friends, Last weekend I made an environment that use a MySQL Server version 4.1 that was defined to be the MASTER and other one version 5.1 defined as SLAVE. Because the application that was concept working over exception, often the SLAVE server got new error and replication stops. Well, I

Re: Problems with slave_skip_errors on replication

Hi Wagner, You have to start the server with the option as below for skipping the error. --slave-skip-errorr= 1062 or all 1062 - will skip the your error as the error number is 1062 and all will skip all the errors. You have to mention specific error numbers to skip the same. -- Thanks

Re: Problems with slave_skip_errors on replication

Ok, Suresh. . .I started MySQL with slave_skip_errors = all and It solve the problem! Thanks. WB 2010/1/25 Suresh Kuna sureshkumar...@gmail.com Hi Wagner, You have to start the server with the option as below for skipping the error. --slave-skip-errorr= 1062 or all 1062 - will skip the

Binary log problems

I tried to look at the binary logs by using phpMyAdmin, but got an error: SQL error: SHOW BINLOG EVENTS LIMIT 0, 30; MySQL said: #1220 - Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O error. From the error-file: 100111 16:15:40 [ERROR] Error in

Problems with auto_increment updating when (i think) it shouldn't

Hey folks. I'm getting some weird behaviour out of Auto_increment. If I enter a attempt to INSERT a row into a table with a UNIQUE index, where the insert would violate uniqueness of existing data, I'm seeing the auto_increment increase even though the insert fails. The server in question is

Re: Problems with auto_increment updating when (i think) it shouldn't

It will also update the auto_increment column when you ROLLBACK a failed insert: mysql USE test; Database changed mysql SELECT * FROM t1\G Empty set (0.00 sec) mysql DROP TABLE t1; Query OK, 0 rows affected (0.06 sec) mysql mysql CREATE TABLE t1( - id INT UNSIGNED NOT NULL AUTO_INCREMENT,

Re: Problems with auto_increment updating when (i think) it shouldn't

Hmm, that makes sense. I should have thought of that. Thanks! On Fri, Aug 7, 2009 at 12:32 PM, Johnny Withersjoh...@pixelated.net wrote: It will also update the auto_increment column when you ROLLBACK a failed insert: mysql USE test; Database changed mysql SELECT * FROM t1\G Empty set

Replication problems: slave fails to update

in the log file. SHOW SLAVE STATUS states no problems. I have attempted changing binlog_format, and have received the same results on all three settings. The Master has no settings to ignore any particular schema. Using the query browser, and running the same exact query with the same user

Re: Problems After MySql 5.1.34 - THANKS

Subject: RE: Problems After MySql 5.1.34 Gary wrote: Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work

Re: Problems After MySql 5.1.34

as it would make my compiling life easier every time I update MySql on all of my boxes. Gary From: Johnny Stork [li...@openenterprise.ca] Sent: Wednesday, May 06, 2009 1:03 PM Cc: mysql@lists.mysql.com Subject: Re: Problems After MySql 5.1.34 Typo

Re: Problems After MySql 5.1.34

Hi Johnny, all! Johnny Stork wrote: Typo, moved from 5.0.67 to 5.1.34 Ok, that helps - I checked the contents. Johnny Stork wrote: I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX

Re: Problems After MySql 5.1.34

older version(s). If you found any problems with this, please tell us! We are considering to change the contents of shared-compat RPMs, so that they would not replace shared any more but just complement it (bring just the old libs, not the current one). The advantage would be that you then can

RE: Problems After MySql 5.1.34

Gary wrote: Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. Well, you don't actually

RE: Problems After MySql 5.1.34

: donderdag 7 mei 2009 15:15 To: ad...@asarian-host.net; mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34 Gary this isnt mysql's fault that php has such abysmal build tools..try requesting a web developer to simply download php and run the proprietary binary tools after a week of sleepless

RE: Problems After MySql 5.1.34

Typically we see the problems with RH/Cent when you upgrade through those channels and then do an install of the 5.1.x series on top of that. I tried it about 9 months ago, so the details are fuzzy. I do know that in attempts to recover we extracted the RPM contents and tried to copy them

RE: Problems After MySql 5.1.34

You are right. I misspoke regarding mysql - php - apache hell. It happens anytime an interface changes. From: Mark [ad...@asarian-host.net] Sent: Thursday, May 07, 2009 5:57 AM To: mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34 Gary

Problems After MySql 5.1.34

I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a pear update produces the errors below. I created a couple of sl but this did not

Re: Problems After MySql 5.1.34

Typo, moved from 5.0.67 to 5.1.34 Johnny Stork wrote: I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a pear update produces the

  1   2   3   4   5   6   7   8   9   10   >