Re: Instalation issues

Agarwal, Abhishek wrote: I am not able to start the mysql server. You haven't shown us what happens when you try to start mysql. You've shown us what happens when you install the rpms. You need to /etc/init.d/mysql start or maybe it's /etc/init.d/mysqld start -- MySQL General Mailing Lis

Re: MySQL Performance Degrades Significantly Over Time

On 12/4/06, Jason J. W. Williams <[EMAIL PROTECTED]> wrote: Hi Daniel, Thank you very much for your help and advice. After some examination, we discovered a couple of things. It looks like our storage array layout was really bad for the IOPS MySQL was throwing at it, as a result the InnoDB trans

Re: Date v. DateTime index performance

Thomas, I do not think in this case that one is better than the other, for the most part, because both require using a value computed from the column. Computing month from a DATE field should be just as fast as computing from a DATETIME column I would think. Also splitting into DATE and TIME col

RE: Instalation issues

I am not able to start the mysql server. Thanks Abhishek -Original Message- From: Gerald L. Clark [mailto:[EMAIL PROTECTED] Sent: Monday, December 04, 2006 4:36 PM To: Agarwal, Abhishek Cc: mysql@lists.mysql.com Subject: Re: Instalation issues Agarwal, Abhishek wrote: > Hello All, > >

Re: Instalation issues

Agarwal, Abhishek wrote: Hello All, I am trying to install the mysql server 5.1 on fedora 4. please find below the output [EMAIL PROTECTED] downloads]# rpm -i MySQL-server-5.1.12-0.glibc23.i386.rpm PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then is

Instalation issues

Hello All, I am trying to install the mysql server 5.1 on fedora 4. please find below the output [EMAIL PROTECTED] downloads]# rpm -i MySQL-server-5.1.12-0.glibc23.i386.rpm PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands:

Date v. DateTime index performance

If one has a large number of records per month and normally searches for things by month, yet needs to keep things time coded, does anyone know if it make sense to use datetime or separate date and a time columns? Thanks, Tom -- MySQL General Mailing List For list archives: http://lists.mysql.c

64 bit library for windows XP

Hi, I can't seem to find a 64bit library (libmySQL.lib) for Windows XP64. Can you point me in the right direction? Thanks Tim

Re: Header Files

On Monday 04 December 2006 07:15, Nishant Gupta wrote: > Hello all > I know its a very small thing to ask, but since am kinda stuck over this, > plz consider this is as imp. > Kindly let me know which header file do we need to include in order to use > NOW( ) fn while using MySQL in C/C++. > > Than

RE: MySQL Date Issues

Jesse, There are many ways to convert the datetime to its various parts; short date, short time, month, day, year, hour, minute, seconds, etc. Here is ShortDate (mm/dd/): <%# Convert.ToDateTime(DataBinder.Eval(Container.DataItem, "AddedDate")).ToShortDateString() %> Here is ShortT

RE: Error. Need help (Bad arguments.)

Sounds more like a PHP error than a MySQL error. -Original Message- From: John [mailto:[EMAIL PROTECTED] Sent: Monday, December 04, 2006 12:53 AM To: mysql@lists.mysql.com Subject: Error. Need help (Bad arguments.) I get this error: Warning: implode(): Bad arguments. in /home/b/cl/

Header Files

Hello all I know its a very small thing to ask, but since am kinda stuck over this, plz consider this is as imp. Kindly let me know which header file do we need to include in order to use NOW( ) fn while using MySQL in C/C++. Thanks in advance... -- Bye for now, Nishant God Gave Me Nothing I W

SQL Crashed

Crashed mysql, claiming problem at line 1594, on a file structure that doesn't exist. Most confusing, also showed several Also tried to access /jsp/java/sql/BatchUpdateException.class HTTP/1.1" 404 337 again, something else that doesn't exist. Confused! This might help, but I don't understand

RE: MySQL Date Issues

Jesse, Try the following: Date <%# DataBinder.Eval(Container.DataItem, " StartDateTime ", "{0:d}") %> Hope this helps. Randall Price Secure Enterprise Technology Initiatives Microsoft Implementation Group Virginia Tech Information Technology 1700 Pratt Drive Blacksburg, VA

Re: Query Cache

Hi Mohsen, Thanks for the reply. I'm looking in the home directory, as well as the other directories used by mysql and I can't see any files which I do not recognise. (I am UNIX so there are no hidden files.) I am also a little confuses as the Query Cache is entirely a memory structure, do

Milliseconds of now()

Hello!, How can obtain the miliseconds of function of NOW()?? In the example we can obtain only 0 ( zero)The result is zero. *SELECT MICROSECOND(now());* Thank you, Juan

Query Cache

Dear MySql, Can you please tell me if there is a tool to view the queries stored in the Query Cache? Regards, Ben Clewett. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Why incomplete Cardinalities with MERGE tables ?

I have some base tables, called data2004, data2005 etc. They all have the following structure: CREATE TABLE IF NOT EXISTS `data200X` ( F1 int unsigned NOT NULL default '0', F2 smallint unsigned NOT NULL default '0', F3 smallint unsigned NOT NULL default '0', F4 tinyint unsigned NOT NULL defau