Re: DATATYPES

Thanks a lot. On Tue, Sep 9, 2008 at 7:35 PM, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > > You pretty much answered your own question. A char will always use the > > same amount of space (the max size), regardless of how little data you > > put in it. A varchar will only use enough space to

Re: DATATYPES

Hi, How prior version 5.0.19 stores varchar(1000). mysql> create table ts (name varchar(1000)); Query OK, 0 rows affected (0.09 sec) mysql> show create table ts; +---++ | Table | Create Table | +-

Re: Weird problem with mysql_query

Hi G, There is nothing weird about your results. When you do a Count(*) without a GROUP BY(someColumn) you are essentially asking MySQL how many rows are present in the table. But when you do use Group By someColum , you are asking MySql how many rows do I have of "someColumn" . It's just a go

Weird problem with mysql_query

We are running MySql version 5.0.45-Debian_1ubuntu3.1-log Debian etch distribution under Ubuntu. If I submit the following query via mysql_query it acts as if the where is not there: select count(*) as 'Count' from logins where player = 'aqwert'; this returns: Count 143578160 Submitting

mysql slave replication with master-retry-count

hello, I would like to set that option in mysql 5.0.45 on my slave server: |master-retry-count=800 my slave status: Slave_IO_State: Queueing master event to the relay log Master_Host: xx.xx.xx.xx Master_User: fmRepl Master_Port: 3306

Re: Using Flush Hosts in cron

Hank schrieb: > On Tue, Sep 9, 2008 at 11:48 AM, Werner D. <[EMAIL PROTECTED] > > wrote: > > Hank schrieb: > > I have the blocked connection problem between three of my servers, all > > behind two firewalls and on one switch. > > > > Occaisionally the

RE: Using Flush Hosts in cron

What can I check to see whether I'm about to have a host blocked? Anything in mysql or the OS? I'd like to know about it before I get a phone call, and I don't want to proactively flush hosts or increase max_connection_errors. -Original Message- From: Werner D. [mailto:[EMAIL PROTECT

Re: Using Flush Hosts in cron

Hank schrieb: > I have the blocked connection problem between three of my servers, all > behind two firewalls and on one switch. > > Occaisionally the mysql servers start blocking the hosts. > > What's the downside to running a "Flush hosts" once per minute on these > mysql servers? better solut

error log file permissions

Background: Solaris 10, MySQL 5.0.45. I have changed something recently that is causing the error log file to be created with mode 660. I would like for it it be mode 664. I admit that I recently changed the my.cnf file and added a log-error line which did not have the fully qualified path and cau

Re: DATATYPES

> You pretty much answered your own question. A char will always use the > same amount of space (the max size), regardless of how little data you > put in it. A varchar will only use enough space to store the data, so > the amount of space used for each record will be different. You can > also sp

Re: DATATYPES

Have you checked the manual to be sure that the 65000 varchar is available to the version of MySQL you are using? Prior to 5.0.3, it was 255 only. - Original Message - > *From:* "Krishna Chandra Prajapati" <[EMAIL PROTECTED]> > *To:* mysql > *Date:* Tue, 9 Sep 2008 17:54:46 +0530 > >

Re: DATATYPES

Hi Brent, If i need to create a string column of length 1024 which one is best varchar or text. Although both support up to 65534 characters. create table test1(details varchar(65534), roll varchar(100));(table cannot be created) create table test2(details text, roll text);(table

Using Flush Hosts in cron

I have the blocked connection problem between three of my servers, all behind two firewalls and on one switch. Occaisionally the mysql servers start blocking the hosts. What's the downside to running a "Flush hosts" once per minute on these mysql servers? The only hosts that are connecting are o

Re: DATATYPES

You pretty much answered your own question. A char will always use the same amount of space (the max size), regardless of how little data you put in it. A varchar will only use enough space to store the data, so the amount of space used for each record will be different. You can also specify a max

Re: DATATYPES

Suggest you read the online manual... - Original Message - > *From:* "Krishna Chandra Prajapati" <[EMAIL PROTECTED]> > *To:* mysql > *Date:* Tue, 9 Sep 2008 17:54:46 +0530 > > Hi, > > I would like to know the difference between char, varchar and text. > > char limit 255 character

DATATYPES

Hi, I would like to know the difference between char, varchar and text. char limit 255 character fixed length varchar limit 65,000 character variable length text limit 65,000 character variable length. -- Krishna Chandra Prajapati

Re: Full text search and highlight results

> MySQL has no idea how you are presenting the data (html, rtf, etc.), > so it couldn't hilight the words for you. It should really be that > tricky using grep and PHP. > > Brent I have my data as pure text: no html, rtf or something else. That is, one table with two columns: one for the document

MySQL University session on September 11: openSolaris Web Stack

Hi, This Thursday, Jyri Virkki & Murthy Chintalapati will give a MySQL University session: http://forge.mysql.com/wiki/OpenSolaris_Web_Stack (topic: openSolaris Web Stack) Please register for this session by filling in your name on the session Wiki page. Registering is not required but appre