Possible issues with replication filters

2013-03-24 Thread Radoulov, Dimitre
Hi all, we need to move a few databases from one host to another. During the process we need to use replication filters (to replicate only the databases to be moved). The current MySQL version is 5.5, the new one will be 5.6. We're using "mixed" binlog_format. We're planing to use: replicate-wil

Re: Show ROUTINE body, not PROCEDURE

2013-03-24 Thread Peter Brawley
On 2013-03-24 8:25 AM, Dotan Cohen wrote: A MySQL database is using a stored function avg_sales in some SQL queries. I am having a hard time finding the code for this function, in order to track down a bug that I suspect is in the function. Here is what I get when I try to query MySQL for the fun

Re: How to change max simultaneous connection parameter in mysql.

2013-03-24 Thread Manuel Arostegui
2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > > >> 20 may be low, but 100 is rather high. >

Show ROUTINE body, not PROCEDURE

2013-03-24 Thread Dotan Cohen
A MySQL database is using a stored function avg_sales in some SQL queries. I am having a hard time finding the code for this function, in order to track down a bug that I suspect is in the function. Here is what I get when I try to query MySQL for the function code: mysql> SELECT * FROM informatio

Re: How to change max simultaneous connection parameter in mysql.

2013-03-24 Thread Reindl Harald
Am 24.03.2013 05:20, schrieb spameden: > 2013/3/19 Rick James : >>> you never have hosted a large site >> Check my email address before saying that. > > :D as said, big company does not have only geniusses >> 20 may be low, but 100 is rather high. > Never use apache2 it has so many problems un