RE: RE: what is the proper way to store timezone information?

Boyd, Todd M. wrote: >> My concern is whether the time_zone_id is a fixed reference of the >> timezone. If the id might (for whatever reason) change in the >> future, I'd have to store the timezone name. > > http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html > > You can convert back

MySQL 5.1.25-rc has been released

Dear MySQL users, We are proud to present to you the MySQL Server 5.1.25-rc release, a new "release candidate" version of the popular open source database. Bear in mind that this is still a "candidate" release, and as with any other pre-production release, caution should be taken when installing

MySQL University session on June 19: Checking Performance with Kchachegrind

Hi, this Thursday, Stewart Smith will give a MySQL University session: http://forge.mysql.com/wiki/Checking_Performance_with_Kchachegrind (topic: Checking Performance with Kchachegrind) Please register for this session by filling in your name on the session Wiki page. Registering is not requi

RE: RE: what is the proper way to store timezone information?

> -Original Message- > From: Per Jessen [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 14, 2008 6:23 AM > To: mysql@lists.mysql.com > Subject: RE: what is the proper way to store timezone information? > > Boyd, Todd M. wrote: > > >> > >> When recording this information, do I store the f

Re: Server Getting crashed, Any Help Comments?

trying reducing session related parameters like sort_buffer_size,read_buffer_size , read_rnd_buffer_size to 1MB On 6/16/08, Moon's Father <[EMAIL PROTECTED]> wrote: > > How large is your total memory? > There parameters' value seem too large. > > On Mon, Jun 16, 2008 at 4:49 PM, Moon's Father <[E

Re: enable and disable keys

man csplit try csplit 10 {10} On Mon, Jun 16, 2008 at 2:22 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi Krishna, > Can u please give me example of csplit. > > regards > anandkl > > > On 6/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >> >> try csplit to break the files into

Re: enable and disable keys

Hi Krishna, Can u please give me example of csplit. regards anandkl On 6/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > try csplit to break the files into small chunks > > On Fri, Jun 13, 2008 at 12:21 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > >> How do i split file during E

Re: Server Getting crashed, Any Help Comments?

How large is your total memory? There parameters' value seem too large. On Mon, Jun 16, 2008 at 4:49 PM, Moon's Father <[EMAIL PROTECTED]> wrote: > How large is your total memory? > There parameter seems too large. > > > On Sun, Feb 10, 2008 at 5:42 PM, VeeJay <[EMAIL PROTECTED]> wrote: > >> Hell

Re: Server Getting crashed, Any Help Comments?

How large is your total memory? There parameter seems too large. On Sun, Feb 10, 2008 at 5:42 PM, VeeJay <[EMAIL PROTECTED]> wrote: > Hello > > I am running a Freebsd server: > > 1. Software: > Apache 1.3 > mysql 5.0.27 > php 4.4 > > > 2. Hardware: > 2 intel procerssors > 4 gb ram > RAID 10 with

Re: MS SQL to MySQL select

Thanks Martijn! That I understood, sorry I wasn't clear enough, I was more confused about the "TOP 100 PERCENT" and this was a bad example anyways, but after posting I did some deeper research and found an excellent migration white paper describing this type of expressions and mysql counterparts.