Difference between revisions of "Server working very slowly"

From Kolmisoft Wiki
Jump to navigationJump to search
 
Line 75: Line 75:


   ALTER TABLE `calls` ENGINE = innodb;  
   ALTER TABLE `calls` ENGINE = innodb;  
To complete this query your server will need some time, from several minutes to several hours, depends on database side and hardware.
To complete this query your server will need some time, from several minutes to several hours, depends on database size and hardware.

Latest revision as of 15:09, 25 March 2010

Maybe table types are MyISAM, not innodb ? If so, run this on your MOR database when you don't have any active calls:

 ALTER TABLE `actions` ENGINE = innodb;
 ALTER TABLE `activecalls` ENGINE = innodb;
 ALTER TABLE `acustratedetails` ENGINE = innodb;
 ALTER TABLE `adactions` ENGINE = innodb;
 ALTER TABLE `addresses` ENGINE = innodb;
 ALTER TABLE `adnumbers` ENGINE = innodb;
 ALTER TABLE `aratedetails` ENGINE = innodb;
 ALTER TABLE `c2c_calls` ENGINE = innodb;
 ALTER TABLE `c2c_campaigns` ENGINE = innodb;
 ALTER TABLE `c2c_comments` ENGINE = innodb;
 ALTER TABLE `c2c_commfields` ENGINE = innodb;
 ALTER TABLE `callerids` ENGINE = innodb;
 ALTER TABLE `callflows` ENGINE = innodb;
 ALTER TABLE `campaigns` ENGINE = innodb;
 ALTER TABLE `cardgroups` ENGINE = innodb;
 ALTER TABLE `cards` ENGINE = innodb;
 ALTER TABLE `cclineitems` ENGINE = innodb;
 ALTER TABLE `ccorders` ENGINE = innodb;
 ALTER TABLE `cdr` ENGINE = innodb;
 ALTER TABLE `codecs` ENGINE = innodb;
 ALTER TABLE `conflines` ENGINE = innodb;
 ALTER TABLE `currencies` ENGINE = innodb;
 ALTER TABLE `customrates` ENGINE = innodb;
 ALTER TABLE `days` ENGINE = innodb;
 ALTER TABLE `destinationgroups` ENGINE = innodb;
 ALTER TABLE `destinations` ENGINE = innodb;
 ALTER TABLE `devicecodecs` ENGINE = innodb;
 ALTER TABLE `devicegroups` ENGINE = innodb;
 ALTER TABLE `devices` ENGINE = innodb;
 ALTER TABLE `devicetypes` ENGINE = innodb;
 ALTER TABLE `dialplans` ENGINE = innodb;
 ALTER TABLE `didrates` ENGINE = innodb;
 ALTER TABLE `dids` ENGINE = innodb;
 ALTER TABLE `directions` ENGINE = innodb;
 ALTER TABLE `emails` ENGINE = innodb;
 ALTER TABLE `extlines` ENGINE = innodb;
 ALTER TABLE `groups` ENGINE = innodb;
 ALTER TABLE `hangupcausecodes` ENGINE = innodb;
 ALTER TABLE `invoicedetails` ENGINE = innodb;
 ALTER TABLE `invoices` ENGINE = innodb;
 ALTER TABLE `iplocations` ENGINE = innodb;
 ALTER TABLE `lcrproviders` ENGINE = innodb;
 ALTER TABLE `lcrs` ENGINE = innodb;
 ALTER TABLE `locationrules` ENGINE = innodb;
 ALTER TABLE `locations` ENGINE = innodb;
 ALTER TABLE `payments` ENGINE = innodb;
 ALTER TABLE `pbxfunctions` ENGINE = innodb;
 ALTER TABLE `pdffaxemails` ENGINE = innodb;
 ALTER TABLE `pdffaxes` ENGINE = innodb;
 ALTER TABLE `phonebooks` ENGINE = innodb;
 ALTER TABLE `providercodecs` ENGINE = innodb;
 ALTER TABLE `providerrules` ENGINE = innodb;
 ALTER TABLE `providers` ENGINE = innodb;
 ALTER TABLE `providertypes` ENGINE = innodb;
 ALTER TABLE `quickforwarddids` ENGINE = innodb;
 ALTER TABLE `ratedetails` ENGINE = innodb;
 ALTER TABLE `rates` ENGINE = innodb;
 ALTER TABLE `recordings` ENGINE = innodb;
 ALTER TABLE `rights` ENGINE = innodb;
 ALTER TABLE `role_rights` ENGINE = innodb;
 ALTER TABLE `roles` ENGINE = innodb;
 ALTER TABLE `serverproviders` ENGINE = innodb;
 ALTER TABLE `servers` ENGINE = innodb;
 ALTER TABLE `services` ENGINE = innodb;
 ALTER TABLE `sessions` ENGINE = innodb;
 ALTER TABLE `subscriptions` ENGINE = innodb;
 ALTER TABLE `tariffs` ENGINE = innodb;
 ALTER TABLE `translations` ENGINE = innodb;
 ALTER TABLE `usergroups` ENGINE = innodb;
 ALTER TABLE `users` ENGINE = innodb;
 ALTER TABLE `voicemail_boxes` ENGINE = innodb;
 ALTER TABLE `vouchers` ENGINE = innodb;
 ALTER TABLE `calls` ENGINE = innodb; 

To complete this query your server will need some time, from several minutes to several hours, depends on database size and hardware.