RE: lost connection DURING query?

Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 8:08 AM To: Crouch, Luke H. Cc: mysql@lists.mysql.com Subject: Re: lost connection DURING query? Crouch, Luke H. [EMAIL PROTECTED] wrote on 03/14/2005 09:34:02 AM: This error message seems a bit

lost connection DURING query?

This error message seems a bit different than others I have gotten. it is from a ColdFusion server that uses an ODBC driver... ODBC Error Code = S1000 (General error) [MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost connection to MySQL server during query that during part threw me, but it

ulimit effects on mysql user?

if I have changed my /etc/security/limits.conf file to include these lines: mysqlsoft nofile4096 mysqlhard nofile63536 and then done: [EMAIL PROTECTED] root]# su mysql [EMAIL PROTECTED] root]$ ulimit -n 8192 [EMAIL PROTECTED] root]$ ulimit -n 8192 does this

extended insert limit?

what is the limit to the number of records that can be inserted via an extended insert statement. I know mysqldump creates a new insert statement every X records, but I forgot what that number is, and I'm trying to duplicate the action. thanks, -L

RE: extended insert limit?

thanks much. exactly what I needed. -L -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 11:22 AM To: Crouch, Luke H. Cc: mysql@lists.mysql.com Subject: Re: extended insert limit? Crouch, Luke H. [EMAIL PROTECTED] wrote on 02/22

strange user permissions error

we had a power outtage and for some reason our user permissions didn't seem to come back? we had a record of granting a 'cfmysql'@'%.ourdomain.com' and it didn't seem to work at all until I did a flush privileges...and even after that, I had to go in and set up some explicit domains in addition

log_slave_updates without restarting

is there a way to turn on log_slave_updates on a server without having to restart it? -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

replication vs. c-jdbc

we currently have a series of machines set up with replication (1 master, 4 slaves) and we were looking for a way to load-balance the read queries across the slaves, and came upon c-jdbc. I was wondering if anyone else has experience running c-jdbc in front of MySQL, and if so, if they can

replication threads on different CPUs

I'm a bit of a linux newbie and a newbie to replication, so I'll try to ask this question simply... we're using mysql 4 to do replication, and I notice on the master I have this from using mytop: Id User Host/IP DB TimeCmd Query or State --

auotmate read queries for replication

is there a simple way to automate read queries for replication above the application level? we have a huge amount of disparate systems with all their own queries, and we'd like to be able to set up the reads to go to our slaves, and the writes to go to our master without having to change every

replication binary log files location

I'm trying to move my binary log files onto a different drive than our main data drive to get a little performance boost. the drives are set up like so: drive 1 (sda): swap /boot /usr drive 2 (sdb): / mysql is installed in /usr/local/mysql and its data directory is /usr/local/mysql/var I

Re: replication binary log files location

I found the solution to my own problem... the log-bin option is a specific filename. so when you set: log-bin=/logging mysql must have ownership of the / folder, as it is trying to create /logging.001 and /logging.index easily fixed by adding the file-name to the path...

super-smack installation problem

I'm trying to configure and install super-smack-1.2 and get a problem on configure. it's looking for mysql_real_connect and can't find it...where would this be located? I'm assuming it is in libmysqlclient.so, and I have that file in my /usr/lib/mysql folder, among other places...but it