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:

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

mysql with new binary as basedir and see whether innodb has enabled or not. Check the error log why the innodb is getting disabled, make a copy of it here too. On Tue, Oct 12, 2010 at 2:57 PM, Willy Mularto sangpr...@gmail.com wrote: Hi List, Last night accidentally one of my InnoDB table crash

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

Hi list, I have a table which is very active in operation INSERT INTO and DELETE, approximately there will be around 2millions INSERT and DELETE operation per day. And I see the overhead is getting very high, I must do OPTIMIZE TABLE query every time. Is there any other option to solve

Re: High Overhead On Active Insert And Delete Table

-- From: Willy Mularto To: mysql@lists.mysql.com Subject: High Overhead On Active Insert And Delete Table Sent: Jan 3, 2010 4:22 PM Hi list, I have a table which is very active in operation INSERT INTO and DELETE, approximately there will be around 2millions INSERT and DELETE operation per day