Hi Rick,
I thought you have to dedicate 70-80% of available RAM not a total RAM.
Saying if I have 2 gig of RAM on my exclusively innodb box, and I
dedicate 1.4Gig to innodb pool, my 64-bit linux machine will start
swapping heavily.
If I set it to 800-900M, it just fine and I have like 100M of RA
Hi Kevin,
In your MySQL client pls execute:
SET GLOBAL max_connections = 200;
To Make the change permanent you can edit /etc/my.cnf or whatever MySQL
config file you you've got in your system
Look for this line max_connections under [mysqld] secction, add it if
it's not in the config. make sure
Hi,
I think MMM's proper functionality depends a lot on network interface
configuration and sometimes it behaves odd. I moved to MySQL or in my
case to MariaDB + Galera + HaProxy configuration. It's not difficult to
setup. There is no SPO as in case with monitor host in MMM, much more
robust s
You mysql.user table might be corrupted.
If you have access to it as a root user, try check table mysql.user, and
repair table mysql.user if table corruption was detected.
Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your
$datadir/mysql directory) and run
mysqlcheck -r mys
:
replicate-wild-ignore-table=dbname%.watchdog%
replicate-wild-ignore-table=dbname%.cache%
Correct?
Thanks,
Nestor :-)
On Thu, Dec 6, 2012 at 3:07 PM, Igor Shevtsov wrote:
In regards to the second part of your email.
You don't have errors in your mysql.err log. Those are notes saying that
y
In regards to the second part of your email.
You don't have errors in your mysql.err log. Those are notes saying that
you started IO and SQL replication threads after you skipped an
replication error and run start slave command.
I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command ei
Hi Néstor,
You might want to put those lines into your my.cnf under replication
section and restart the slave:
replicate-wild-ignore-table=dbname%.watchdog%
and may be this as well:
replicate-wild-ignore-table=dbname%.cache%
Do you really need to replicate cache and session tables?
Cheers,
Ig
Hi Michael,
Is your binary log running on the slaves?
I have the same issue when forgotten enabling log_bin on SLAVE host
Thanks,
Igor
On 12/11/12 13:04, Machiel Richards - Gmail wrote:
Hi Guys
We need some assistance with a master slave setup we are
experiencing some issues with.
Hi Guys,
Just curious if any of you had a bad experience running optimize table
procedure. ERRORS, corrupted databases or tables caused by this.
We have MySQL 5.1.46 server.
I feel to run optimize of the full DB is quite safe
Example:
shell> mysqlcheck -o --skip-write-binlog database
What's your
Hi Rafael,
You can try using correlated subquery instead of outer join. This can be slow
with big tables though:
SELECT * FROM users WHERE accept_email = 1 and email not in (SELECT email FROM
sent_emails WHERE sent_emails
.email = users.email AND messageID NOT LIKE = ‘XX’)
OR OUTER JOIN as
Hi Reindl,
what do you delete by
> rm -f /Volumes/dune/mysql_data/bin*
and why?
Many thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
to insert
> duplicate rows into the storage table. This is why insert ignore and
> replace work.
>
>> On Jul 9, 2011 3:49 AM, "Igor Shevtsov" > <mailto:nixofort...@googlemail.com>> wrote:
>>
>> Hi all,
>> I can't explain strange behaviour
Hi all,
I can't explain strange behaviour of the INSERT statement in the stored
procedure.
The idea is to generate a list based on the output of 3 INNER JOIN of
regularly updated tables.
Something like :
INSERT INTO storage
(column list)
SELECT
column list
FROM t1 JOIN t2
ON t1.x=t2.y
JOIN t3
ON t
13 matches
Mail list logo