quick question on mysql memory usage

Hi, My understanding is that the memory utilization of mysql can be calculated roughly using the formula like: (All global memory related server variables + max_connections * session memory related server variables) As I noticed that most global variables like key_buffer_size, innodb_buffer_szie w

question on mysql proxy's load balancing

Hi, When I read Jk's document on MySQL proxy: http://jan.kneschke.de/projects/mysql/mysql-proxy/ In Load balancing part, he mentioned that: "We use SQF (shortest queue first) to distribute the load across the backends equally. Each backend will get the same number of connections." My understandi

quick question on innodb_log_file_size

Hi, According to the reference manual, it was said that the combined lnnodb log file size is less than 4G on 32-bit system. But I'm running on my 64-bit solaris, I still got the error complaining the innodb log file >4G for my 64-bit MySQL. So I'm wondering is this 4G limit apply on 64-bit system

Re: best practice MySQl backup onto tape

t;[EMAIL PROTECTED]> wrote: > > Jenny Chen wrote: > > Hi, > > > > I'm planing to do hot backup MySQL(innodb db) onto tape drive, and > propose > > the following solution/script: > > > ># delete old mysql dumps > > rm -r -r /ba

best practice MySQl backup onto tape

Hi, I'm planing to do hot backup MySQL(innodb db) onto tape drive, and propose the following solution/script: # delete old mysql dumps rm -r -r /backup/mysql mkdir /backup/mysql # Dump all mysql databases mysqldump --all-databases -single-transaction --flush-logs > all_datab

Question on "mysql-test-run sp" failed

Hi, Recently, I built mysql5.0 on Solaris 10 amd64, but when running "make test", the bundled "sp" test failed with the following error: mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack overrun: 186944 bytes used of a 262144 byte stack, and 81920 bytes needed. Use 'mysq

how to start mysql instanct manager on Solaris platform?

Hi, I'm trying to start mysql with mysql IM, by following the steps as bellow: 1. change the use_mysqld_safe = 0 in the mysql.server 2.set /etc/my.cnf as: [client] #password = your_password port= 3306 socket = /tmp/mysql.sock # Here follows entries for some specific p

How to port Oracle anonymous PL/SQL block to MySQL

Hi, As I know that MySQL supports stored procedure from 5.0. Does anyone have the info on if there is any plan to support anonymous PL/SQL block in MySQL in later MySQL version? So that when port Oracle anonymous PL/SQL block, it doesn't need to change to procedure/function? Thanks, Jenny

MySQL slow query log

Hi, Could anyone explain what might be the possible reasons that in the slow query log(running read-only queries) the most very slow queries(taking 200-300sec) were the queries: 1. create table ... type = MyISAM 2. show slave status Thanks, Jenny

Re: can't connect to the MySQL server from remote machine?

or on client and server > 2) MYSQL is stopped or listening in a different port. > > What is the version of your MYSQL ? > > > On 12/2/05, Jenny Chen <[EMAIL PROTECTED]> wrote: > > > > Yes, I did try both hostname and IP, but can't work although I can ping &

Re: can't connect to the MySQL server from remote machine?

Yes, I did try both hostname and IP, but can't work although I can ping to the two boxes from each other. Just wondering if it is because of the port(3306) got disabled?? Thanks, Jenny On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Jenny Chen <[EMA

can't connect to the MySQL server from remote machine?

Hi, I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote Solaris SPARC box. When I run the command: mysql -h HOSTNAME I got the error as ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145) Could anyone please explain what the mean of the error message

any alias for MySQL cluster question?

Hi, I'd ask some questions on MySQL cluster. Does anyone know if there is any email alias for the cluster questions? Thanks, Jenny

A few questions about triggers in MySQL 5

Hi, Does the current latest MySQL 5.0 support: 1. column based triggers 2. trigger restriction 3. multiple triggers of same type of the table 4. triggers reference another table And any information on in which release they will be supported? Thanks, Jenny