ADDATE Question

Hi, I just tried this query SELECT ADDDATE('2008-01-02', 31); and MySQL returns 323030382d30322d3032, while it should be 2008-02-02 Is there something wrong? Willy Mularto F300HD+MR18DE (NLC1725)

Simple Query Question

Hi, Please help what is wrong with this simple query SELECT COUNT(key_agent) total FROM agents_consolidated WHERE total = 180 Thanks. Willy Mularto F300HD+MR18DE (NLC1725)

Re: Simple Query Question

Hi many thanks for the help :) On Apr 14, 2012, at 6:21 PM, Stefan Kuhn wrote: On Saturday 14 April 2012 09:51:11 Willy Mularto wrote: Hi, Please help what is wrong with this simple query SELECT COUNT(key_agent) total FROM agents_consolidated WHERE total = 180 Thanks. You need to use

Re: Adding a column to a huge mysql table

mysql table, this table is about 77GB, and has thousands of millions rows. any idea I can make this alter table faster? Thanks Angela Willy Mularto F300HD+MR18DE (NLC1725) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: case insensitivity

For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql Willy Mularto F300HD+MR18DE (NLC1725) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: access from everywhere but localhost?

from localhost/127.0.0.1? mysql version is 5.1.49 thx matthias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=sangpr...@gmail.com Willy Mularto F300HD+MR18DE (NLC1725) -- MySQL General

Re: IN clause

:http://lists.mysql.com/mysql?unsub=sangpr...@gmail.com Willy Mularto F300HD+MR18DE (NLC1725) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

memcached enabled

As per subject. How to setup MySQL memcached enabled? Willy Mularto F300HD+MR18DE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Interrupt ALTER Process

Hi, I have an InnoDB with 12 millions of data. For some reason I need to alter the table structure by expanding the varchars value. It's been an hour and slow down the performance. Is it safe to kill the process? Thanks. Willy -- MySQL General Mailing List For list archives: http

Re: Kill DELETE Query

Thanks for the confirmation. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Dec 17, 2010, at 1:31 PM, Ananda Kumar wrote: No...it will not. On Fri, Dec 17, 2010 at 11:26 AM, Willy Mularto sangpr...@gmail.com wrote: Thanks for the reply. I used non stored procedure

Kill DELETE Query

Hi List, I run a delete query to delete around 1 million rows in innodb table, It's been hours and still unfinish. Is it safe to kill that delete query process while the table is also inserting and updating other rows? Thanks. sangprabv sangpr...@gmail.com

Re: Kill DELETE Query

the rows, and commting freqently, then the kill will happen faster. If you have just used delete from table_name where condition, then it would take toot much time to rollback all the deleted but not commited rows. Regards anandkl On Fri, Dec 17, 2010 at 8:37 AM, Willy Mularto sangpr

WTA Increasing InnoDB Speed

Dear List, I have MySQL 5.14 installed on Dell R710 32GB RAM 600GB SAS HDD with Ubuntu 10.04 64 Bit. I deploy InnoDB as my default engine. The server is a high load server. On a fresh install and empty table it can insert around 5 millions new records per day average. But when the table getting

InnoDB Crash

Hi List, Last night accidentally one of my InnoDB table crash. And cause client can not connect to MySQL, it always said cannot connect to socket, even the daemon is launched. I tried to set innodb_force_recovery from 0 to 6 and only number 3 bring back the connection. After that I dump the

Re: InnoDB Crash

I got the solution. I stop the ib* files in MySQL datadir and start the server. Now everything is back to normal. Thanks. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Oct 12, 2010, at 11:00 PM, Suresh Kuna wrote: Hey Willy - Install the new binaries and start

Kill All Proccesses

Hi, I see so many locked tables and can not be unlocked. Is there any single command or tools to kill all processes? sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Kill All Proccesses

AFAIK mysqladmin just kill a proccess and can not do kill all instances. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Sep 29, 2010, at 9:09 PM, Евгений Килимчук wrote: mysqladmin kill id,id,... 2010/9/29 Willy Mularto sangpr...@gmail.com Hi, I see so many

Update Table

Hi, I work on MySQL 5 with PHP 5 and use Apache 2 as the webserver. I have a simple query that searches matched row id and update the field via HTTP GET query. On a low load it succeed update the row. But on high traffic sometimes it failed to update some rows. No errors return by the script.

Re: Persistent Connection VS One Time Connection Was Update Table

the script's called I create new connection and disconnect it after execute the query. Thanks sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Sep 27, 2010, at 7:28 PM, Nigel Wood wrote: On Mon, 2010-09-27 at 11:25 +0100, Willy Mularto wrote: Hi, I work on MySQL 5 with PHP 5

InnoDB Buffer Pool Status

Hi, I got this result on InnoDB Buffer Pool Status: Free pages 1 Dirty pages 2,040 Pages containing data 31,359 Pages to be flushed 457,083,205 Busy pages 1,408 Read requests 31,348,288,497 Write requests 7,913,407,934 Read misses 39,736,110 Write waits 0 Read

High Overhead On Active Insert And Delete Table

this? TIA. Willy sangpr...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: High Overhead On Active Insert And Delete Table

` (`fid`), KEY `msgid` (`msgid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Willy sangpr...@gmail.com On Jan 3, 2010, at 6:00 PM, sureshkumar...@gmail.com wrote: Hi Willy, What is the engine you are using for the table? Paste the table structure. Thanks, Suresh Kuna --Original Message

RE: Help keep the Internet free

I am from Indonesia, have been use The Great MySQL for 10 years in development and production environments. Count me in. Willy Sent from my Sony Ericsson XPERIA™ X1. -Original Message- From: Michael Widenius mo...@askmonty.org Sent: 29 December 2009 19:59 To: mysql@lists.mysql.com

RE: REstricting MySQL access to port 3306

Limit connection from trusted host will reduce it. And its better handled by firewall . Willy Sent from my Sony Ericsson XPERIA™ X1. -Original Message- From: John j...@butterflysystems.co.uk Sent: 24 September 2009 15:07 To: 'The Doctor' doc...@doctor.nl2k.ab.ca; mysql@lists.mysql.com

datetime issue on MySQL 4.x

data, there should be June 28, June 29.until July 7. Please help and many thanks for any reply. Regards Willy

Tuning High Loads MySQL Server

Hello, I have a MySQL 4.x installed, and I have a very high requests on this server, it's about 1 - 5 requests/minutes. Any tips to tuning it? Many thanks for any replies. Regards Willy

Re: datetime issue on MySQL 4.x (SOLVED)

Hello, I have solved this problem, thanks. Regards Willy - Original Message - From: Willy To: mysql@lists.mysql.com Sent: Wednesday, July 12, 2006 8:55 AM Subject: datetime issue on MySQL 4.x Hello, I have a MyISAM table: CREATE TABLE `dlr` ( `msisdn` varchar

RE: French characters ok with mysql in Windows, nok with mysql in Linux

Hello, I changed etc/sysconfig/i18n to: LANG=fr_FR SUPPORTED=fr_FR:fr SYSFONT=lat0-sun16 SYSFONTACM=iso15 and everything works perfectly. Thank you very much for your help. Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: dinsdag 6

French characters ok with mysql in Windows, nok with mysql in Linux

. I’ve tried to put ‘useUnicode=truecharacterEncoding=UTF-8’ in the driver connection url, but this doesn’t help. Can anyone help me on this problem? Greetings, Willy Dockx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: French characters ok with mysql in Windows, nok with mysql in Linux

this evening (I can not get on the Linux system at this moment). I'm not a linux-expert. I didn't change anything in that file until now. Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:18 To: Willy Dockx Cc: [EMAIL

RE: French characters ok with mysql in Windows, nok with mysql in Linux

Both are the same: Character-set : latin1 Character-sets : a long list Convert_Character_set : Is that like it should be? Greetings, Willy Dockx -Original Message- From: Oriol [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:55 To: Willy Dockx Subject: Re: French

RE: French characters ok with mysql in Windows, nok with mysql in Linux

Hello, etc/sysconfig/i18n contains: LANG=en_US.UTF-8 SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en SYSFONT=latarcyrheb-sun16 Is that ok? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Greetings, Willy Dockx -Original

French characters ok with mysql in Windows, nok with mysql in Linux

? Greetings, Willy Dockx

Newbie question: can't create/insert into table

Hi, I am a total MySQL newbie using MySQL 3.22.32. I am trying to simultaneously create a table and insert some data into it as follows: create table temp1 - select field_x - from MyData; But, I get a syntax error (ERROR 1064) on line 2. Would somebody please point me at the right

Transaction safe tables for Mac OS X

Hi, Are there any transaction safe tables for Mac OS X you can use? Thanks, Willy Faes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive