Tagged Questions

3
votes
3answers
107 views

Are individual queries faster than joins?

Conceptual question: Are individual queries faster than joins, or: Should I try to squeeze every info I want on the client side into one SELECT statement or just use as many as seems convenient? ...
1
vote
1answer
166 views

MySQL 5.5 - determining correct write[read]_io_threads on high-end system?

Specifically dual-CPU 32 core - 128RAM - RAID 10 SSD . Ubuntu 64 server. Heavy Innodb load at times - ~ 2000+ queries per sec. Heavy read and write. Currently we are running on the default ...
1
vote
1answer
52 views

tuning feed item's table query with multiple condition

I have a query like this: SELECT * FROM `rss_item` WHERE `feed_id` = 1 and `timestamp` < 1350698635 ORDER BY `rss_item`.`timestamp` ASC MySQL: 5.1; table engine: innodb Explain result: ...
0
votes
0answers
257 views

Oracle 10g - Sudden change in execution time for specific query

After the DBAs fiddled with some parameters in our Oracle 10g Production Environment, most queries became a little faster. But a single query (a quite complex one) became dramaticaly slower - it went ...
1
vote
1answer
481 views

InnoDB Performance Tuning

I'm new to database administration so please excuse any omissions of what would seem like basic info to provide for this problem. I'm a RoR developer and our team is currently short a DBA, so we're ...
16
votes
3answers
16k views

Possible to make MySQL use more than one core?

I've been presented with some dedicated MySQL servers that never use more than a single core. I'm more developer then DBA for MySQL so need some help Setup The servers are quite hefty with an ...