Problem avec massimportocs

sebastienBillard · 2010-06-02 22:47:14

pour des raison que je ne comprend pas, mon mysql server avec logging a ceci:
cela remplit mon serveur at 1gig par minute.

15.000+ de ligne

/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#100530 19:03:35 server id 2 end_log_pos 98 Start: binlog v 4, server v 5.0.51a-community-log created 100530 19:03:35
# at 98
#691231 19:00:00 server id 1 end_log_pos 0 Rotate to pmysql01-bin.000748 pos: 776208519
# at 144
#100530 15:35:58 server id 1 end_log_pos 0 Start: binlog v 4, server v 5.0.51a-community-log created 100530 15:35:58
# at 238
#100530 15:51:50 server id 1 end_log_pos 776208547 Intvar
SET INSERT_ID=180777/*!*/;
# at 266
#100530 15:51:50 server id 1 end_log_pos 776208746 Query thread_id=1225686 exec_time=0 error_code=0
use glpi/*!*/;
SET TIMESTAMP=1275249110/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=2, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
INSERT INTO glpi_computer_device (device_type,FK_device,FK_computers,specificity)
VALUES ('5','219','5957','B8:BB:17:00:00:2E')/*!*/;
# at 465
#100530 15:51:51 server id 1 end_log_pos 776208884 Query thread_id=1224434 exec_time=0 error_code=0
use ocsweb/*!*/;
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO locks(HARDWARE_ID, ID, SINCE) VALUES('8083','1891',NULL)/*!*/;
# at 603
#100530 15:51:51 server id 1 end_log_pos 776703656 Query thread_id=1225686 exec_time=0 error_code=0
use glpi/*!*/;
SET TIMESTAMP=1275249111/*!*/;
UPDATE glpi_ocs_link
SET `import_device`='148879=>6%24%24%24%24%24Floppy+disk+drive 148881=>6%24%24%24%24%24WDC+WD100BB-75AUA1 148883=>2%24%24%24%24%24Intel+Corporation+Pentium%AE+III+%280.18+%B5m%29+With+256+KB+On-Die+L2+Cache+ 148885=>8%24%24%24%24%24Intel%28R%29+82815+Graphics+Controller 148887=>9%24%24%24%24%24Intel%28r%29+82801BA%2FBAM+AC%5C%27%5C%2797+Audio+Controller 148889=>5%24%24%24%24%24%C3%90 148891=>5%24%24%24%24%24%C3%90 148893=>5%24%24%24%24%24%C3%90 148895=>5%24%24%24%24%24%C3%90 148897=>5%24%24%24%24%24%C3%90 148899=>5%24%24%24%24%24%C3%90 148901=>5%24%24%24%24%24%C3%90 148903=>5%24%24%24%24%24%C3%90 148905=>5%24%24%24%24%24%C3%90 148907=>5%24%24%24%24%24%C3%90 148909=>5%24%24%24%24%24%C3%90 148911=>5%24%24%24%24%24%C3%90 148913=>5%24%24%24%24%24%C3%90 148915=>5%24%24%24%24%24%C3%90 148917=>5%24%24%24%24%24%C3%90 148919=>5%24%24%24%24%24%C3%90 148921=>5%24%24%24%24%24%C3%90 148923=>5%24%24%24%24%24%C3%90 148925=>5%24%24%24%24%24%C3%90 148927=>5%24%24%24%24%24%C3%90 148929=>5%24%24%24%24%24%C3%90 148931=>5%24%24%24%24%24%C3%90 148933=>5%24%24%24%24%24%C3%90 148935=>5%24%24%24%24%24%C3%90 148937=>5%24%24%24%24%24%C3%90 148939=>5%24%24%24%24%24%C3%90 148941=>5%24%24%24%24%24%C3%90 148943=>5%24%24%24%24%24%C3%90 148945=>5%24%24%24%24%24%C3%90 148947=>5%24%24%24%24%24%C3%90 148949=>5%24%24%24%24%24%C3%90 148951=>5%24%24%24%24%24%C3%90 148953=>5%24%24%24%24%24%C3%90 148955=>5%24%24%24%24%24%C3%90 148957=>5%24%24%24%24%24%C3%90 148959=>5%24%24%24%24%24%C3%90 148961=>5%24%24%24%24%24%C3%90 148963=>5%24%24%24%24%24%C3%90 148965=>5%24%24%24%24%24%C3%90 148967=>5%24%24%24%24%24%C3%90 148969=>5%24%24%24%24%24%C3%90 148971=>5%24%24%24%24%24%C3%90 148973=>5%24%24%24%24%24%C3%90 148975=>5%24%24%24%24%24%C3%90 148977=>5%24%24%24%24%24%C3%90 148979=>5%24%24%24%24%24%C3%90 148981=>5%24%24%24%24%24%C3%90 148983=>5%24%24%24%24%24%C3%90 148985=>5%24%24%24%24%24%C3%90 148987=>5%24%24%24%24%24%C3%90 148989=>5%24%24%24%24%24%C3%90 148991=>5%24%24%24%24%24%C3%90 148993=>5%24%24%24%24%24%C3%90 148995=>5%24%24%24%24%24%C3%90 148997=>5%24%24%24%24%24%C3%90 148999=>5%24%24%24%24%24%C3%90 149001=>5%24%24%24%24%24%C3%90 149003=>5%24%24%24%24%24%C3%90 149005=>5%24%24%24%24%24%C3%90 149007=>5%24%24%24%24%24%C3%90 149009=>5%24%24%24%24%24%C3%90 149011=>5%24%24%24%24%24%C3%90 149013=>5%24%24%24%24%24%C3%90 149015=>5%24%24%24%24%24%C3%90 149017=>5%24%24%24%24%24%C3%90 149019=>5%24%24%24%24%24%C3%90 149021=>5%24%24%24%24%24%C3%90 149023=>5%24%24%24%24%24%C3%90 149025=>5%24%24%24%24%24%C3%90 149027=>5%24%24%24%24%24%C3%90 149029=>5%24%24%24%24%24%C3%90 149031=>5%24%24%24%24%24%C3%90 149033=>5%24%24%24%24%24%C3%90 149035=>5%24%24%24%24%24%C3%90 149037=>5%24%24%24%24%24%C3%90 149039=>5%24%24%24%24%24%C3%90 149041=>5%24%24%24%24%24%C3%90 149043=>5%24%24%24%24%24%C3%90 149045=>5%24%24%24%24%24%C3%90 149047=>5%24%24%24%24%24%C3%90 149049=>5%24%24%24%24%24%C3%90 149051=>5%24%24%24%24%24%C3%90 149053=>5%24%24%24%24%24%C3%90 149055=>5%24%24%24%24%24%C3%90 149057=>5%24%24%24%24%24%C3%90 149059=>5%24%24%24%24%24%C3%90 149061=>5%24%24%24%24%24%C3%90 149063=>5%24%24%24%24%24%C3%90 149065=>5%24%24%24%24%24%C3%90 149067=>5%24%24%24%24%24%C3%90 149069=>5%24%24%24%24%24%C3%90 149071=>5%24%24%24%24%24%C3%90 149073=>5%24%24%24%24%24%C3%90 149075=>5%24%24%24%24%24%C3%90 149077=>5%24%24%24%24%24%C3%90 149079=>5%24%24%24%24%24%C3%90 149081=>5%24%24%24%24%24%C3%90 149083=>5%24%24%24%24%24%C3%90 149085=>5%24%24%24%24%24%C3%90 149087=>5%24%24%24%24%24%C3%90 149089=>5%24%24%24%24%24%C3%90 149091=>5%24%24%24%24%24%C3%90 149093=>5%24%24%24%24%24%C3%90 149095=>5%24%24%24%24%24%C3%90 149097=>5%24%24%24%24%24%C3%90 149099=>5%24%24%24%24%24%C3%90 149101=>5%24%24%24%24%24%C3%90 149103=>5%24%24%24%24%24%C3%90 149105=>5%24%24%24%24%24%C3%90 149107=>5%24%24%24%24%24%C3%90 149109=>5%24%24%24%24%24%C3%90 149111=>5%24%24%24%24%24%C3%90 149113=>5%24%24%24%24%24%C3%90 149115=>5%24%24%24%24%24%C3%90 149117=>5%24%24%24%24%24%C3%90 149119=>5%24%24%24%24%24%C3%90 149121=>5%24%24%24%24%24%C3%90 149123=>5%24%24%24%24%24%C3%90 149125=>5%24%24%24%24%24%C3%90 149127=>5%24%24%24%24%24%C3%90 149129=>5%24%24%24%24%24%C3%90 149131=>5%24%24%24%24%24%C3%90 149133=>5%24%24%24%24%24%C3%90 149135=>5%24%24%24%24%24%C3%90 149137=>5%24%24%24%24%24%C3%90 149139=>5%24%24%24%24%24%C3%90 149141=>5%24%24%24%24%24%C3%90 149143=>5%24%24%24%24%24%C3%90 149145=>5%24%24%24%24%24%C3%90 149147=>5%24%24%24%24%24%C3%90 149149=>5%24%24%24%24%24%C3%90 149151=>5%24%24%24%24%24%C3%90 149153=>5%24%24%24%24%24%C3%90 149155=>5%24%24%24%24%24%C3%90 149157=>5%24%24%24%24%24%C3%90 149159=>5%24%24%24%24%24%C3%90 149161=>5%24%24%24%24%24%C3%90 149163=>5%24%24%24%24%24%C3%90 149165=>5%24%24%24%24%24%C3%90 149167=>5%24%24%24%24%24%C3%90 149169=>5%24%24%24%24%24%C3%90 149171=>5%24%24%24%24%24%C3%90 149173=>5%24%24%24%24%24%C3%90 149175=>5%24%24%24%24%24%C3%90 149177=>5%24%24%24%24%24%C3%90 149179=>5%24%24%24%24%24%C3%90 149181=>5%24%24%24%24%24%C3%90 149183=>5%24%24%24%24%24%C3%90 149185=>5%24%24%24%24%24%C3%90 149187=>5%24%24%24%24%24%C3%90 149189=>5%24%24%24%24%24%C3%90 149191=>5%24%24%24%24%24%C3%90 149193=>5%24%24%24%24%24%C3%90 149195=>5%24%24%24%24%24%C3%90 149197=>5%24%24%24%24%24%C3%90 149199=>5%24%24%24%24%24%C3%90 149201=>5%24%24%24%24%24%C3%90 149203=>5%24%24%24%24%24%C3%90 149205=>5%24%24%24%24%24%C3%90 149207=>5%24%24%24%24%24%C3%90 149209=>5%24%24%24%24%24%C3%90 149211=>5%24%24%24%24%24%C3%90 149213=>5%24%24%24%24%24%C3%90 149215=>5%24%24%24%24%24%C3%90 149217=>5%24%24%24%24%24%C3%90 149219=>5%24%24%24%24%24%C3%90 149221=>5%24%24%24%24%24%C3%90 149223=>5%24%24%24%24%24%C3%90 149225=>5%24%24%24%24%24%C3%90 149227=>5%24%24%24%24%24%C3%90 149229=>5%24%24%24%24%24%C3%90 149231=>5%24%24%24%24%24%C3%90 149233=>5%24%24%24%24%24%C3%90 149235=>5%24%24%24%24%24%C3%90 149237=>5%24%24%24%24%24%C3%90 149239=>5%24%24%24%24%24%C3%90 149241=>5%24%24%24%24%24%C3%90 149243=>5%24%24%24%24%24%C3%90 149245=>5%24%24%24%24%24%C3%90 149247=>5%24%24%24%24%24%C3%90 149249=>5%24%24%24%24%24%C3%90 149251=>5%24%24%24%24%24%C3%90 149253=>5%24%24%24%24%24%C3%90 149255=>5%24%24%24%24%24%C3%90 149257=>5%24%24%24%24%24%C3%90 149259=>5%24%24%24%24%24%C3%90 149261=>5%24%24%24%24%24%C3%90 149263=>5%24%24%24%24%24%C3%90 149265=>5%24%24%24%24%24%C3%90 149267=>5%24%24%24%24%24%C3%90 149269=>5%24%24%24%24%24%C3%90 149271=>5%24%24%24%24%24%C3%90 149273=>5%24%24%24%24%24%C3%90 149275=>5%24%24%24%24%24%C3%90 149277=>51=>5%24%24%24%24%24%C3%90 151453=>5%24%24%24%24%24%C3%90 151455=>5%24%24%24%24%24%C3%90 151457=>5%24%24%24%24%24%C3%90 151459=>5%24%24%24%24%24%C3%90 151461=>5%24%24%24%24%24%C3%90 151463=>5%24%24%24%24%24%C3%90 151465=>5%24%24%24%24%24%C3%90 151467=>5%24%24%24%24%24%C3%90 151469=>5%24%24%24%24%174877=>5%24%24%24%24%24%C3%90 174879=>5%24%24%24%24%24%C3%90 174881=>5%24%24%24%24%24%C3%90 174883=>5%24%24%24%24%24%C3%90 174885=>5%24%24%24%24%24%C3%90 174887=>5%24%24%24%24%24%C3%90 174889=>5%24%24%24%24%24%C3%90 174891=>5%24%24%24%24%24%C3%90 174893=>5%24%24%24%24%24%C3%90 174895=>5%24%24%24%24%24%C3%90 174897=>5%24%24%24%24%24%C3%90 174899=>5%24%24%24%24%24%C3%90 174901=>5%24%24%24%24%24%C3%90 174903=>5%24%24%24%24%24%C3%90 174905=>5%24%24%24%24%24%C3%90 174907=>5%24%24%24%24%24%C3%90 174909=>5%24%24%24%24%24%C3%90 174911=>5%24%24%24%24%24%C3%90 174913=>5%24%24%24%24%24%C3%90 174915=>5%24%24%24%24%24%C3%90 174917=>5%24%24%24%24%24%C3%90 174919=>5%24%24%24%24%24%C3%90 174921=>5%24%24%24%24%24%C3%90 174923=>5%24%24%24%24%24%C3%90 174925=>5%24%24%24%24%24%C3%90 174927=>5%24%24%24%24%24%C3%90 174929=>5%24%24%24%24%24%C3%90 174931=>5%24%24%24%24%24%C3%90 174933=>5%24%24%24%24%24%C3%90 174935=>5%24%24%24%24%24%C3%90 174937=>5%24%24%24%24%24%C3%90 174939=>5%24%24%24%24%24%C3%90 174941=>5%24%24%24%24%24%C3%90 174943=>5%24%24%24%24%24%C3%90 174945=>5%24%24%24%24%24%C3%90 174947=>5%24%24%24%24%24%C3%90 174949=>5%24%24%24%24%24%C3%90 174951=>5%24%24%24%24%24%C3%90 174953=>5%24%24%24%24%24%C3%90 174955=>5%24%24%24%24%24%C3%90 174957=>5%24%24%24%24%24%C3%90 174959=>5%24%24%24%24%24%C3%90 174961=>5%24%24%24%24%24%C3%90 174963=>5%24%24%24%24%24%C3%90 174965=>5%24%24%24%24%24%C3%90 174967=>5%24%24%24%24%24%C3%90 174969=>5%24%24%24%24%24%C3%90 174971=>5%24%24%24%24%24%C3%90 174973=>5%24%24%24%24%24%C3%90 174975=>5%24%24%24%24%24%C3%90 174977=>5%24%24%24%24%24%C3%90 174979=>5%24%24%24%24%24%C3%90 174981=>5%24%24%24%24%24%C3%90 174983=>5%24%24%24%24%24%C3%90 174985=>5%24%24%24%24%24%C3%90 174987=>5%24%24%24%24%24%C3%90 174989=>5%24%24%24%24%24%C3%90 174991=>5%24%24%24%24%24%C3%90 174993=>5%24%24%24%24%24%C3%90 174995=>5%24%24%24%24%24%C3%90 174997=>5%24%24%24%24%24%C3%90 174999=>5%24%24%24%24%24%C3%90 175001=>5%24%24%24%24%24%C3%90 175003=>5%24%24%24%24%24%C3%90 175005=>5%24%24%24%24%24%C3%90 175007=>5%24%24%24%24%24%C3%90 175009=>5%24%24%24%24%24%C3%90 175011=>5%24%24%24%24%24%C3%90 175013=>5%24%24%24%24%24%C3%90 175015=>5%24%24%24%24%24%C3%90 175017=>5%24%24%24%24%24%C3%90 175019=>5%24%24%24%24%24%C3%90 175021=>5%24%24%24%24%24%C3%90 175023=>5%24%24%24%24%24%C3%90 175025=>5%24%24%24%24%24%C3%90 175027=>5%24%24%24%24%24%C3%90 175029=>5%24%24%24%24%24%C3%90 175031=>5%24%24%24%24%24%C3%90 175033=>5%24%24%24%24%24%C3%90 175035=>5%24%24%24%24%24%C3%90 175037=>5%24%24%24%24%24%C3%90 175039=>5%24%24%24%24%24%C3%90 175041=>5%24%24%24%24%24%C3%90 175043=>5%24%24%24%24%24%C3%90 175045=>5%24%24%24%24%24%C3%90 175047=>5%24%24%24%24%24%C3%90 175049=>5%24%24%24%24%24%C3%90 175051=>5%24%24%24%24%24%C3%90 175053=>5%24%24%24%24%24%C3%90 175055=>5%24%24%24%24%24%C3%90 175057=>5%24%24%24%24%24%C3%90 175059=>5%24%24%24%24%24%C3%90 175061=>5%24%24%24%24%24%C3%90 175063=>5%24%24%24%24%24%C3%90 175065=>5%24%24%24%24%24%C3%90 175067=>5%24%24%24%24%24%C3%90 175069=>5%24%24%24%24%24%C3%90 175071=>5%24%24%24%24%24%C3%90 175073=>5%24%24%24%24%24%C3%90 175075=>5%24%24%24%24%24%C3%90 175077=>5%24%24%24%24%24%C3%90 175079=>5%24%24%24%24%24%C3%90 175081=>5%24%24%24%24%24%C3%90 175083=>5%24%24%24%24%24%C3%90 175085=>5%24%24%24%24%24%C3%90 175087=>5%24%24%24%24%24%C3%90 175089=>5%24%24%24%24%24%C3%90 175091=>5%24%24%24%24%24%C3%90 175093=>5%24%24%24%24%24%C3%90 175095=>5%24%24%24%24%24%C3%90 175097=>5%24%24%24%24%24%C3%90 175099=>5%24%24%24%24%24%C3%90 175101=>5%24%24%24%24%24%C3%90 175103=>5%24%24%24%24%24%C3%90 175105=>5%24%24%24%24%24%C3%90 175107=>5%24%24%24%24%24%C3%90 175109=>5%24%24%24%24%24%C3%90 175111=>5%24%24%24%24%24%C3%90 175113=>5%24%24%24%24%24%C3%90 175115=>5%24%24%24%24%24%C3%90 175117=>5%24%24%24%24%24%C3%90 175119=>5%24%24%24%24%24%C3%90 175121=>5%24%24%24%24%24%C3%90 175123=>5%24%24%24%24%24%C3%90 175125=>5%24%24%24%24%24%C3%90 175127=>5%24%24%24%24%24%C3%90 175129=>5%24%24%24%24%24%C3%90 175131=>5%24%24%24%24%24%C3%90 175133=>5%24%24%24%24%24%C3%90 175135=>5%24%24%24%24%24%C3%90 175137=>5%24%24%24%24%24%C3%90 175139=>5%24%24%24%24%24%C3%90 175141=>5%24%24%24%24%24%C3%90 175143=>5%24%24%24%24%24%C3%90 175145=>5%24%24%24%24%24%C3%90 175147=>5%24%24%24%24%24%C3%90 175149=>5%24%24%24%24%24%C3%90 175151=>5%24%24%24%24%24%C3%90 175153=>5%24%24%24%24%24%C3%90 175155=>5%24%24%24%24%24%C3%90 175157=>5%24%24%24%24%24%C3%90 175159=>5%24%24%24%24%24%C3%90 175161=>5%24%24%24%24%24%C3%90 175163=>5%24%24%24%24%24%C3%90 175165=>5%24%24%24%24%24%C3%90 175167=>5%24%24%24%24%24%C3%90 175169=>5%24%24%24%24%24%C3%90 175171=>5%24%24%24%24%24%C3%90 175173=>5%24%24%24%24%24%C3%90 175175=>5%24%24%24%24%24%C3%90 175177=>5%24%24%24%24%24%C3%90 175179=>5%24%24%24%24%24%C3%90 175181=>5%24%24%24%24%24%C3%90 175183=>5%24%24%24%24%24%C3%90 175185=>5%24%24%24%24%24%C3%90 175187=>5%24%24%24%24%24%C3%90 175189=>5%24%24%24%24%24%C3%90 175191=>5%24%24%24%24%24%C3%90 175193=>5%24%24%24%24%24%C3%90 175195=>5%24%24%24%24%24%C3%90 175197=>5%24%24%24%24%24%C3%90 175199=>5%24%24%24%24%24%C3%90 175201=>5%24%24%24%24%24%C3%90 175203=>5%24%24%24%24%24%C3%90 175205=>5%24%24%24%24%24%C3%90 175207=>5%24%24%24%24%24%C3%90 175209=>5%24%24%24%24%24%C3%90 175211=>5%24%24%24%24%24%C3%90 175213=>5%24%24%24%24%24%C3%90 175215=>5%24%24%24%24%24%C3%90 175217=>5%24%24%24%24%24%C3%90 175219=>5%24%24%24%24%24%C3%90 175221=>5%24%24%24%24%24%C3%90 175223=>5%24%24%24%24%24%C3%90 175225=>5%24%24%24%24%24%C3%90 175227=>5%24%24%24%24%24%C3%90 175229=>5%24%24%24%24%24%C3%90 175231=>5%24%24%24%24%24%C3%90 175233=>5%24%24%24%24%24%C3%90 175235=>5%24%24%24%24%24%C3%90 175237=>5%24%24%24%24%24%C3%90 175239=>5%24%24%24%24%24%C3%90 175241=>5%24%24%24%24%24%C3%90 175243=>5%24%24%24%24%24%C3%90 175245=>5%24%24%24%24%24%C3%90 175247=>5%24%24%24%24%24%C3%90 175249=>5%24%24%24%24%24%C3%90 175251=>5%24%24%24%24%24%C3%90 175253=>5%24%24%24%24%24%C3%90 175255=>5%24%24%24%24%24%C3%90 175257=>5%24%24%24%24%24%C3%90 175259=>5%24%24%24%24%24%C3%90 175261=>5%24%24%24%24%24%C3%90 175263=>5%24%24%24%24%24%C3%90 175265=>5%24%24%24%24%24%C3%90 175267=>5%24%24%24%24%24%C3%90 175269=>5%24%24%24%24%24%C3%90 175271=>5%24%24%24%24%24%C3%90 175273=>5%24%24%24%24%24%C3%90 175275=>5%24%24%24%24%24%C3%90 175277=>5%24%24%24%24%24%C3%90 175279=>5%24%24%24%24%24%C3%90 175281=>5%24%24%24%24%24%C3%90 175283=>5%24%24%24%24%24%C3%90 175285=>5%24%24%24%24%24%C3%90 175287=>5%24%24%24%24%24%C3%90 175289=>5%24%24%24%24%24%C3%90 175291=>5%24%24%24%24%24%C3%90 175293=>5%24%24%24%24%24%C3%90 175295=>5%24%24%24%24%24%C3%90 175297=>5%24%24%24%24%24%C3%90 175299=>5%24%24%24%24%24%C3%90 175301=>5%24%24%24%24%24%C3%90 175303=>5%24%24%24%24%24%C3%90 175305=>5%24%24%24%24%24%C3%90 175307=>5%24%24%24%24%24%C3%90 175309=>5%24%24%24%24%24%C3%90 175311=>5%24%24%24%24%24%C3%90 175313=>5%24%24%24%24%24%C3%90 175315=>5%24%24%24%24%24%C3%90 175317=>5%24%24%24%24%24%C3%90 175319=>5%24%24%24%24%24%C3%90 175321=>5%24%24%24%24%24%C3%90 175323=>5%24%24%24%24%24%C3%90 175325=>5%24%24%24%24%24%C3%90 175327=>5%24%24%24%24%24%C3%90 175329=>5%24%24%24%24%24%C3%90 175331=>5%24%24%24%24%24%C3%90 175333=>5%24%24%24%24%24%C3%90 175335=>5%24%24%24%24%24%C3%90 175337=>5%24%24%24%24%24%C3%90 175339=>5%24%24%24%24%24%C3%90 175341=>5%24%24%24%24%24%C3%90 175343=>5%24%24%24%24%24%C3%90 175345=>5%24%24%24%24%24%C3%90 175347=>5%24%24%24%24%24%C3%90 175349=>5%24%24%24%24%24%C3%90 175351=>5%24%24%24%24%24%C3%90 175353=>5%24%24%24%24%24%C3%90 175355=>5%24%24%24%24%24%C3%90 175357=>5%24%24%24%24%24%C3%90 175359=>5%24%24%24%24%24%C3%90 175361=>5%24%24%24%24%24%C3%90 175363=>5%24%24%24%24%24%C3%90 175365=>5%24%24%24%24%24%C3%90 175367=>5%24%24%24%24%24%C3%90 175369=>5%24%24%24%24%24%C3%90 175371=>5%24%24%24%24%24%C3%90 175373=>5%24%24%24%24%24%C3%90 175375=>5%24%24%24%24%24%C3%90 175377=>5%24%24%24%24%24%C3%90 175379=>5%24%24%24%24%24%C3%90 175381=>5%24%24%24%24%24%C3%90 175383=>5%24%24%24%24%24%C3%90 175385=>5%24%24%24%24%24%C3%90 175387=>5%24%24%24%24%24%C3%90 175389=>5%24%24%24%24%24%C3%90 175391=>5%24%24%24%24%24%C3%90 175393=>5%24%24%24%24%24%C3%90 175395=>5%24%24%24%24%24%C3%90 175397=>5%24%24%24%24%24%C3%90 175399=>5%24%24%24%24%24%C3%90 175401=>5%24%24%24%24%24%C3%90 175403=>5%24%24%24%24%24%C3%90 175405=>5%24%24%24%24%24%C3%90 175407=>5%24%24%24%24%24%C3%90 175409=>5%24%24%24%24%24%C3%90 175411=>5%24%24%24%24%24%C3%90 175413=>5%24%24%24%24%24%C3%90 175415=>5%24%24%24%24%24%C3%90 175417=>5%24%24%24%24%24%C3%90 175419=>5%24%24%24%24%24%C3%90 175421=>5%24%24%24%24%24%C3%90 175423=>5%24%24%24%24%24%C3%90 175425=>5%24%24%24%24%24%C3%90 175427=>5%24%24%24%24%24%C3%90 175429=>5%24%24%24%24%24%C3%90 175431=>5%24%24%24%24%24%C3%90 175433=>5%24%24%24%24%24%C3%90 175435=>5%24%24%24%24%24%C3%90 180325=>5%24%24%24%24%24%C3%90 180327=>5%24%24%24%24%24%C3%90 180329=>5%24%24%24%24%24%C3%90 180331=>5%24%24%24%24%24%C3%90 180333=>5%24%24%24%24%24%C3%90 180335=>5%24%24%24%24%24%C3%90 180337=>5%24%24%24%24%24%C3%90 180339=>5%24%24%24%24%24%C3%90 180341=>5%24%24%24%24%24%C3%90 180343=>5%24%24%24%24%24%C3%90 180345=>5%24%24%24%24%24%C3%90 180347=>5%24%24%24%24%24%C3%90 180349=>5%24%24%24%24%24%C3%90 180351=>5%24%24%24%24%24%C3%90 180353=>5%24%24%24%24%24%C3%90 180355=>5%24%24%24%24%24%C3%90 180357=>5%24%24%24%24%24%C3%90 180359=>5%24%24%24%24%24%C3%90 180361=>5%24%24%24%24%24%C3%90 180363=>5%24%24%24%24%24%C3%90 180365=>5%24%24%24%24%24%C3%90 180367=>5%24%24%24%24%24%C3%90 180369=>5%24%24%24%24%24%C3%90 180371=>5%24%24%24%24%24%C3%90 180373=>5%24%24%24%24%24%C3%90 180375=>5%24%24%24%24%24%C3%90 180377=>5%24%24%24%24%24%C3%90 180379=>5%24%24%24%24%24%C3%90 180381=>5%24%24%24%24%24%C3%90 180383=>5%24%24%24%24%24%C3%90 180385=>5%24%24%24%24%24%C3%90 180387=>5%24%24%24%24%24%C3%90 180389=>5%24%24%24%24%24%C3%90 180391=>5%24%24%24%24%24%C3%90 180393=>5%24%24%24%24%24%C3%90 180395=>5%24%24%24%24%24%C3%90 180397=>5%24%24%24%24%24%C3%90 180399=>5%24%24%24%24%24%C3%90 180401=>5%24%24%24%24%24%C3%90 180403=>5%24%24%24%24%24%C3%90 180405=>5%24%24%24%24%24%C3%90 180407=>5%24%24%24%24%24%C3%90 180409=>5%24%24%24%24%24%C3%90 180411=>5%24%24%24%24%24%C3%90 180413=>5%24%24%24%24%24%C3%90 180415=>5%24%24%24%24%24%C3%90 180417=>5%24%24%24%24%24%C3%90 180419=>5%24%24%24%24%24%C3%90 180421=>5%24%24%24%24%24%C3%90 180423=>5%24%24%24%24%24%C3%90 180425=>5%24%24%24%24%24%C3%90 180427=>5%24%24%24%24%24%C3%90 180429=>5%24%24%24%24%24%C3%90 180431=>5%24%24%24%24%24%C3%90 180433=>5%24%24%24%24%24%C3%90 180435=>5%24%24%24%24%24%C3%90 180437=>5%24%24%24%24%24%C3%90 180439=>5%24%24%24%24%24%C3%90 180441=>5%24%24%24%24%24%C3%90 180443=>5%24%24%24%24%24%C3%90 180445=>5%24%24%24%24%24%C3%90 180447=>5%24%24%24%24%24%C3%90 180449=>5%24%24%24%24%24%C3%90 180451=>5%24%24%24%24%24%C3%90 180453=>5%24%24%24%24%24%C3%90 180455=>5%24%24%24%24%24%C3%90 180457=>5%24%24%24%24%24%C3%90 180459=>5%24%24%24%24%24%C3%90 180461=>5%24%24%24%24%24%C3%90 180463=>5%24%24%24%24%24%C3%90 180465=>5%24%24%24%24%24%C3%90 180467=>5%24%24%24%24%24%C3%90 180469=>5%24%24%24%24%24%C3%90 180471=>5%24%24%24%24%24%C3%90 180473=>5%24%24%24%24%24%C3%90 180475=>5%24%24%24%24%24%C3%90 180477=>5%24%24%24%24%24%C3%90 180479=>5%24%24%24%24%24%C3%90 180481=>5%24%24%24%24%24%C3%90 180483=>5%24%24%24%24%24%C3%90 180485=>5%24%24%24%24%24%C3%90 180487=>5%24%24%24%24%24%C3%90 180489=>5%24%24%24%24%24%C3%90 180491=>5%24%24%24%24%24%C3%90 180493=>5%24%24%24%24%24%C3%90 180495=>5%24%24%24%24%24%C3%90 180497=>5%24%24%24%24%24%C3%90 180499=>5%24%24%24%24%24%C3%90 180501=>5%24%24%24%24%24%C3%90 180503=>5%24%24%24%24%24%C3%90 180505=>5%24%24%24%24%24%C3%90 180507=>5%24%24%24%24%24%C3%90 180509=>5%24%24%24%24%24%C3%90 180511=>5%24%24%24%24%24%C3%90 180513=>5%24%24%24%24%24%C3%90 180515=>5%24%24%24%24%24%C3%90 180517=>5%24%24%24%24%24%C3%90 180519=>5%24%24%24%24%24%C3%90 180521=>5%24%24%24%24%24%C3%90 180523=>5%24%24%24%24%24%C3%90 180525=>5%24%24%24%24%24%C3%90 180527=>5%24%24%24%24%24%C3%90 180529=>5%24%24%24%24%24%C3%90 180531=>5%24%24%24%24%24%C3%90 180533=>5%24%24%24%24%24%C3%90 180535=>5%24%24%24%24%24%C3%90 180537=>5%24%24%24%24%24%C3%90 180539=>5%24%24%24%24%24%C3%90 180541=>5%24%24%24%24%24%C3%90 180543=>5%24%24%24%24%24%C3%90 180545=>5%24%24%24%24%24%C3%90 180547=>5%24%24%24%24%24%C3%90 180549=>5%24%24%24%24%24%C3%90 180551=>5%24%24%24%24%24%C3%90 180553=>5%24%24%24%24%24%C3%90 180555=>5%24%24%24%24%24%C3%90 180557=>5%24%24%24%24%24%C3%90 180559=>5%24%24%24%24%24%C3%90 180561=>5%24%24%24%24%24%C3%90 180563=>5%24%24%24%24%24%C3%90 180565=>5%24%24%24%24%24%C3%90 180567=>5%24%24%24%24%24%C3%90 180569=>5%24%24%24%24%24%C3%90 180571=>5%24%24%24%24%24%C3%90 180573=>5%24%24%24%24%24%C3%90 180575=>5%24%24%24%24%24%C3%90 180577=>5%24%24%24%24%24%C3%90 180579=>5%24%24%24%24%24%C3%90 180581=>5%24%24%24%24%24%C3%90 180583=>5%24%24%24%24%24%C3%90 180585=>5%24%24%24%24%24%C3%90 180587=>5%24%24%24%24%24%C3%90 180589=>5%24%24%24%24%24%C3%90 180591=>5%24%24%24%24%24%C3%90 180593=>5%24%24%24%24%24%C3%90 180595=>5%24%24%24%24%24%C3%90 180597=>5%24%24%24%24%24%C3%90 180599=>5%24%24%24%24%24%C3%90 180601=>5%24%24%24%24%24%C3%90 180603=>5%24%24%24%24%24%C3%90 180605=>5%24%24%24%24%24%C3%90 180607=>5%24%24%24%24%24%C3%90 180609=>5%24%24%24%24%24%C3%90 180611=>5%24%24%24%24%24%C3%90 180613=>5%24%24%24%24%24%C3%90 180615=>5%24%24%24%24%24%C3%90 180617=>5%24%24%24%24%24%C3%90 180619=>5%24%24%24%24%24%C3%90 180621=>5%24%24%24%24%24%C3%90 180623=>5%24%24%24%24%24%C3%90 180625=>5%24%24%24%24%24%C3%90 180627=>5%24%24%24%24%24%C3%90 180629=>5%24%24%24%24%24%C3%90 180631=>5%24%24%24%24%24%C3%90 180633=>5%24%24%24%24%24%C3%90 180635=>5%24%24%24%24%24%C3%90 180637=>5%24%24%24%24%24%C3%90 180639=>5%24%24%24%24%24%C3%90 180641=>5%24%24%24%24%24%C3%90 180643=>5%24%24%24%24%24%C3%90 180645=>5%24%24%24%24%24%C3%90 180647=>5%24%24%24%24%24%C3%90 180649=>5%24%24%24%24%24%C3%90 180651=>5%24%24%24%24%24%C3%90 180653=>5%24%24%24%24%24%C3%90 180655=>5%24%24%24%24%24%C3%90 180657=>5%24%24%24%24%24%C3%90 180659=>5%24%24%24%24%24%C3%90 180661=>5%24%24%24%24%24%C3%90 180663=>5%24%24%24%24%24%C3%90 180665=>5%24%24%24%24%24%C3%90 180667=>5%24%24%24%24%24%C3%90 180669=>5%24%24%24%24%24%C3%90 180671=>5%24%24%24%24%24%C3%90 180673=>5%24%24%24%24%24%C3%90 180675=>5%24%24%24%24%24%C3%90 180677=>5%24%24%24%24%24%C3%90 180679=>5%24%24%24%24%24%C3%90 180681=>5%24%24%24%24%24%C3%90 180683=>5%24%24%24%24%24%C3%90 180685=>5%24%24%24%24%24%C3%90 180687=>5%24%24%24%24%24%C3%90 180689=>5%24%24%24%24%24%C3%90 180691=>5%24%24%24%24%24%C3%90 180693=>5%24%24%24%24%24%C3%90 180695=>5%24%24%24%24%24%C3%90 180697=>5%24%24%24%24%24%C3%90 180699=>5%24%24%24%24%24%C3%90 180701=>5%24%24%24%24%24%C3%90 180703=>5%24%24%24%24%24%C3%90 180705=>5%24%24%24%24%24%C3%90 180707=>5%24%24%24%24%24%C3%90 180709=>5%24%24%24%24%24%C3%90 180711=>5%24%24%24%24%24%C3%90 180713=>5%24%24%24%24%24%C3%90 180715=>5%24%24%24%24%24%C3%90 180717=>5%24%24%24%24%24%C3%90 180719=>5%24%24%24%24%24%C3%90 180721=>5%24%24%24%24%24%C3%90 180723=>5%24%24%24%24%24%C3%90 180725=>5%24%24%24%24%24%C3%90 180727=>5%24%24%24%24%24%C3%90 180729=>5%24%24%24%24%24%C3%90 180731=>5%24%24%24%24%24%C3%90 180733=>5%24%24%24%24%24%C3%90 180735=>5%24%24%24%24%24%C3%90 180737=>5%24%24%24%24%24%C3%90 180739=>5%24%24%24%24%24%C3%90 180741=>5%24%24%24%24%24%C3%90 180743=>5%24%24%24%24%24%C3%90 180745=>5%24%24%24%24%24%C3%90 180747=>5%24%24%24%24%24%C3%90 180749=>5%24%24%24%24%24%C3%90 180751=>5%24%24%24%24%24%C3%90 180753=>5%24%24%24%24%24%C3%90 180755=>5%24%24%24%24%24%C3%90 180757=>5%24%24%24%24%24%C3%90 180759=>5%24%24%24%24%24%C3%90 180761=>5%24%24%24%24%24%C3%90 180763=>5%24%24%24%24%24%C3%90 180765=>5%24%24%24%24%24%C3%90 180767=>5%24%24%24%24%24%C3%90 180769=>5%24%24%24%24%24%C3%90 180771=>5%24%24%24%24%24%C3%90 180773=>5%24%24%24%24%24%C3%90 180775=>5%24%24%24%24%24%C3%90 180777=>5%24%24%24%24%24%C3%90 '
WHERE glpi_id='5957'/*!*/;
# at 495375
#100530 15:51:51 server id 1 end_log_pos 776703684 Intvar
SET INSERT_ID=180779/*!*/;
# at 495403
#100530 15:51:51 server id 1 end_log_pos 776703883 Query thread_id=1225686 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO glpi_computer_device (device_type,FK_device,FK_computers,specificity)
VALUES ('5','219','5957','B8:BB:17:00:00:2E')/*!*/;
# at 495602
#100530 15:51:51 server id 1 end_log_pos 776703958 Query thread_id=1224434 exec_time=0 error_code=0
use ocsweb/*!*/;
SET TIMESTAMP=1275249111/*!*/;
BEGIN/*!*/;
# at 495677
#100530 15:51:51 server id 1 end_log_pos 776704720 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
SET @@session.time_zone='SYSTEM'/*!*/;
UPDATE hardware SET USERAGENT='OCS-NG_windows_client_v4061',
LASTDATE=NOW(),
LASTCOME=NOW(),
CHECKSUM=(0|CHECKSUM|1),
NAME='B03043-QZQ01',
WORKGROUP='acsbnt.ad.net',
USERDOMAIN='ACSBNT',
OSNAME='Microsoft Windows XP Professional',
OSVERSION='5.1.2600',
OSCOMMENTS='Service Pack 3',
PROCESSORT='Intel Celeron processor',
PROCESSORS='797',
PROCESSORN='1',
MEMORY='512',
SWAP='1247',
IPADDR='172.19.4.107',
DNS=NULL,
DEFAULTGATEWAY=NULL,
ETIME=NULL,

TYPE='0',
DESCRIPTION='CUSTOMERSERVICE',
WINCOMPANY='ACS',
WINOWNER='ACS',
WINPRODID='55274-640-0845477-23873',
WINPRODKEY='W764W-32WFM-VBQDW-6Q62Q-7DQ7W',
IPSRC='172.19.4.107',
UUID=NULL
WHERE ID=8083/*!*/;
# at 496439
#100530 15:51:51 server id 1 end_log_pos 776704835 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
DELETE FROM javainfo WHERE HARDWARE_ID='8083'/*!*/;
# at 496554
#100530 15:51:51 server id 1 end_log_pos 776705045 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO javainfo(`HARDWARE_ID`,`JAVAPATHLEVEL`,`JAVAHOME`,`JAVACLASSPATH`,`JAVANAME`,`JAVACOUNTRY`) VALUES('8083','0','','','noname','')/*!*/;
# at 496764
#100530 15:51:51 server id 1 end_log_pos 776705072 Xid = 78112781
COMMIT/*!*/;
# at 496791
#100530 15:51:51 server id 1 end_log_pos 776705147 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
BEGIN/*!*/;
# at 496866
#100530 15:51:51 server id 1 end_log_pos 776705270 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
DELETE FROM download_history WHERE HARDWARE_ID='8083'/*!*/;
# at 496989
#100530 15:51:51 server id 1 end_log_pos 776705416 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1243870804')/*!*/;
# at 497135
#100530 15:51:51 server id 1 end_log_pos 776705562 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1252010150')/*!*/;
# at 497281
#100530 15:51:51 server id 1 end_log_pos 776705708 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1253864795')/*!*/;
# at 497427
#100530 15:51:51 server id 1 end_log_pos 776705854 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1257266374')/*!*/;
# at 497573
#100530 15:51:51 server id 1 end_log_pos 776706000 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1258998737')/*!*/;
# at 497719
#100530 15:51:51 server id 1 end_log_pos 776706146 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1259004526')/*!*/;
# at 497865
#100530 15:51:51 server id 1 end_log_pos 776706292 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1271169630')/*!*/;
# at 498011
#100530 15:51:51 server id 1 end_log_pos 776706438 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1274105604')/*!*/;
# at 498157
#100530 15:51:51 server id 1 end_log_pos 776706584 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1274129304')/*!*/;
# at 498303
#100530 15:51:51 server id 1 end_log_pos 776706730 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
INSERT INTO download_history(HARDWARE_ID, PKG_ID) VALUE('8083','1274189829')/*!*/;
# at 498449
#100530 15:51:51 server id 1 end_log_pos 776706878 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
DELETE FROM prolog_conntrack WHERE DEVICEID='B03043-QZQ01-2010-05-27-08-26-04'/*!*/;
# at 498597
#100530 15:51:51 server id 1 end_log_pos 776707004 Query thread_id=1224434 exec_time=0 error_code=0
SET TIMESTAMP=1275249111/*!*/;
DELETE FROM locks WHERE HARDWARE_ID='8083' AND ID='1891'/*!*/;
# at 498723
#100530 15:51:51 server id 1 end_log_pos 776707031 Xid = 78112797
COMMIT/*!*/;
# at 498750
#100530 15:51:51 server id 1 end_log_pos 777201834 Query thread_id=1225686 exec_time=0 error_code=0

sebastienBillard · 2010-06-07 18:05:21

Personne?
Ceci es un tres gros probleme.

yllen · 2010-06-08 10:51:05

Pour moi il n'y a aucun problème. Il faut voir avec votre admin mysql afin qu'il désactive le query_log.

sebastienBillard · 2010-06-08 22:11:12

pas de probleme?
On avais Query_log pendant plus d'un ans sans problem, et query_log es pratique pour certaine de nos application. Vous trouvez q'une query at 15 mille ligne n'est pas up probleme?

remi · 2010-06-09 06:52:01

On n'active pas query_log sur un serveur en prod. C'est une bonne pratique.

De plus MySQL permet désormais de l'activer à chaud, et donc temporairement lorsqu'on en a besoin.

Oui, GLPI génère des requetes. C'est normal.
Donc non, il n'y a pas de problème.

+

Forum GLPI-Project

Announcement

#1 2010-06-02 22:47:14

Problem avec massimportocs

#2 2010-06-07 18:05:21

Re: Problem avec massimportocs

#3 2010-06-08 10:51:05

Re: Problem avec massimportocs

#4 2010-06-08 22:11:12

Re: Problem avec massimportocs

#5 2010-06-09 06:52:01

Re: Problem avec massimportocs

Board footer