Hello. I have long been troubled and I do not know where I can go and need help. I've been 3 months with the stable system, but has become a destabilizing.
They are more than 20 state querys "SLEEP" in MySQL. The more I see left is one that accesses the table "objectdata_attributes."
I thought it was for l ouch happened to me last time, related to the version of Smarty (2.6.26 ate with all the resources and we had to Smarty version 2.6.25)
This is the list of active modules in the system:
Nombre interno Nombre público Versión
AboutMe AboutMe 1.1
Admin Gestor del panel de administración 1.8
Admin_Messages Gestor de mensajes de administrador 2.2
advanced_polls Advanced Polls 2.0.0
AuthPN Gestor de autenticación 1.1
Avatar Avatar 2.2
bbcode Hook de bbcode 2.1
bbsmile BBSmile Hook 2.2
Blocks Gestor de bloques 3.6
Categories Administrador de categorías 1.1
Communicator Communicator 1.0.4
content Content editing 3.2.0
Dizkus Foros Dizkus 3.1
dpkarma dpkarma 1.3
Ephemerids Ephemerids 1.9
Errors Registrador de errores 1.1
Eternizer Libro de Visitas 1.1.1
EZComments Comments 2.0.0
FAQ FAQ 2.3.1
Files Gestor de Archivos 1.1
Formicula Formicula 2.2
Groups Gestor de grupos 2.3
Header_Footer Controlador del encabezado y pie de página 1.1
ifs ifs 1.0
Invitation Invitation 2.1
legal Legal info manager 1.3
Mailer Administrador de correos 1.3
menutree Menutree 2.3
Modules Administrador de módulos 3.6
myProfile myProfile 2.3
News Editor de noticias 2.6.2
Newsletter Boletín 2.1.0
ObjectData Soporte de atributos 1.03
Pages Páginas estáticas 2.4.1
Permissions Gestor de permisos 1.1
pnCPG pnCPG 5.01
pnForm Soporte de formularios 1.1
pnRender Motor de plantillas 1.1
PostCalendar PostCalendar 6.2.0
Profile Gestor de perfiles 1.5.2
Quotes Quotes 2.5
Ratings Puntuaciones 2.2
scribite scribite! 4.1
Search Motor de búsqueda del sitio 1.5
SecurityCenter Centro de seguridad 1.3
Settings Configuración general 2.9.1
Sitemap Mapa del sitio 1.2
Sniffer Sniffer 1.2
spamFree spamFree 0.1a
StaffStatus StaffStatus 2.2
SysInfo Panel de información del sistema 1.1
Theme Administrador de themes 3.3
Thumbnail Miniaturas 1.2.1
UserDeletion UserDeletion 1.0
Users Gestor de usuarios 1.13
Web_Links Weblinks 2.0
WELCOME WELCOME 0.3
Workflow Soporte de workflows 1.1
The server configuration you can see here: http://www.delosduendeszahories.com/_phpinfo.php
This is the listing for a "show processlist;" in mysql:
mysql> show processlist;
+--------+----------------------+-----------------+--------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | DB | Command | Time | State | Info |
+--------+----------------------+-----------------+--------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 189247 | incasas_dldz | localhost | incasas_dldz | Sleep | 1 | | NULL |
| 189254 | incasas_dldz | localhost | incasas_dldz | Sleep | 2 | | NULL |
| 189257 | root | localhost | NULL | Query | 0 | NULL | show processlist |
| 189281 | incasas_dldz | localhost | incasas_dldz | Sleep | 5 | | NULL |
| 189296 | incasas_dldz | localhost | incasas_dldz | Sleep | 5 | | NULL |
| 189312 | incasas_dldz | localhost | incasas_dldz | Sleep | 4 | | NULL |
| 189326 | incasas_dldz | localhost | incasas_dldz | Sleep | 1 | | NULL |
| 189336 | incasas_dldz | localhost | incasas_dldz | Query | 0 | Sending data | SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object |
| 189337 | incasas_dldz | localhost | incasas_dldz | Query | 0 | Sending data | SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object |
| 189338 | incasas_dldz | localhost | incasas_dldz | Query | 0 | Writing to net | SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object |
| 189339 | incasas_dldz | localhost | incasas_dldz | Query | 0 | Sending data | SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object |
| 189340 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL |
| 189341 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL |
| 189342 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL |
| 189343 | incasas_dldz | localhost | incasas_dldz | Sleep | 1 | | NULL |
| 189344 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL |
+--------+----------------------+-----------------+--------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
16 rows in set (0.00 sec)
This is a list of the processes listed in "top":
[root@incasas ~]# top
top - 11:05:46 up 11:49, 2 users, load average: 21.33, 21.21, 19.89
Tasks: 170 total, 14 running, 155 sleeping, 0 stopped, 1 zombie
Cpu(s): 54.1%us, 45.6%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.3%st
Mem: 2047372k total, 1445664k used, 601708k free, 220308k buffers
Swap: 2097144k total, 1876k used, 2095268k free, 415304k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
22194 incasas 20 0 272m 28m 5876 R 18.5 1.5 0:01.08 PHP-cgi
22209 incasas 20 0 270m 26m 5728 R 17.6 1.3 0:01.43 PHP-cgi
22062 incasas 20 0 271m 27m 5804 S 8.6 1.4 0:02.30 PHP-cgi
22191 incasas 20 0 272m 29m 5876 R 8.3 1.5 0:01.09 PHP-cgi
22237 incasas 20 0 269m 26m 5724 R 7.6 1.3 0:00.98 PHP-cgi
22091 incasas 20 0 271m 27m 5728 R 7.3 1.4 0:02.11 PHP-cgi
22188 incasas 20 0 270m 26m 5808 R 7.3 1.4 0:00.80 PHP-cgi
22193 incasas 20 0 269m 26m 5724 R 7.3 1.3 0:01.12 PHP-cgi
22063 incasas 20 0 271m 28m 5812 S 7.0 1.4 0:02.28 PHP-cgi
22187 incasas 20 0 272m 29m 5896 S 7.0 1.5 0:01.13 PHP-cgi
22197 incasas 20 0 271m 28m 5868 R 6.6 1.4 0:01.05 PHP-cgi
22229 incasas 20 0 272m 29m 5900 R 6.6 1.5 0:00.96 PHP-cgi
22066 incasas 20 0 272m 28m 5844 S 6.3 1.4 0:01.90 PHP-cgi
22195 incasas 20 0 271m 28m 5844 S 6.0 1.4 0:01.02 PHP-cgi
22196 incasas 20 0 272m 29m 5896 S 6.0 1.5 0:01.13 PHP-cgi
22330 incasas 20 0 262m 19m 5592 R 4.6 1.0 0:00.14 PHP-cgi
22340 incasas 20 0 164m 15m 5020 R 2.6 0.8 0:00.08 PHP-cgi
If you look sleep MySQL coincide with those that remain open in PHP-cgi
Edited by incasas on Oct 14, 2011 - 05:29 PM.
Watch
GitHub Core
Show your support for Zikula! Sign up at Github account and watch the Core project!
GitHub Modules
Forum Activity
- rgasch created topic »Using PageUtil::addVar() to load script code« 11:48 AM
- michiel responded to »password problem« 10:01 AM
- mazdev responded to »Hide "Register new account" and change template to 3 col« 07:50 AM
- mesteele101 created topic »Zikula 1.3.3 - Site Search 1.5.2 - Unable to turn off plug-ins« 07:48 AM
- mesteele101 responded to »ERR (3): E_USER_ERROR: Smarty error: [in pagesvar:pagesitem2en line XXX]…« 25. May
- mazdev responded to »Pages 2.5.0 and updating - Page not found« 25. May
- mesteele101 responded to »Zikula 1.3.3 - Selecting a category in Pages not working« 25. May
Zikula Blog
- Anatomy of Open Source Projects on Mar 07
- Continuous Review on Mar 01
- Not Invented Here on Feb 24
- How to Contribute Your Code at Github on Jan 13
- 10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
- Submitting Bug Report Tickets That Get Results on Aug 17
- Cozi Tricks #1: Syntax Highlighting on Aug 07
Login
Multiple querys without closing
-
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 14, 2011 - 05:19 PM
-
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 14, 2011 - 11:23 PM
I need help urgently... If I fix this server is fallen and I can serve my clients -
- Rank: Team Member
- Registered: Jan 05, 2003
- Last visit: May 28, 2010
- Posts: 776
Posted: Oct 16, 2011 - 12:14 AM
Quote
They are more than 20 state querys "SLEEP" in MySQL. The more I see left is one that accesses the table "objectdata_attributes."
This should not be happening. An easy way to disable this behaviour is to disable the attribution flag for the categories_category table in system/Categories/pntables.php. However, before you do this, make sure that you're not using any object attributes on the category tables. Per default this is not the case (I think, actually I'm pretty sure) so if you haven't added something which uses this feature, it should be safe to turn this flag off.
Greetings
Robert -
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 17, 2011 - 12:18 AM
I don't Understand... My english is very bad :( -
- Rank: Software Foundation
- Registered: Jul 21, 2001
- Last visit: May 31, 2010
- Posts: 624
Posted: Oct 17, 2011 - 01:22 AM
Simply turn off persistent mysql connections, there is no reason to use them.
Drak
--
Zikula Lead Developer
Board Member of the Zikula Foundation
Follow me on twitter.com/zikuladrak -
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 17, 2011 - 02:26 AM
Thanks. Try telling me to do and shows you the results. -
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 17, 2011 - 04:32 AM
Hello.
It leaves open connections, but there is still excessive CPU consumption ... Set in the data that you step below:
top - 22:24:20 up 1:12, 1 user, load average: 6.45, 4.67, 4.83
Tasks: 147 total, 9 running, 138 sleeping, 0 stopped, 0 zombie
Cpu(s): 63.1%us, 36.1%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.2%si, 0.7%st
Mem: 2047372k total, 715428k used, 1331944k free, 35676k buffers
Swap: 2097144k total, 0k used, 2097144k free, 163772k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1802 incasas 20 0 271m 28m 5820 R 21.9 1.4 0:02.10 PHP-cgi
29243 mysql 20 0 1305m 51m 6176 S 21.9 2.6 5124871h mysqld
1728 incasas 20 0 272m 28m 5820 R 19.6 1.4 0:02.77 PHP-cgi
1897 incasas 20 0 269m 26m 5752 R 18.9 1.3 0:00.57 PHP-cgi
1851 incasas 20 0 270m 27m 5796 R 15.2 1.4 0:01.00 PHP-cgi
1876 incasas 20 0 270m 26m 5760 S 15.2 1.3 0:00.89 PHP-cgi
1846 incasas 20 0 270m 26m 5776 R 14.9 1.3 0:00.88 PHP-cgi
1874 incasas 20 0 271m 28m 5844 R 14.9 1.4 0:00.97 PHP-cgi
1908 incasas 20 0 267m 23m 5720 S 10.3 1.2 0:00.31 PHP-cgi
1912 incasas 20 0 266m 23m 5720 R 8.3 1.2 0:00.25 PHP-cgi
1911 incasas 20 0 268m 24m 5712 R 8.0 1.2 0:00.24 PHP-cgi
943 apache 20 0 60836 4120 1580 S 0.3 0.2 0:00.04 httpd
29552 root 20 0 14932 1308 960 R 0.3 0.1 0:01.61 top
1 root 20 0 19112 1432 1180 S 0.0 0.1 0:00.22 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
3 root RT 0 0 0 0 S 0.0 0.0 0:00.02 migration/0
4 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0 -
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 20, 2011 - 12:05 PM
Hello again ... Reboot the VPS and consumption soar to unimaginable heights ... This is an example where you can see how in 6 hours all consumption skyrocket.
top - 05:54:52 up 6:10, 1 user, load average: 33.10, 32.35, 33.04
Tasks: 189 total, 29 running, 160 sleeping, 0 stopped, 0 zombie
Cpu(s): 49.0%us, 50.5%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.5%st
Mem: 2047372k total, 1362348k used, 685024k free, 109852k buffers
Swap: 2097144k total, 5080k used, 2092064k free, 136516k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
22648 incasas 20 0 269m 26m 5720 R 6.5 1.3 0:00.71 PHP-cgi
22683 incasas 20 0 270m 26m 5728 R 6.5 1.3 0:00.61 PHP-cgi
22567 incasas 20 0 271m 27m 5748 R 6.2 1.4 0:01.92 PHP-cgi
22632 incasas 20 0 269m 26m 5724 R 6.2 1.3 0:00.80 PHP-cgi
22638 incasas 20 0 269m 26m 5752 R 6.2 1.3 0:00.65 PHP-cgi
22639 incasas 20 0 269m 26m 5724 R 6.2 1.3 0:00.71 PHP-cgi
22646 incasas 20 0 269m 26m 5724 R 6.2 1.3 0:00.75 PHP-cgi
22660 incasas 20 0 269m 26m 5744 R 6.2 1.3 0:00.63 PHP-cgi
22695 incasas 20 0 268m 25m 5716 R 6.2 1.3 0:00.29 PHP-cgi
22542 incasas 20 0 270m 27m 5752 R 5.8 1.4 0:02.07 PHP-cgi
22545 incasas 20 0 271m 27m 5736 R 5.8 1.4 0:02.05 PHP-cgi
22633 incasas 20 0 269m 26m 5796 R 5.8 1.3 0:00.74 PHP-cgi
22635 incasas 20 0 269m 26m 5724 R 5.8 1.3 0:00.65 PHP-cgi
22636 incasas 20 0 271m 27m 5760 S 5.8 1.4 0:00.73 PHP-cgi
22435 incasas 20 0 272m 28m 5816 R 5.5 1.4 0:03.04 PHP-cgi
22640 incasas 20 0 271m 27m 5756 S 5.5 1.4 0:00.75 PHP-cgi
22647 incasas 20 0 271m 27m 5760 R 5.5 1.4 0:00.74 PHP-cgi
Do not know where to go. People who manage the hosting insist that there is a script that does not work properly and it consumes far more resources and that the more you give more resources and accounts for free, but do not know where I can go. Can you give me some indication please? I need help urgently... Please help me us... -
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 26, 2011 - 11:52 AM
I need help urgently... I've done everything you have given me and I have not managed to find a marked improvement. In fact, I have to reset the entire VPS every 12 hours. Is overloaded over each CPU and server load never falls below 12, when it should be around 3. Please, if someone comes up with some alternative solution would be greatly appreciated. -
- Rank: Registered User
- Registered: Mar 06, 2011
- Last visit:
- Posts: 37
Posted: Oct 26, 2011 - 01:10 PM
Quote
If you look sleep MySQL coincide with those that remain open in PHP-cgi
If this is true, there's something wrong with your server, you could lower the time-outs for sleeping. but if it's category-attributes like your mysql list seems to indicate, you could could first try the possible solution rgasch mentioned. In system/categories/pntables.php around line 41 you can set
Code
$pntable['categories_category_db_extra_enable_attribution'] = true;
to false or did you do that already? -
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 26, 2011 - 06:51 PM
Hello.
I just put the value that you indicated to me a false in that file.
After that, I completely restarted the virtual machine.
Should I make any intervention other than the indicated? -
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 26, 2011 - 06:55 PM
top - 12:46:27 up 4 min, 1 user, load average: 8.12, 4.67, 1.92
Tasks: 141 total, 8 running, 133 sleeping, 0 stopped, 0 zombie
Cpu(s): 50.1%us, 49.6%sy, 0.0%ni, 0.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.2%st
Mem: 2047372k total, 633844k used, 1413528k free, 8788k buffers
Swap: 2097144k total, 0k used, 2097144k free, 149584k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3945 incasas 20 0 270m 26m 5728 R 32.9 1.3 0:01.18 PHP-cgi
3956 incasas 20 0 272m 29m 5976 R 27.2 1.5 0:00.90 PHP-cgi
3918 incasas 20 0 272m 27m 5816 R 21.6 1.4 0:02.00 PHP-cgi
3943 incasas 20 0 273m 30m 5816 S 20.9 1.5 0:00.96 PHP-cgi
3936 incasas 20 0 269m 26m 5724 R 19.2 1.3 0:01.06 PHP-cgi
3930 incasas 20 0 271m 27m 5812 R 18.3 1.4 0:01.58 PHP-cgi
3969 incasas 20 0 266m 23m 5720 R 7.3 1.2 0:00.22 PHP-cgi -
- Rank: Registered User
- Registered: Mar 06, 2011
- Last visit:
- Posts: 37
Posted: Oct 26, 2011 - 09:24 PM
Didn;t do any good I see. Im wonderig if something else might be wrong as no-one else is reporting these problems. You could try to disable modules one-by-one to see the effect. Also I would certainly check and repair all your mysql-tables.
http://dev.mysql.com…n/repair-table.html -
- Rank: Registered User
- Registered: Dec 05, 2005
- Last visit: May 01, 2006
- Posts: 37
Posted: Oct 27, 2011 - 12:09 AM
On repairing MySQL tables, I have a crontab that runs every 12 hours.
Code
<?php
$hostname="localhost";
$username="myuser";
$password="mypass";
mysql_connect($hostname, $username, $password);
$db_select = 'SHOW DATABASES';
$db_result = mysql_query($db_select);
while ($db_row = mysql_fetch_array($db_result)) {
if (mysql_select_db($db_row[0])) {
$tbl_status = 'SHOW TABLE STATUS FROM ' . $db_row[0];
$tbl_result = mysql_query($tbl_status);
if(mysql_num_rows($tbl_result)) {
while ($tbl_row = mysql_fetch_array($tbl_result)) {
$opt_table = 'REPAIR TABLE ' . $tbl_row[0];
$opt_result = mysql_query($opt_table);
$opt_table = 'OPTIMIZE TABLE ' . $tbl_row[0];
$opt_result = mysql_query($opt_table);
}
} else {
}
}
}
?>
Try to disable the modules, but this is something that happens to me since version 1.2.4 came out. prior to this release I've never had this kind of incidents.
I had always solved leaving Smarty version 2.6.25, which is what I have now, but no way to solve this.
I think the great likelihood that the error is generated, may be due to the version of PostCalendar, but I tried to disable this and there is no improvement.
It also blamed the source of the problem and have coppermine photo gallery, but this is always current.
- Moderated by:
- Support
Users on-line
- 0 users
This list is based on users active over the last 60 minutes.
