Re: mysql proxy in production?

Take a look at haProxy. It can be combined with some scripts to loadbalance mysql. http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/ We use it at Open Query for a similar case. Cheers, Walter Heck Engineer @ Open Query http://openquery.com | http://openq

Cygwin and DBD::mysql

it seem the Cygwin Perl can't see a client libraries needed to build DBD::Mysql. Innovative lad that I am I figured I'd just compile my own from 5.1.44 (current download). Nice thought. What happens is the build fails as follows: ./configure --prefix=/usr/local/mysql --without-server [ much conf

RE: Very slow delete for Master / Child tables with millions of rows

This isn't surprising, especially if you have foreign keys or indexes, as each DELETE will cascade and require a rebuild of the indexes (just as an INSERT does). Make sure that for each DELETE you are using LIMIT 1; if it's in a loop (and you're not deleting via PK, but it's a good habit to get i

RE: How to modify the application to implement the separation of write/read

"c3pO" really? as in Starwars?? ;-) /me rolls eyes. > -Original Message- > From: Peter Chen [mailto:peter.c...@aicent.com] > Sent: Thursday, March 11, 2010 3:25 AM > To: Mattia Merzi > Cc: mysql@lists.mysql.com > > I use Hibernate to access Mysql, the connection poll is > c3p0-0.9.0, can

Re: Properly ALTER Column Data?

On Thu, Mar 11, 2010 at 3:57 PM, Gavin Towey wrote: > Please read the tutorial, let us know if you have questions on the > information in it: > http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Thank you very much for the link... I did: UPDATE sun SET serial = '0123456789' WHERE Model = 'Ul

RE: Merging deltas from one table to another?

Not sure if this well help, but SQLYog (the best mysql GUI EVER) has an option that will take two databases and create a schema difference (ALTER statements, etc.) as well as I think data maybe? > -Original Message- > From: Ananda Kumar [mailto:anan...@gmail.com] > Sent: Wednesday, March

RE: Properly ALTER Column Data?

Please read the tutorial, let us know if you have questions on the information in it: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Thursday, March 11, 2010 12:44 PM To: MySQL Subject: Properly ALTER Colu

RE: Error Removing Anonymous Accounts

DROP USER ''@'localhost'; If you use the correct GRANT/REVOKE and CREATE/DROP commands it's not necessary to update the tables and run FLUSH PRIVILEGES. IMO manipulating those tables directly is a bad habit. -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: T

Properly ALTER Column Data?

I know this is very basic for most on the list but I need some MySQL help. I am logged into my database and I successfully changed a 'field type' from INT to VARCHAR. Now I need to modify the actual data I inserted into those specific fields. I checked the manual and could not really gather exactly

Re: Particular value or NULL

Hi Jerry, all! Jerry Schwartz wrote: >> [[...]] >> >> Maybe: >> >> WHERE coalesce(x, 17) = 17 >> >> > [JS] Interesting suggestion, but > > us-gii >select benchmark(1000,(7=7 or null is null)); > [[...]] > 1 row in set (0.34 sec) > > us-gii >select benchmark(1,coalesce(null,7)); > [[

Re: mysql proxy in production?

Has MySQL Proxy been improved since that article was released? I ask because although I have no personal experience with it I do know of a big UK based online payment processing company who use MySQL Proxy with MySQL 5.1 in production very successfully. On Thu, Mar 11, 2010 at 3:34 PM, Johan De

Very slow delete for Master / Child tables with millions of rows

Here is my.ini file - and I am using all Innodb [client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 skip-name-resolve basedir="W:/Applications/MySQL/MySQL Server 5.0/" datadir="W:/Applications/MySQL/MySQL Server 5.0/Data/" default-character-set=latin1 default-storage-eng

Re: Error Removing Anonymous Accounts

On Thu, Mar 11, 2010 at 11:29 AM, Rolando Edwards wrote: > DELETE FROM mysql.user WHERE user=''; > FLUSH PRIVILEGES; That worked and I thank you however I am wondering why the MySQL guide was incorrect? Perhaps it's right but I did something wrong. Any thoughts? -- MySQL General Mailing List Fo

RE: Error Removing Anonymous Accounts

DELETE FROM mysql.user WHERE user=''; FLUSH PRIVILEGES; Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -O

Error Removing Anonymous Accounts

I installed MySQL 5 today and started by setting up root passwords for all three root accounts: mysql> select User, Password, Host, Create_priv from user; +--+---+---+-+ | User | Password | Host |

Re: Very slow delete for Master / Child tables with millions of rows

Hi Randall, How much memory is allocated to innodb_buffer_pool_size. Please send your mysql configuration file (my.cnf) Thanks, Krishna On Thu, Mar 11, 2010 at 8:57 PM, Price, Randall wrote: > I am experiencing very slow deletes when I delete a record from a master > table and have cascading d

Re: mysql proxy in production?

On Mar 11, 2010, at 9:49 AM, Brent Clark wrote: > On 11/03/2010 16:52, Krishna Chandra Prajapati wrote: >> Hi Brent >> >> You can visit the below link. >> >> http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ > > Well thats disappointing. > > sigh > S

Re: mysql proxy in production?

On 11/03/2010 16:52, Krishna Chandra Prajapati wrote: Hi Brent You can visit the below link. http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ Well thats disappointing. sigh So what are we supposed to use for loadbalancing mysql. Thank you for your

Re: Very slow delete for Master / Child tables with millions of rows

If you really have to loop through the entire set deleting record by record, I'm not surprised it's slow. Could you change your application to loop through the records doing "stuff" without deleting (maybe even "do stuff" en masse), and afterwards do a mass delete ? I also have a nagging suspicion

Re: mysql proxy in production?

Bah, just spilled coffee on my keyboard. I never was a big fan of mysqlproxy, but this is almost inconceivable. The next genius to suggest it for our environment had better have asbestos underwear. Thanks for the link, Krishna. On Thu, Mar 11, 2010 at 3:52 PM, Krishna Chandra Prajapati < prajap

Very slow delete for Master / Child tables with millions of rows

I am experiencing very slow deletes when I delete a record from a master table and have cascading deletes on two detail tables. I have an application that looks for records in the master table that are older than "X" days and delete them. The cascasing deletes then handles deleting all the chi

Re: mysql proxy in production?

Hi Brent You can visit the below link. http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ Thanks, Krishna On Thu, Mar 11, 2010 at 7:56 PM, Brent Clark wrote:

RE: Particular value or NULL

My query isn't slow enough to tell the difference, I'm only working with a few hundred records. This was intellectual curiosity. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.c

mysql proxy in production?

Hiya I work for a pretty large hosting company, and we have some clients that you could call "in demand clients" (Well here where I live anyway :) ). We already making use of heartbeat for high availability etc. But the one area that we have not tackled is load balancing. I just read the

Re: How to modify the application to implement the separation of write/read

2010/3/11 Peter Chen : [...] > I am not sure whether do I need to modify something else? Like my application > code. as stated on the webpage you just posted here: --- An application signals that it wants a transaction to be read-only by calling Connection.setReadOnly(true), this replication-

RE: How to modify the application to implement the separation of write/read

Hi Mattia, I use java with the Connector/L jdbc driver, I checked the webpage of http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-replication-connection.html, it suggests to use "ReplicationDriver" to replace common driver. I use Hibernate to access Mysql, the connection poll is c3p0

Re: How to modify the application to implement the separation of write/read

2010/3/11 Peter Chen : [...] > Does someone have met this problem? How to implement the separation of > read and write? please, write us some more details about your application! For example, if you use java with the Connector/j jdbc driver, you can enjoy a really nice feature already implemented

How to modify the application to implement the separation of write/read

Hi all, I want to test the mode of Master/Slave for mysql. Also I want to separate the write and read of sql requests, that is, I want to make Slave server of mysql to handle read requests and make Master server to handle write requests. I want to know how to modify the code of my applica

Re: mysql & RAID

--- On Wed, 10/3/10, John G. Heim wrote: > Hi, > > I am working on configuring a new hardware database server. > I'm a little confused as to what to do about disk. We have > several mysql databases but by far the 2 most active are > spamassassin bayesian rules and horde3/imp web mail. Both do >