I'm having a problem with mysql regarding this particular qeury:
// START: This part causes the Dig News lag >>>>>>>>>>>>>>>>>>>>>>>>>>>
$dn->query_fetch("SELECT `news_category`,
`news_type`,
`news_headline`,
`news_content`,
`news_visits`,
`news_views`,
`news_link`,
`news_date`,
`news_votes_up`,
`news_user`
FROM `{$this->tdignews_main}`
WHERE `news_id` = '{$this->news_id}'");
$this->category_id = $dn->field('news_category');
$this->news_type = $dn->field('news_type');
$this->news_headline = $dn->field_stripslashes('news_headline');
$this->news_views = $dn->field('news_views');
$this->news_visits = $dn->field('news_visits');
$this->news_user = $dn->field('news_user');
$this->news_date = $dn->field_datetime('news_date');
$this->news_content = $dn->field_code('news_content');
$this->news_votes_up = $dn->field('news_votes_up');
// END: This part causes the Dig News lag <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
It's taking almost a minute to process No matter what I change in the mysql setting.
my current my.cnf is:
----------------------
[mysqld]
# --begin mod--
skip-innodb
skip-bdb
# --end mod --
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-networking
skip-locking
# --begin mod--
max_connections = 500
max_user_connections = 500
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 500K
read_buffer_size = 500K
sort_buffer_size = 1M
table_cache = 32M
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 1M
max_connect_errors = 999999
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
tmp_table_size = 16M
max_heap_table_size = 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
# --end mod --
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
------------------------------------
What could be the problem?