MySQL Speed Getting Slower

Hi, My MySQL server's data is increasing for about 1 million new records per day. And it's now become slower when processing data. Is there any way to speed up? TIA. Regards, Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

help_ The first letter disappeared after I loaded data into table

I loaded data into table by using LOAD DATA LOCAL INFILE '../../...TXT' INTO TABLE tblname (NAME, STREET, MESSAGE); I found that the first letter in message disappeared. the message is text. Could anyone tell me why and how to avoid such problem? Thank you zzy -- MySQL General

Re: help_ The first letter disappeared after I loaded data into table

In order to avoid errors. Always use fields terminated by, enclose by and lines terminated by tag with load data local infile. Just, give try. On Wed, Sep 24, 2008 at 11:19 AM, Zhongyi Zhang [EMAIL PROTECTED] wrote: I loaded data into table by using LOAD DATA LOCAL INFILE '../../...TXT' INTO

Re: MySQL Speed Getting Slower

If you are using innodb. Then increase innodb_buffer_pool_size. If myisam then increse key_buffer_size. Please send status of mysql server and OS details On Wed, Sep 24, 2008 at 12:39 PM, sangprabv [EMAIL PROTECTED] wrote: Hi, My MySQL server's data is increasing for about 1 million new

Re: Ancient, unsolved high-CPU problem -- vmstat, top and ps

Thanks. I've read those links, and they sound like my problem. On each connection, MySQL calls gethostbyname() to resolve the hostname in the connection string into 127.0.0.1 -- e.g., mysql_connect(localhost, user, password) - 127.0.0.1. Because FreeBSD 4.0's (and Mac OS X's) DNS lookups

RE: Ancient, unsolved high-CPU problem -- vmstat, top and ps

Hello Rene is hostname a FQDN or IP? Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse

Re: Ancient, unsolved high-CPU problem -- vmstat, top and ps

Hi Rene, (Note I have updated my reply address to my current company name). Yes, you can still use a hostname in the connection string, that's not what mysql uses it for, that hostname gets you from the client to the server. If you use GRANT to permit access from certain hosts IE 'grant

Re: if count

right null did it... thanks... Leonardus Setyabudi wrote: try something like : count(if(a.type = 'SBR', 1, null)) count will ignore null value .. and only count the one with 'SBR' value br, Leo On 24/09/08 12:09, kalin m wrote: no, not really... sum is part of the query:

nagios server blocked

I've got a nagios server that checks to see if the listening port is open. I'm getting this error: Host 'nagios-host' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' I've googled and there's options to use max_connection_errors=100 My (very rough)

mysql big table select speed

Hello, I have a database with a big table: 350 milion of registers. The table is a Isam table, very simple: mysql describe stadistics; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra |

Re: nagios server blocked

Hi Bryan, My first guess would be to use Nagios's check_mysql plugin. Just because port 3306 (or whatever your MySQL server runs on) is open doesn't mean the server is alive and well. check_mysql behaves as a standard MySQL client, thus avoiding connection errors. I use the latest plugins

Re: mysql big table select speed

Just a wild guess but, did you perhaps change the filesystem to a journalling filsystem when moving to the different server? I once accidently moved my database from an ext2 to an ext3 partition and it took me a while to figure out the degradation of queries.. Phil On Wed, Sep 24, 2008 at 6:16