Keynote videos from Percona Live MySQL Conference

2012-04-12 Thread Baron Schwartz
If you were not at the Percona Live MySQL Conference over the last few days, the keynote videos are recorded for your convenience. You can see them at http://www.percona.tv/ Presentations will be posted at http://www.percona.com/live/ as well, after the speakers submit them to us for posting. I wi

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Hal�sz S�ndor
;>>> 2012/04/12 11:56 -0700, Haluk Karamete My initial goal was to write a very convenient php function that display a table view based on arguments that are super simple to write - without requiring the developer to type-in ( or know ) the ins and outs of joins, natural joins etc. Somethi

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Haluk Karamete
My initial goal was to write a very convenient php function that display a table view based on arguments that are super simple to write - without requiring the developer to type-in ( or know ) the ins and outs of joins, natural joins etc. Something like this function showtable($dbh,$table,$fields)

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Hal�sz S�ndor
2012/04/11 17:51 -0500, Peter Brawley select b.peopleID, concat('(',p.fname,,')'), b.stateID, concat('(',s.state,')') from bridge b join people p on b.peopleID=p.peopleID join state s on b.stateID=s.stateID; Since the names are the same in the tables, it works to use "USING", too

Re: HT Feature

2012-04-12 Thread Kaushal Shriyan
On Thu, Apr 12, 2012 at 6:38 PM, Johan De Meersman wrote: > - Original Message - > > From: "Kaushal Shriyan" > > > > Any performance bottleneck if HT (Hyper Threading) is enabled in quad > > core processors on CentOS 5.8 running MySQL DB Server ? Please help me > > understand about pros a

Re: HT Feature

2012-04-12 Thread Johan De Meersman
- Original Message - > From: "Kaushal Shriyan" > > Any performance bottleneck if HT (Hyper Threading) is enabled in quad > core processors on CentOS 5.8 running MySQL DB Server ? Please help me > understand about pros and cons of this feature. That very much depends on your workload. I'd