MySQL performance

Hi, If you would like to improve the performance of your MySQL environment, you may consider the following information tobe of interest: The latest series of Dolphin Express drivers for Linux now also includes support for accelerated intra-node socket communications. Through the combination o

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: mysql-migration-toolkit

Am using the following packages -rw-r--r-- 1 root root 4117403 May 3 2007 mysql-administrator-5.0r12-1rhel4.i386.rpm -rw-r--r-- 1 root root310923 Aug 20 17:53 mysql-gui-tools-5.0r12-195.1.x86_64.rpm -rw-r--r-- 1 root root 6265000 May 3 2007 mysql-gui-tools-5.0r12-1rhel4.i386.rpm -rw

Re: mysql-migration-toolkit

I did the following to resolve this issue [EMAIL PROTECTED] download]# rpm -Uvh mysql-migration-toolkit-5.0r12-1rhel4.i386.rpm error: Failed dependencies: libjvm.so(SUNWprivate_1.1) is needed by mysql-migration-toolkit-5.0r12-1rhel4.i386 [EMAIL PROTECTED] download]# rpm -ivh --nodeps mysql-

mysql-migration-toolkit

Am trying to install the following pack: [EMAIL PROTECTED] download]# rpm -Uvh mysql-migration-toolkit-5.0r12-1rhel4.i386.rpm error: Failed dependencies: libjvm.so(SUNWprivate_1.1) is needed by mysql-migration-toolkit-5.0r12-1rhel4.i386 [EMAIL PROTECTED] download]# java -version java versi

Re: convert week of the year into a date string

I did something similar to this recently. I ended up using the following select date_sub(curdate(), interval(dayofweek(curdate()) + (($week - week) * 7) - 1) DAY) as mydate. This was in php and ahead of time I set $week as select week(curdate()). It could easily be extended with year. Phil On

Re: Install MySQL on Windows XP

yuan edit schrieb: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server successful. I stoped the firewall and anti-virus programs when i install mysql server. there is mysql message: Could not start the service MySQL5.Error:0 Now

Re: convert week of the year into a date string

Pintér Tibor wrote: Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of d

Re: Install MySQL on Windows XP

Hi there Yuan, Hopefully this article can be of some help to you: http://schalkneethling.alliedbridge.com/php/php-mysql-apache-set-up-how-to/ Regards, Schalk yuan edit wrote: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server su

Install MySQL on Windows XP

Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server successful. I stoped the firewall and anti-virus programs when i install mysql server. there is mysql message: Could not start the service MySQL5.Error:0 Now i do not know what t

Re: convert week of the year into a date string

Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of days from the start of