Looks like there is a problem with 4.0.3 or I am doing
something wrong:
First I tried to upgrade from rpm,
linux:/home/me/TMPOUT #
rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
linux:/home/me/TMPOUT # rpm -i MySQL-4.0.3-0.i386.rpm
package MySQL-4.0.3-0 is already installed
linux:/home/me/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
linux:/home/db/TMPOUT # rpm -q mysql
package mysql is not installed
>linux:/home/db/TMPOUT # rpm -qa | grep MySQL
>MySQL-shared-4.0.3-0
>MySQL-client-4.0.3-0
>MySQL-devel-4.0.3-0
>MySQL-4.0.3-0
>linux:/home/db/TMPOUT # /usr/bin/mysql
>ERROR 2002: Can't connect to local MySQL server
>through socket '/var/lib/mysql/mysql.sock' (2)
FIrst, it
Looks like rpm for 4.0.3 does not work. ANyone installed
from rpm?
Second, I went to the tarball:
linux:/usr/local # groupadd mysql
groupadd: group mysql exists
linux:/usr/local # useradd -g mysql mysql
useradd: user mysql exists
linux:/usr/local # ln -s /usr/local/mysql-4.0.3-beta-pc-
linux-gnu-i686 mysql
linux:/usr/local # cd mysql
linux:/usr/local/mysql # scripts/mysql_install_db
Installing all prepared tables
Unknown suffix ' ' used for
variable 'thread_concurrency' (value '4 # Try number of
CPU's*2')
./bin/mysqld: Error while setting value '4 # Try number
of CPU's*2' to 'thread_concurrency'
Installation of grant tables failed!
Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:
shell> ./bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths.
Using --log
gives you a log in ./data that may be helpful.
The latest information about MySQL is available on the
web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems
running mysql_install_db',
and the manual section that describes problems on your
OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug
script!
linux:/usr/local/mysql #
I don't get it, since here is /etc/my.cnf
Any ideas what I should check??
Thanks, S.Alexiou
# Example mysql config file for very large systems.
#
# This is for large system with memory of 1G-2G where
# the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/mf.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
(in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the
program supports.
# If you want to know which options a program support,
run the program
# with --help option.
# The following options will be passed to all MySQL
clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer_size=500M
set-variable = key_buffer=100M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = max_connections=10
set-variable = tmp_table_size=400M
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
set-variable = thread_concurrency=4 # Try number of
CPU's*2
#set-variable = myisam_sort_buffer_size=64M
set-variable = myisam_sort_buffer_size=4M
# Heiki says add:
innodb_data_home_dir=
#and then use absolute file paths
#innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdat
a3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdat
a7:2000M;ibdata8:2000M
innodb_data_file_path=/var/lib/mysql/ibdata1:2000M;/var/
lib/mysql/ibdata2:2000M;/var/lib/mysql/ibdata3:2000M;/va
r/lib/mysql/ibdata4:2000M;/var/lib/mysql/ibdata5:2000M;/
var/lib/mysql/ibdata6:2000M;/var/lib/mysql/ibdata7:2000M
;/var/lib/mysql/ibdata8:2000M;/usr/ibdata/ibdata9:2000M;
/usr/ibdata/ibdata10:2000M;/usr/ibdata/ibdata11:2000M;/u
sr/ibdata/ibdata12:2000M;/ibdata/ibdata13:2000M;/ibdata/
ibdata14:2000M;/ibdata/ibdata15:2000M;/var/lib/mysql/ibd
ata16:2000M;/var/lib/mysql/ibdata17:2000M;/var/lib/mysql
/ibdata18:2000M;/var/lib/mysql/ibdata19:2000M;/var/lib/m
ysql/ibdata20:2000M;/var/lib/mysql/ibdata21:2000M
#;/usr/ibdata/ibdata9:2000M;/usr/ibdata/ibdata10:2000M
## Comment next line if you do not need recovery(the
hostname-bin.xxx files)
#log-bin
##
server-id = 1
#set-variable = open-files-limit=8192 #ulimit is
1024,hard 8192
set-variable = innodb_buffer_pool_size=1100M
# so that innodb_buffer_pool
size+key_buffer+max_connections*
(sort_buffer+record_buffer+2M)=1100+100+10*(2+2+2)
=1260<2000M=RAM
set-variable = innodb_additional_mem_pool_size=700M
set-variable = innodb_log_file_size=1000M
set-variable = innodb_log_buffer_size=20M
# helps for large transactions
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=384M
#set-variable = bdb_max_lock=100000
# Point the following paths to different dedicated
disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable = max_allowed_packet=256M
[mysql]
no-auto-rehash
#safe-updates # Remove the comment character if you
are not familiar with SQL
[isamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
#set-variable = key_buffer=256M
#set-variable = sort_buffer=256M
#set-variable = read_buffer=2M
#set-variable = write_buffer=2M
set-variable = key_buffer=25M
set-variable = sort_buffer=25M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Παράθεση David Lloyd <[EMAIL PROTECTED]>:
>
> Hmmm,
>
> (mysql, query)
>
> > Thanks
>
> That's OK.
>
> > It's 2.4.18
>
> Sorry, I meant distribution...eg is it RedHat,
Slackware ;-?
>
> > So, I will try to unistall and install from the
> > tarball, yes?
>
> It wouldn't hurt. How did you install it in the first
place?
>
> DSL
> --
> Con te partiro, su navi per mari
> Che io lo so, no, no non esistono piu
> Con te io li vivro.
> (Sartori F, Quarantotto E)
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php