RE: Regarding storing non-english chars in mysql

Solved... :) What I did is: 1.I changed the selected columns charset to utf8 but other columns, table and database where using default charset. 2.Before doing a simple insert of parameters received from browser into mysql, I executed "set names 'utf8'" on the same connection and again while sele

Re: MySQL Replication Delete is not gettting replicated

Hi Manasi, That alone is the difference in this case. -- Thanks Suresh Kuna MySQL DBA On Tue, Jan 19, 2010 at 10:36 AM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Dear Carlos, > > Thanks for the response. But I haven't gave any privileges besides > repl_slave priv to user replic

Re: MySQL Replication Delete is not gettting replicated

Hi Manasi Yes, you only need the repl_slave_priv, the show grants should give you something like: GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%' IDENTIFIED BY PASSWORD '...' If thats ok, have check your binlog and relay binlog to see if them contain the delete statements? Im trying to

Re: MySQL Replication Delete is not gettting replicated

Dear Carlos, Thanks for the response. But I haven't gave any privileges besides repl_slave priv to user replication and replication2 respectively. So does that amke any difference really? Thanks in advance. -- Regards, Manasi Save Quoting Carlos Proal : I dont see anything unusual or m

Re: mysqlpp::Connection memory leak?

I just noticed that the MySql Client library version that the server reports is 5.1.11 Thanks again, On Mon, Jan 18, 2010 at 9:22 PM, Attila wrote: > Hi Everyone, > > I have an application that uses a custom made DBConnectionPool. > The architecture is basically as follows: > > All of the compo

mysqlpp::Connection memory leak?

Hi Everyone, I have an application that uses a custom made DBConnectionPool. The architecture is basically as follows: All of the components (DBConnectionPool and DBWorker) run in their own strands (all work is queued, so no explicit locking is required), that is... all work is run via threadpoo

Re: MySQL Replication Delete is not gettting replicated

I dont see anything unusual or missing on your config file and as the only thing missing are deletes, i think that might be a permission issue. Can you check out the grants for your replication users and see if they have full permissions granted ? mysql> show grants for x; where is xxx

Re: Record old passwords ?

On 1/18/2010 6:52 PM, Colin Streicher wrote: On January 18, 2010 01:34:15 pm Tompkins Neil wrote: Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is different from any of the last

Re: Record old passwords ?

On 1/18/2010 5:52 PM, Colin Streicher wrote: On January 18, 2010 01:34:15 pm Tompkins Neil wrote: Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is different from any of the last fou

Re: Record old passwords ?

On January 18, 2010 01:34:15 pm Tompkins Neil wrote: > Hi > > I'm in the process of designing a login system to a secure web page using > MySQL. One of the features is we need to record and ensure that the user > password is different from any of the last four passwords he/she has used. > I was

Re: Record old passwords ?

Using multiple columns to hold essentially the same data is generally a bad idea: Business requirements may change over time, forcing you to change both the schema and your programming logic. Better to use a table consisting of username/changedate/password. One year from now, when your boss/c

Re: Regarding storing non-english chars in mysql

you can specify the character encoding (called CHARSET in mysql) and collation on a per column, per table or per database level. e.g. CREATE DATABASE foo CHARACTER SET utf8 COLLATE utf8_general_ci; or CREATE TABLE foo ( ... ) CHARACTER SET utf8 COLLATE utf8_general_ci; or CREATE TABLE foo ( ba

RE: When using "FOR UPDATE" whole the table seems to lock instead of selected row

I think Baron was referring to a technique like this: you sell a t-shirt, UPDATE table SET t=t-X WHERE t >= X, if you get rows affected, it's sold and ok. if not, the stock ran out before the operation. but it's safe. see http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html

RE: Regarding storing non-english chars in mysql

http://dev.mysql.com/doc/refman/5.0/en/charset.html -Original Message- From: Ningappa Koneri [mailto:ningappa.kon...@comviva.com] Sent: Sunday, January 17, 2010 11:32 PM To: mysql@lists.mysql.com Subject: Regarding storing non-english chars in mysql Dear all, I have a problem in migrati

Re: Record old passwords ?

I'm still pretty new on the list, so take it easy on me if I'm way off base. But I think you'd be better off with a table just for old passwords. I think you could get by with four columns: id(primary key), user_id, old_pw, change_date. It should make your validation query and inserts much easie

Record old passwords ?

Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is different from any of the last four passwords he/she has used. I was thinking of create four fields called Password1, Password2, Passw

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

Jerry Schwartz wrote: > From: Edward S.P. Leong [mailto:edward...@ita.org.mo] > Sent: Friday, January 15, 2010 8:03 AM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server > performance > > Jerry Schwartz wrote: > >BTW, would you

Re: Performance Innodb my.cnf

Hi Ortis, How abt the hits or load i.e ( DML, DDL ) to the server. My initial assessment after looking at you cnf file is 1) Calculate and place an appropriate value for innodb_buffer_pool_size 2) Reduse the innodb_thread_concurrency to 4 or 8. and how about the no. of tables in the database and