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
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
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
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
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 /backup/mysql
mkdir /backup/mysql
# Dump all mysql databases
mysqldump --all
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 'mysqld
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
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
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
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
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 [EMAIL PROTECTED] wrote on 12/02/2005
.
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
to
the two boxes from each other.
Just wondering if it is because of the port(3306) got disabled??
Thanks,
Jenny
Hi,
I'd ask some questions on MySQL cluster. Does anyone know if there is any
email alias for the cluster questions?
Thanks,
Jenny
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
14 matches
Mail list logo