Un aiuto su mysql.........

[stefanoxjx]

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:


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


Ora mi sto chiedendo se si è arrangiato mysql a fixare i problemi o se devo fare qualcosa io.
Purtroppo non conosco mysql fino a questo punto.
Qualcuno mi può dare un consiglio?
Grazie.
Ciao.

[kingv]

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.

[stefanoxjx]

Fatto, mi da tutto OK............ spero sia vero :)


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

Grazie dell'aiuto.

[kingv]

sembra OK ;)