|
|||||||
|
|
|
 |
|
|
Strumenti |
19-10-2006, 16:16
|
#1 |
|
Senior Member
Iscritto dal: Jul 2002
Città: Padova
Messaggi: 4245
|
Un aiuto su mysql.........
Ciao a tutti, ieri a causa di un corto circuito generato dal guasto dello switch di rete, si è spento il gruppo di continuità e tutto quello che ci andava dietro, compreso il server linux.
Oggi guardando i messaggi indirizzati all'admin del server ho trovato questo: Codice:
zencart.address_book warning : 1 client is using or hasn't closed the table properly zencart.address_format warning : 1 client is using or hasn't closed the table properly zencart.admin warning : 1 client is using or hasn't closed the table properly zencart.admin_activity_log warning : 1 client is using or hasn't closed the table properly zencart.banners warning : 1 client is using or hasn't closed the table properly zencart.banners_history warning : 1 client is using or hasn't closed the table properly zencart.categories warning : 1 client is using or hasn't closed the table properly zencart.categories_description warning : 1 client is using or hasn't closed the table properly zencart.configuration warning : 1 client is using or hasn't closed the table properly zencart.configuration_group warning : 1 client is using or hasn't closed the table properly zencart.counter warning : 1 client is using or hasn't closed the table properly zencart.counter_history warning : 1 client is using or hasn't closed the table properly zencart.countries warning : 1 client is using or hasn't closed the table properly zencart.customers warning : 1 client is using or hasn't closed the table properly zencart.customers_basket warning : 1 client is using or hasn't closed the table properly zencart.customers_info warning : 1 client is using or hasn't closed the table properly zencart.geo_zones warning : 1 client is using or hasn't closed the table properly zencart.layout_boxes warning : 1 client is using or hasn't closed the table properly zencart.manufacturers warning : 1 client is using or hasn't closed the table properly zencart.manufacturers_info warning : 1 client is using or hasn't closed the table properly zencart.orders warning : 1 client is using or hasn't closed the table properly zencart.orders_products warning : 1 client is using or hasn't closed the table properly zencart.orders_status warning : 1 client is using or hasn't closed the table properly zencart.orders_status_history warning : 1 client is using or hasn't closed the table properly zencart.orders_total warning : 1 client is using or hasn't closed the table properly zencart.product_type_layout warning : 1 client is using or hasn't closed the table properly zencart.product_types warning : 1 client is using or hasn't closed the table properly zencart.products warning : 1 client is using or hasn't closed the table properly zencart.products_description warning : 1 client is using or hasn't closed the table properly zencart.products_notifications warning : 1 client is using or hasn't closed the table properly zencart.products_to_categories warning : 1 client is using or hasn't closed the table properly zencart.sessions warning : 1 client is using or hasn't closed the table properly zencart.tax_class warning : 1 client is using or hasn't closed the table properly zencart.tax_rates warning : 1 client is using or hasn't closed the table properly zencart.whos_online warning : 1 client is using or hasn't closed the table properly zencart.zones warning : 1 client is using or hasn't closed the table properly zencart.zones_to_geo_zones warning : 1 client is using or hasn't closed the table properly Improperly closed tables are also reported if clients are accessing the tables *now*. A list of current connections is below. +----+------------------+-----------+----+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------------------+-----------+----+---------+------+-------+------------------+ | 5 | debian-sys-maint | localhost | | Query | 0 | | show processlist | +----+------------------+-----------+----+---------+------+-------+------------------+ Uptime: 3 Threads: 1 Questions: 122 Slow queries: 0 Opens: 116 Flush tables: 1 Open tables: 64 Queries per second avg: 40.667 Purtroppo non conosco mysql fino a questo punto. Qualcuno mi può dare un consiglio? Grazie. Ciao. |
|
|
|
19-10-2006, 16:49
|
#2 |
|
Senior Member
Iscritto dal: Jan 2001
Città: Milano
Messaggi: 5707
|
devi fixare a mano le tabelle, puoi usare mysqlcheck o
myisamchk se le tabelle sono MyISAM. Il primo si usa a db attivo, il secondo a freddo. guarda la documentazione per le opzioni. |
|
|
|
|
19-10-2006, 18:19
|
#3 |
|
Senior Member
Iscritto dal: Jul 2002
Città: Padova
Messaggi: 4245
|
Fatto, mi da tutto OK............ spero sia vero
 Codice:
Server:/home/st3fan0# mysqlcheck --auto-repair zencart -u root -p Enter password: zencart.address_book OK zencart.address_format OK zencart.admin OK zencart.admin_activity_log OK zencart.authorizenet OK zencart.banners OK zencart.banners_history OK zencart.categories OK zencart.categories_description OK zencart.configuration OK zencart.configuration_group OK zencart.counter OK zencart.counter_history OK zencart.countries OK zencart.coupon_email_track OK zencart.coupon_gv_customer OK zencart.coupon_gv_queue OK zencart.coupon_redeem_track OK zencart.coupon_restrict OK zencart.coupons OK zencart.coupons_description OK zencart.currencies OK zencart.customers OK zencart.customers_basket OK zencart.customers_basket_attributes OK zencart.customers_info OK zencart.customers_wishlist OK zencart.db_cache OK zencart.email_archive OK zencart.ezpages OK zencart.featured OK zencart.files_uploaded OK zencart.geo_zones OK zencart.get_terms_to_filter OK zencart.group_pricing OK zencart.languages OK zencart.layout_boxes OK zencart.manufacturers OK zencart.manufacturers_info OK zencart.media_clips OK zencart.media_manager OK zencart.media_to_products OK zencart.media_types OK zencart.meta_tags_categories_description OK zencart.meta_tags_products_description OK zencart.music_genre OK zencart.newsletters OK zencart.orders OK zencart.orders_products OK zencart.orders_products_attributes OK zencart.orders_products_download OK zencart.orders_status OK zencart.orders_status_history OK zencart.orders_total OK zencart.paypal OK zencart.paypal_payment_status OK zencart.paypal_payment_status_history OK zencart.paypal_session OK zencart.paypal_testing OK zencart.product_music_extra OK zencart.product_type_layout OK zencart.product_types OK zencart.product_types_to_category OK zencart.products OK zencart.products_attributes OK zencart.products_attributes_download OK zencart.products_description OK zencart.products_discount_quantity OK zencart.products_notifications OK zencart.products_options OK zencart.products_options_types OK zencart.products_options_values OK zencart.products_options_values_to_products_options OK zencart.products_to_categories OK zencart.project_version OK zencart.project_version_history OK zencart.query_builder OK zencart.record_artists OK zencart.record_artists_info OK zencart.record_company OK zencart.record_company_info OK zencart.reviews OK zencart.reviews_description OK zencart.salemaker_sales OK zencart.sessions OK zencart.specials OK zencart.tax_class OK zencart.tax_rates OK zencart.template_select OK zencart.upgrade_exceptions OK zencart.whos_online OK zencart.zones OK zencart.zones_to_geo_zones OK |
|
|
|
|
19-10-2006, 18:25
|
#4 |
|
Senior Member
Iscritto dal: Jan 2001
Città: Milano
Messaggi: 5707
|
sembra OK
|
|
|
|
|
|
| Strumenti | |
|
|
Tutti gli orari sono GMT +1. Ora sono le: 13:04.
