Otdfbt

Crossword gone overboard

Is my router's IP address really public?

What does it mean when you think without speaking?

Restoring order in a deck of playing cards

What F1 in name of seeds/varieties means?

Ticket sales for Queen at the Live Aid

Glitch in AC sine wave interfering with phase cut dimming

What's the connection between "kicking a pigeon" and "how a bill becomes a law"?

Can a non-EU citizen travel within schengen zone freely without passport?

What is the difference between nullifying your vote and not going to vote at all?

Were pen cap holes designed to prevent death by suffocation if swallowed?

A Mathematical Discussion: Fill in the Blank

Why colon to denote that a value belongs to a type?

What is the 中 in ダウンロード中？

Uses of T extends U?

If a person had control of every single cell of their body, would they be able to transform into another creature?

Compact Mechanical Energy Source

Can a Beholder use rays in melee range?

Plot exactly N bounce of a ball

How do I remove these transparent pixels?

Comment dit-on « I’ll tell you what » ?

Apparent Ring of Craters on the Moon

What is the most important source of natural gas? coal, oil or other?

What is the best linguistic term for describing the kw > p / gw > b change, and its usual companion s > h

Perl script slower on other server compared to dev (with same spec)

Need Help getting perl module DBD::mysql installed for bugzilla on RedHatHow do I configure OS X's built-in Apache server to use FastCGI?How do I install Perl 5.8 and Perlfect on IIS 7.5?Perl module error on solaris-10Random Connections to MySQL refused (Error 111)Apache: Include Virtual SSI not working for CGI scriptPerl virtual environments?MySQL creds accepted from CLI but not from Perl DBIinstall_driver(mysql) failed: Unable to get DBI state function. DBI not loadederror while installing perl-Moose on red hat linux

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I'm trying to figure out why a Perl script I have, isn't performing anywhere near as well once I put it on the live server.

The whole script is identical on both servers (one is a test server, the other the live one). Both are running this version of Perl:

This is perl 5, version 22, subversion 1 (v5.22.1) built for x86_64-linux-gnu-thread-multi
(with 73 registered patches, see perl -V for more detail)

The dev server is running:

mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper

Whereas the live server is on a slightly different version:

mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

my.cnf files are the same on both servers. Could having such a smaller difference in mySQL versions cause the speed issues? Both servers are 8GB RAM,

The script has a lot of work to do (building static pages for a directory), and takes this long on each server:

• Dev server: 40 minutes


• Live server: 2 hours 20 minutes

As you can see, that's a whopping difference. Any suggestions on what else I could try?

Here is how htop looks on the live server when running the script:

and then on the dev server:

Doesn't seem to be much in it (or any swap being used)

ubuntu-16.04 perl mysql5.7

share|improve this question

edited May 15 at 7:29

Andrew Newby

asked May 15 at 6:27

Andrew NewbyAndrew Newby

345724

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Different data size in DB?
  
  – Cloud Ace
  May 15 at 6:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @CloudAce thanks. Its the exact same data, same table structure, same indexes. Really baffling me. The only difference is the dev server has a 2048mb swap, whereas live has 512mb swap - but from what I've read, that's not really even relevant with an 8Gb ram server?
  
  – Andrew Newby
  May 15 at 6:39
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Well, since this is the only difference, its worth to have a look, just to make sure.
  
  – Cloud Ace
  May 15 at 6:50
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Then maybe you should profile the script to see where cost time most
  
  – Cloud Ace
  May 15 at 7:36
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  For example, Devel::NYTProf, or you can just use plain print in your script to measure the execution time
  
  – Cloud Ace
  May 15 at 7:46
  

  
  
  
  

 | 
show 4 more comments

0

I'm trying to figure out why a Perl script I have, isn't performing anywhere near as well once I put it on the live server.

The whole script is identical on both servers (one is a test server, the other the live one). Both are running this version of Perl:

This is perl 5, version 22, subversion 1 (v5.22.1) built for x86_64-linux-gnu-thread-multi
(with 73 registered patches, see perl -V for more detail)

The dev server is running:

mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper

Whereas the live server is on a slightly different version:

mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

my.cnf files are the same on both servers. Could having such a smaller difference in mySQL versions cause the speed issues? Both servers are 8GB RAM,

The script has a lot of work to do (building static pages for a directory), and takes this long on each server:

• Dev server: 40 minutes


• Live server: 2 hours 20 minutes

As you can see, that's a whopping difference. Any suggestions on what else I could try?

Here is how htop looks on the live server when running the script:

and then on the dev server:

Doesn't seem to be much in it (or any swap being used)

ubuntu-16.04 perl mysql5.7

share|improve this question

edited May 15 at 7:29

Andrew Newby

asked May 15 at 6:27

Andrew NewbyAndrew Newby

345724

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Different data size in DB?
  
  – Cloud Ace
  May 15 at 6:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @CloudAce thanks. Its the exact same data, same table structure, same indexes. Really baffling me. The only difference is the dev server has a 2048mb swap, whereas live has 512mb swap - but from what I've read, that's not really even relevant with an 8Gb ram server?
  
  – Andrew Newby
  May 15 at 6:39
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Well, since this is the only difference, its worth to have a look, just to make sure.
  
  – Cloud Ace
  May 15 at 6:50
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Then maybe you should profile the script to see where cost time most
  
  – Cloud Ace
  May 15 at 7:36
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  For example, Devel::NYTProf, or you can just use plain print in your script to measure the execution time
  
  – Cloud Ace
  May 15 at 7:46
  

  
  
  
  

 | 
show 4 more comments

I'm trying to figure out why a Perl script I have, isn't performing anywhere near as well once I put it on the live server.

The whole script is identical on both servers (one is a test server, the other the live one). Both are running this version of Perl:

This is perl 5, version 22, subversion 1 (v5.22.1) built for x86_64-linux-gnu-thread-multi
(with 73 registered patches, see perl -V for more detail)

The dev server is running:

mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper

Whereas the live server is on a slightly different version:

mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

my.cnf files are the same on both servers. Could having such a smaller difference in mySQL versions cause the speed issues? Both servers are 8GB RAM,

The script has a lot of work to do (building static pages for a directory), and takes this long on each server:

• Dev server: 40 minutes


• Live server: 2 hours 20 minutes

As you can see, that's a whopping difference. Any suggestions on what else I could try?

Here is how htop looks on the live server when running the script:

and then on the dev server:

Doesn't seem to be much in it (or any swap being used)

ubuntu-16.04 perl mysql5.7

share|improve this question

edited May 15 at 7:29

Andrew Newby

asked May 15 at 6:27

Andrew NewbyAndrew Newby

345724

This is perl 5, version 22, subversion 1 (v5.22.1) built for x86_64-linux-gnu-thread-multi
(with 73 registered patches, see perl -V for more detail)

mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper

mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

share|improve this question

edited May 15 at 7:29

Andrew Newby

asked May 15 at 6:27

Andrew NewbyAndrew Newby

345724

share|improve this question

edited May 15 at 7:29

Andrew Newby

asked May 15 at 6:27

Andrew NewbyAndrew Newby

345724

asked May 15 at 6:27

Andrew NewbyAndrew Newby

345724

asked May 15 at 6:27

Andrew NewbyAndrew Newby

345724