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)

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

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: Adding a column to a huge mysql table

to a huge 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.

Re: case insensitivity

neral Mailing List > 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?

'zzz'; > > how do i modify this setup to remove access 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:

Re: IN clause

> IN (SELECT DISTINCT (table_old2.`country) FROM table_old AS table_old2)); > > I know I can do this by creating two additional tables, but was > wondering if there was a direct way. > > Best, > Joe. > > -- > MySQL General Mailing List > For list archives: htt

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:

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 wrote: > Thanks for the reply. I used non stored proced

Re: Kill DELETE Query

to delete the rows, and commting freqently, then > the kill will happen faster. > If you have just used "delete from table_name where , then it > would take toot much time to rollback all the deleted but not commited rows. > > Regards > anandkl > > On Fri, Dec 17, 2010

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 http://www.petitiononline.com/froyo/

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

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 st

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 data

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 > Hi, > I see so many lo

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:http://lis

Re: Persistent Connection VS One Time Connection Was Update Table

y time 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, >&

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.

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 misses

Re: High Overhead On Active Insert And Delete Table

te` (`insertdate`), KEY `fid` (`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, Sure

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: 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 Sent: 29 December 2009 19:59 To: mysql@lists.mysql.com Subject: Help keep

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 Sent: 24 September 2009 15:07 To: 'The Doctor' ; mysql@lists.mysql.com Subject: RE: REstricting MySQL access to

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

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

datetime issue on MySQL 4.x

x27;, NOW())... And when I try to fetch the data using PHP with this query: SELECT operator_id, DATE_FORMAT(date_time,'%d-%m-%Y') AS tanggal, COUNT(*) AS TOTAL FROM dlr WHERE 1=1 AND dlr = 8 AND MONTH(date_time) = MONTH(NOW()) GROUP BY tanggal, operator_id ORDER BY date_time The weird thing happened. Why does all the rows are shown or treated as July 7th data? If we see the imported data, there should be June 28, June 29.until July 7. Please help and many thanks for any reply. Regards Willy

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

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=true&charact

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

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 D

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

. I’ve tried to put ‘useUnicode=true&characterEncoding=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

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

blem? 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