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

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 mind to

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,

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

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

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

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 (

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

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 ?

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

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

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

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

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 attee...@gmail.com wrote: Hi Everyone, I have an application that uses a custom made DBConnectionPool. The architecture is basically as follows: All

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 carlos.pr...@gmail.com: I dont

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

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 replication

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