MySQL Forums
Forum List  »  German

mysql schuftet sich zu tode
Posted by: Reinhold Klein
Date: June 12, 2009 03:22AM

Hallo,
ich habe hier ein Select das von mysql korrekt abgearbeitet wird. Vorausgesetzt, in der Tabelle stehen nicht mehr als drei Records. Ab vier Records dreht der Server durch und ist nur noch am Schuften. Prozessorauslastung 100% durch den mysql-server. Ich benutze "mysql-5.1.26-rc-win32" unter Win-XP. Bin dankbar für alle Tips.
tschüß
Reinhold

hier ist das Selectstatement:

select t1.property_qwidget_key, t1.context_menu_policy_q_enum_key, t1.focus_policy_q_enum_key, t1.layout_direction_q_enum_key, t1.sizepolicy_q_sizepolicy_key, t1.window_type_q_enum_key, t1.window_modality_q_enum_key, t1.status_tip_strings_key, t1.tool_tip_strings_key, t1.whats_this_strings_key, t1.window_file_path_strings_key, t1.window_icon_text_strings_key, t1.window_title_strings_key, t1.property_sql_field_key, t1.geometry_q_geometry_key, t1.min_max_q_min_max_key, t1.dialog_name, t1.col, t1.e_widget_type, t1.accept_drops, t1.accessible_description, t1.accessible_name, t1.auto_fill_background, t1.enabled, t1.mouse_tracking, t1.visible, t1.window_icon, t1.window_opacity,
t3.string,
t4.string,
t5.string,
t7.string,
t8.string,
t9.string,
t11.string,
t12.string,
t13.string,
t14.policy_name,
t16.string,
t17.string,
t18.string,
t20.string,
t21.string,
t22.string,
t23.string,
t24.string,
t25.string,
t26.string,
t27.string,
t28.string,
t30.string,
t32.qt_type_key,
t32.qt_type_name,
t31.sql_create,
t31.default_value_sql,
t29.unique_index,
t29.sql_field_name,
t34.x,
t34.y,
t34.width,
t34.height,
t33.geometry_name,
t35.min_max_name

from property_qwidget as t1,
q_enum as t2,
stringslang as t3,
stringslang as t4,
stringslang as t5,
q_enum as t6,
stringslang as t7,
stringslang as t8,
stringslang as t9,
q_enum as t10,
stringslang as t11,
stringslang as t12,
stringslang as t13,
q_sizepolicy as t14,
q_enum as t15,
stringslang as t16,
stringslang as t17,
stringslang as t18,
q_enum as t19,
stringslang as t20,
stringslang as t21,
stringslang as t22,
stringslang as t23,
stringslang as t24,
stringslang as t25,
stringslang as t26,
stringslang as t27,
stringslang as t28,
sql_field as t29,
stringslang as t30,
qt_sql_type as t31,
qt_type as t32,
q_geometry as t33,
q_rect as t34,
q_min_max as t35

where t1.property_qwidget_key > 1
and t1.context_menu_policy_q_enum_key = t2.q_enum_key
and t2.qt_name_strings_key = t3.stringslang_key
and t2.enum_type_strings_key = t4.stringslang_key
and t2.enum_name_strings_key = t5.stringslang_key
and t1.focus_policy_q_enum_key = t6.q_enum_key
and t6.qt_name_strings_key = t7.stringslang_key
and t6.enum_type_strings_key = t8.stringslang_key
and t6.enum_name_strings_key = t9.stringslang_key
and t1.layout_direction_q_enum_key = t10.q_enum_key
and t10.qt_name_strings_key = t11.stringslang_key
and t10.enum_type_strings_key = t12.stringslang_key
and t10.enum_name_strings_key = t13.stringslang_key
and t1.sizepolicy_q_sizepolicy_key = t14.q_sizepolicy_key
and t1.window_type_q_enum_key = t15.q_enum_key
and t15.qt_name_strings_key = t16.stringslang_key
and t15.enum_type_strings_key = t17.stringslang_key
and t15.enum_name_strings_key = t18.stringslang_key
and t1.window_modality_q_enum_key = t19.q_enum_key
and t19.qt_name_strings_key = t20.stringslang_key
and t19.enum_type_strings_key = t21.stringslang_key
and t19.enum_name_strings_key = t22.stringslang_key
and t1.status_tip_strings_key = t23.stringslang_key
and t1.tool_tip_strings_key = t24.stringslang_key
and t1.whats_this_strings_key = t25.stringslang_key
and t1.window_file_path_strings_key = t26.stringslang_key
and t1.window_icon_text_strings_key = t27.stringslang_key
and t1.window_title_strings_key = t28.stringslang_key
and t1.property_sql_field_key = t29.sql_field_key
and t29.type_strings_key = t30.stringslang_key
and t29.qt_sql_type_key = t31.qt_sql_type_key
and t31.qt_type_key = t32.qt_type_key
and t1.geometry_q_geometry_key = t33.q_geometry_key
and t33.geometry_q_rect_key = t34.q_rect_key
and t1.min_max_q_min_max_key = t35.q_min_max_key

order by t1.property_qwidget_key asc
limit 1

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql schuftet sich zu tode
2479
June 12, 2009 03:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.