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 mu
> 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
F
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 IP which is not listed
(
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
(http://mxtoolbox.com/SuperTool.aspx?action=black
> 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
>> (http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20&run=toolpag
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&run=toolpage#),
our domain is not listed
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3ahelmholtz-muenchen.de&run=to
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&run=toolpage#),
our domain is not listed
(http://mxtoolbox.com/SuperTool.aspx?act
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 lists-mx.mysql.com[137.254.60.71] said: 552 spam
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 enough to remove the
spammer
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
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 70366933
ersman [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 al
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 insta
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 straight-forwar
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 ple
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" wrote:
> Yes sorry, here's the explain. It w
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).
+--+-++---+---
On my phone now, but it smells of file-based sorting, making disk access the
bottleneck. Can you provide the explain?
Brad Heller 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 problem!
>
>*Short ver
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 reads
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 wrote:
> I have connected MySql to Base. I created some relationships in MySql.
> They are properly visible in the Relationships chart in Base. See image.
> htt
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.
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. T
n
> Subject: RE: 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.
]
> 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 according to
> http://mysql.rjweb.org/doc.php/memory
>
> > -Original
...@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
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
> Sub
lot, something isn't 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 pr
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 t
> 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
> 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 a
> 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();
++
| ve
le 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:
>
Looking at this output tells something went terribly
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
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
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
inter
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 wrote:
> At 04:44 AM 9/3/2010, Alexandre Vieira wrote:
>
>> Hi Johnn
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 | key_
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 moving
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 tha
t;
>>>>>
>>>>> On Fri, Sep 3, 2010 at 8:59 AM, Alexandre Vieira wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I've done some tests with INT(8) vs the VARCHAR(23) on the userid PK
>>>>>> and
gt;> PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
>>>>> 6229 mysql 455M 179M sleep 580 0:03.11 5,4% mysqld/68
>>>>>
>>>>> The machine has ~1GB of free memory. MySQL and InnoDB has free pages to
>>&
e CPU time.
>>>>
>>>> Currently I can't use the replication server since the application
>>>> running on top if this BD can only talk to 1 data source.
>>>> At the moment it's also not possible to change the application in order
>>&g
n in order
>>> to make it use the DB more wisely.
>>>
>>> Basically we have a table with lots of selects, lots of update, lots of
>>> inserts and deletes. Data manipulation is random, doesn't follow any
>>> specific pattern. All working concurrently.
&
a table with lots of selects, lots of update, lots 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
>&
pecific 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.
>
nipulation 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.
Make
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 wrote:
> Hi Johnny,
>
> mysql> EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
>
> ++-++---+---+-+-+--
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 | 673837
Hi Johnny,
mysql> EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
++-++---+---+-+-+---+--+---+
| id | select_type | table | type | possible_keys | key | key_len
| ref | rows | Extra |
++-
; 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
elated.net
Cc: mysql@lists.mysql.com
Subject: Performance problems on MySQL
John, Johnny,
Thanks for the prompt answer.
mysql> SHOW CREATE TAB
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 | 157
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
Increa
John, Johnny,
Thanks for the prompt answer.
mysql> SHOW CREATE TABLE clientinfo;
++--
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 wrote:
> Hi list,
>
> I'm having some performance problem
Can you show us the table structure and sample queries?
On Thursday, September 2, 2010, Alexandre Vieira 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,
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 onl
On Thu, Aug 26, 2010 at 6:04 AM, Norman Khine 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 slaves in sync
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: u
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 mailto:my...@ayni.com>>
On 2010-08-31 15:17, Ananda Kumar wro
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql
> On 2010-08-31 15:17, Ananda Kumar wrote:
> > desc suomi_contacts2;
>
> mysql> desc suomi_contacts2;
>
> +--+--+--+-+---+
On 2010-08-31 15:17, Ananda Kumar wrote:
> desc suomi_contacts2;
mysql> desc suomi_contacts2;
+--+--+--+-+---+-+
| Field| Type | Null | Key | Default |
Extra
can u please give the output of
desc suomi_contacts2;
2010/8/31 mysql
> Hi Ananda
>
> table structure is:
>
> mysql> show full columns from suomi_contacts2;
>
> +--+--+---+--+-+---+-+-
Hi Ananda
table structure is:
mysql> show full columns from suomi_contacts2;
+--+--+---+--+-+---+-+-+-+
| Field| Type | Collation
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 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 chinese
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,
* 1. row ***
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 proble
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 wor
Quoting jitendra ranjan :
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 replication. So if you
want to b
Quoting Ananda Kumar :
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
position...
--
MySQL
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
--- On Thu, 26/8/10, Norman Khine wrote:
From: Norman Khine
Subject: 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, wrote:
> Quoting Norman Khine :
>
> 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 t
Quoting Norman Khine :
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 issue a stop slav
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 wrote:
> 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
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, wrote:
> That is really bad, you will loose changes.
>
> You shouldnt have to do anything when rebooting either the master or sla
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, wrote:
> That is really bad, you will loose changes.
>
> You shouldnt have to do anything when rebooting
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 nec
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 comple
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:
[MA
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" wrote in message
news:6.0.0.22.2.20100215120015.02cd4...@mail.messagingengine.com...
> At 10:51 AM 2/15/2010, Frank Becker wrote:
>>Hello,
>>
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
thresho
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
Ok, Suresh. . .I started MySQL with slave_skip_errors = all and It solve the
problem!
Thanks.
WB
2010/1/25 Suresh Kuna
> 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
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
Sure
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 co
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 Log_event::read_log_event()
Hmm, that makes sense. I should have thought of that. Thanks!
On Fri, Aug 7, 2009 at 12:32 PM, Johnny Withers 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 (0.00 sec)
> m
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
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 5.1.
ate)
VALUES (1,2,1,1000,null),... ON DUPLICATE KEY UPDATE value=VALUES(value)
Replication is active, and I am able to test it by doing single point
modifications through the query browser.
However, the bulk inserts seem to vanish: The Master updates, but the
slave does not. There are no e
mysql@lists.mysql.com
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 tryin
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
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
.@hotmail.com]
Sent: 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
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
ared-compat" (and not "shared") if
you are using application binaries built against 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&qu
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
se, please do as I would like to be wrong here
> 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
s.
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, moved from 5.0.67 to 5.1.34
Johnny Stork wrote:
> I recently upgraded an asterisk/trixbox server to 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 - 100 of 2898 matches
Mail list logo