php - MySQL number of threads_connected slow down my website -

-

i have store running on prestashop 1.5.4. keep having problem site behaviour.

everytime check number

user@server:~$ mysql -se "show status '%threads_connected%'"

if number gets above 25, site becomes slow. opening page takes forever , page load can high 1 - 2 minutes.

the solution (temporary) me restart apache services.

i pretty sure 25 pretty low number.

in case need know, don't have direct access my.ini nor access mysql server configuration. database stored in shared (dbass).

i have full access webserver (apache2.conf, php.ini, www.example.com.conf)

a little info might help:

-se "show variables '%max%'"

outputs:

image 1 image 2

i guess question how can improve performance ? can improve limiting number of "threads_connected" ?

footnote:

i aware there bad query somewhere in code, however, @ moment need quick solution this. reviewing queries can take time.

edit #1

perhaps information might give ideas

php.ini php.ini

edit #2 apache2.conf

can improve limiting number of "threads_connected"?

absolutely not.

all limiting number of connections cause errors users of site, because particular apache process wouldn't able connect database.

the problem not number of threads connected. symptom of real problem, have 1 or more queries perform poorly, or not have enough memory for apache scale up when traffic gets heavy, forcing machine heavily swapping, , thereby slowing down apache point keeps connections open longer.

i need quick solution this

sorry... there isn't solution other find actual problem , fix it.

more useful number of connections what these connections doing right now?

show full processlist; in mysql answer question. if sleeping, aren't hurting on mysql side, , may want limit number of apache processes, if side effect of level of site traffic, server may small, or may need disable http keepalive, or tweak timeout, if browser connections holding open apache children idle, consuming memory.


Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more