Joomla Templates Club 406,261 posts

[violori Friend violoriJoin date: May 2015Posts: 42Downloads:11Uploads:5 Thanks: 3]

#911274

Hi,

I’ll try to keep this post short.

So, I’m writing because I have to big issues with the new template. I installed the JA Teline V theme back in December on my almost 11 years old website, but I have two issues that don’t go away.

1) MYSQL errors. I mean 2-3 a day. And I have to say I didn’t have these errors using the previous theme – simpler, true. I use the same server, I have the same load, same conditions as until December, but with the new theme I get the unable to connect to MYSQL errors way too often.
As far as I see from looking through the processes on the server, each time someone accesses my site, opens an article, or each time I upload a photo or do anything on the website, the database gets a new entry – aka MYSQL process. I don’t have many visitors per day – max 1000, usually 400-600, so it’s not from that, but I didn’t had this huge load of MYSQP processes with the old theme.

How can I optimize it?

As a side note, I stopped the counter of each article – so I don’t have a number of hits, but I thought this could help with the processes. It doesn’t.
2) LOAD.
The site takes forever to load. And, I repeat, I have the same content… just a different design. And this load leads to unhappy visitors and issues with Google…

Again, how can I optimize this?

I really like the theme, but I also really hate these two issues…

The domain is http://www.prwave.ro

Thanks for the help,
Loredana

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#912133

Hi,

I checked the URL of your site and it’s very slow at my end. I debugged it further but I could not see the MySQL problem.

From the view-source code, I see the duplicated Facebook script as my screenshot

(function(d){
                      var js, id = 'facebook-jssdk'; if (d.getElementById(id)) {return;}
                      js = d.createElement('script'); js.id = id; js.async = true;
                      js.src = '//connect.facebook.net/en_US/all.js#xfbml=1';
                      d.getElementsByTagName('head')[0].appendChild(js);
                    }(document));

Besides that, you need to check the configuration from template manager on your site and make sure it sets like my screenshot

Regards

---

Attachments:

1. 
2. 

[violori Friend violoriJoin date: May 2015Posts: 42Downloads:11Uploads:5 Thanks: 3]

#916753

Hi,

I have the MySQL error now 🙁 _

[violori Friend violoriJoin date: May 2015Posts: 42Downloads:11Uploads:5 Thanks: 3]

#916754

PS: photo attached

---

Attachments:

1. 

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#917329

In this case, you need to check it from configuration.php file with these parameters for example:

public $host = 'localhost';
public $user = 'root';
public $password = 'root';
public $db = 'teline_v';
public $dbprefix = 'nt1qe_';

and make sure it can connect as well with the database of your hosting

[violori Friend violoriJoin date: May 2015Posts: 42Downloads:11Uploads:5 Thanks: 3]

#920039

Hi,

I think I didn’t make myself very clear. The site is up and running – so the parameters you suggested are as they should.

The problem is, that in what the MySQL is concerned, the acceptable load is around 0.4-0.6 – while after an hour – TOPS – the MySQL load increases to 1,7-2,7 – at which moment it block my server completely…

So, again, what can I do to optimise this – like I said, it look like ANY and all actions, no matter how small – a simple visit on the homepage – leads to numerous MySQL processes that eventually crush my server.

Again, this is the same server (actually with more memory and bigger hard drives) as in December – until I had the previous theme and no such problem.

it’s inadmissible to have to restart the MySQL or httpd processes every hour or so – as I said, I am sure that there are things that can be optimized.

Also, the load issue of the website is not from the Facebook code that appears twice…

If you want to see the admin part, I can always provide an user and a password. But it’s all according to your settings – we didn’t modify anything – and yet there are constant issues.

i don’t want to give up this theme, I really like it… but how can I stop having these MySQL issues – so many processes….

Thank you,
Loredana

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#920924

Maybe your request regards the SQL Optimize for Joomla, you can have a look at the link here some comments below have the solution about this.

[Author]

Posts