Database ekspert søges..!!
Hej Jeg er på jagt efter en database ekspert som kan optimere en databse for mig. Jeg vil lige skynde mig at sige, at det er en database løsning jeg har købt og ikke selv programmeret, og personligt ved jeg ikke ret meget om det, derfor søger jeg hælp her. Ligeledes har jeg ingen anelse om hvor omfangsrigt problemet er og hvor stort et indgreb og hvor meget tid det kræver.Lad mig høre fra jer hvis I mener at kunne hjælpe, og evt. hvad i vil forlange for det.
Når jeg kører en status kommer følgende som bekymrer mig:
- ( slow_queries 316) please process the slow query log and optimize queries that take a long time to execute.
- (handler_read_rnd 19 M) please reduce queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
- ( handler_read_rnd_next 3,600.23 M) Please index tables properly and write queries to take advantage of the indexes you have.
- (qcache_lowmem_prunes 2,528 k) please tune the query cache size.
- (Thread_cached 125) please raise your thread_cache_size.
- (created_tmp_disk_tables 219 k) please increase the tmp_table_size to cause temporary tables to be memory-based instead of disk-based.
- (select_full_join 19 k) please check the indexes of your tables to reduce the number of joins that do not use indexes.
- (select range check 18) please check the indexes of your tables to reduce the number of joins without keys that check for key usage after each row.
- (sort_merge_passes 24) please increase the value of the sort_buffer_size system variable.
- (opened_tables 329 k) please reduce the number of tables that have been opened, and increase your cache table value.
- (table_locks_waited 46 k) please reduce the number of times that a table lock can not be acquired immediately and a wait is needed. please optimize your queries, and then either split your table or tables or use replication.
