4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: MrAndrew on January 22, 2015, 04:25:40 PM

Title: To much query time. I need help
Post by: MrAndrew on January 22, 2015, 04:25:40 PM

I cant understand, where is the problem. Below is log file of my requests

# Time: 141202  1:54:51
# User@Host: drandrew[drandrew] @ localhost [127.0.0.1]
# Thread_id: 6673171  Schema: drandrew  Last_errno: 1005  Killed: 1053
# Query_time: 191.102375  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Rows_read: 1
# Bytes_sent: 66  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
use drandrew;
SET timestamp=1417474491;
CREATE TABLE IF NOT EXISTS 5images_users_rating (
        field_id int(11) unsigned NOT NULL AUTO_INCREMENT,
        user_ids int(11) NOT NULL DEFAULT '0',
        other_user_id int(11) NOT NULL DEFAULT '0',
        rating_date int(11) NOT NULL DEFAULT '0',       
        rating_value int(2) NOT NULL DEFAULT '0',
        rating_count int(11) NOT NULL DEFAULT '0',
        PRIMARY KEY(field_id)
        ) TYPE=MyISAM;
# Time: 141202  1:54:51
# User@Host: drandrew[drandrew] @ localhost [127.0.0.1]
# Thread_id: 6673174  Schema: drandrew  Last_errno: 1005  Killed: 1053
# Query_time: 190.411156  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Rows_read: 1
# Bytes_sent: 66  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
SET timestamp=1417474491;
CREATE TABLE IF NOT EXISTS 5images_users_rating (
        field_id int(11) unsigned NOT NULL AUTO_INCREMENT,
        user_ids int(11) NOT NULL DEFAULT '0',
        other_user_id int(11) NOT NULL DEFAULT '0',
        rating_date int(11) NOT NULL DEFAULT '0',       
        rating_value int(2) NOT NULL DEFAULT '0',
        rating_count int(11) NOT NULL DEFAULT '0',
        PRIMARY KEY(field_id)
        ) TYPE=MyISAM;
# Time: 141202  1:54:51
# User@Host: drandrew[drandrew] @ localhost [127.0.0.1]
# Thread_id: 6673222  Schema: drandrew  Last_errno: 1005  Killed: 1053
# Query_time: 174.069439  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Rows_read: 1
# Bytes_sent: 66  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
use drandrew;
SET timestamp=1417474491;
CREATE TABLE IF NOT EXISTS 5images_users_rating (
        field_id int(11) unsigned NOT NULL AUTO_INCREMENT,
        user_ids int(11) NOT NULL DEFAULT '0',
        other_user_id int(11) NOT NULL DEFAULT '0',
        rating_date int(11) NOT NULL DEFAULT '0',       
        rating_value int(2) NOT NULL DEFAULT '0',
        rating_count int(11) NOT NULL DEFAULT '0',
        PRIMARY KEY(field_id)
        ) TYPE=MyISAM;
# Time: 141202  1:54:51
# User@Host: drandrew[drandrew] @ localhost [127.0.0.1]
# Thread_id: 6673259  Schema: drandrew  Last_errno: 1005  Killed: 0
# Query_time: 147.307311  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Rows_read: 1
# Bytes_sent: 66  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
use drandrew;
SET timestamp=1417474491;
CREATE TABLE IF NOT EXISTS 5images_users_rating (
        field_id int(11) unsigned NOT NULL AUTO_INCREMENT,
        user_ids int(11) NOT NULL DEFAULT '0',
        other_user_id int(11) NOT NULL DEFAULT '0',
        rating_date int(11) NOT NULL DEFAULT '0',       
        rating_value int(2) NOT NULL DEFAULT '0',
        rating_count int(11) NOT NULL DEFAULT '0',
        PRIMARY KEY(field_id)
        ) TYPE=MyISAM;

What does this process mean?

Title: Re: To much query time. I need help
Post by: Rembrandt on January 22, 2015, 05:07:49 PM

what do you want to do, in what context?

and replace "TYPE=MyISAM" with  "ENGINE=MyISAM"