On Tue, Jun 5, 2012 at 1:51 PM, akaroot wrote:
>
>
> On 5 Чер, 22:16, Deepak Giridharagopal wrote:
>
> > Roughly how many facts per node are we talking about, here? I could try
> > running some simulations and see what happens.
>
>
> On average 80-90 facts per host, it's about 1500 inserts per s
On 5 Чер, 22:16, Deepak Giridharagopal wrote:
> Roughly how many facts per node are we talking about, here? I could try
> running some simulations and see what happens.
On average 80-90 facts per host, it's about 1500 inserts per second.
Will mysql cope with the load? I plan migrate to MariaD
I suspect that the deadlock caused by insert trigger (for a log of
changes some of the facts)
DELIMITER $ $
DROP TRIGGER IF EXISTS `facts_insert`;
CREATE TRIGGER facts_insert BEFORE INSERT ON `fact_values`
FOR EACH ROW BEGIN
IF (SELECT `name` FROM `fact_names` where `id` = NEW.fact_name_id)
in
On 5 Чер, 17:51, Kewin wrote:
> now we use mysql (manage about 1000 nodes) ,the pressure is not the
> mysql , but from the puppetmaster .always occur timeout for nodes to
> get the infomation
> I recommand the percona if U prefer the mysql
>
> On 6月5日, 上午4时05分, akaroot wrote:
I plan migrate
now we use mysql (manage about 1000 nodes) ,the pressure is not the
mysql , but from the puppetmaster .always occur timeout for nodes to
get the infomation
I recommand the percona if U prefer the mysql
On 6月5日, 上午4时05分, akaroot wrote:
> Hi!
> Which database would you recommend to use mysql or p
In mysql error log:
120605 12:50:50 [ERROR] /usr/sbin/mysqld: Deadlock found when trying
to get lock; try restarting transaction
120605 12:50:50 [ERROR] /usr/sbin/mysqld: Sort aborted: Deadlock
found when trying to get lock; try restarting transaction
--
You received this message because you
Now I have about 1 000 hosts and I received deadlock errors:
Puppet: Could not retrieve catalog from remote server: Error 400 on
SERVER: Mysql::Error: Deadlock found when trying to get lock; try
restarting transaction: INSERT INTO `fact_values` (`fact_name_id`,
`updated_at`, `host_id`, `value`,
I do not use puppet dashboard, I use my own software for store reports
and generating hosts config. The database used to store inventory data
(Facter facts). It create the most load on the database (insert many
requests).
--
You received this message because you are subscribed to the Google Group
