Hi.
I've got mySQL 4.1.22 installed from sources on Linux
---
./configure --prefix=/usr/local/mysql
and PHP 4.4.2 installed from sources
---
./configure --prefix=/usr/local/php --with-mysql=/usr/local/mysql
I want to upgrade mySQL from 4.1.22 to 5.0.5 by doing:
1) export DB
Hi.
I've installed 'mytop' on my Linux server and would like to log the
data provided in order to store it for future situations.
Does anybody know how to perform it? Thank you very much,
--Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi.
I've been finding some queries by using 'mytop' which takes +200
seconds to be executed. It wastes tons of CPU resources on my server
and would like to detect them automatically and kill them.
Does anybody have experience with this issue? Thank you very much,
--Thomas
--
MySQL General
Hi
Using MySQL 4.1.19 on Linux, my server's CPU load is very high. I want
to cut it down but I don't know which parameters I might modify to do
it.
These are my server's data:
back log50
basedir /usr/
bdb cache size 8,388,600
bdb home/var/lib/mysql/
bdb log
Hi.
Using MySQL on Linux, I'd like to analyze the performance and know how
resources (memory, threads) are used during a period of time.
Do you know any tool to carry it out? Thank you very much.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi.
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer too many
connections error but I cann't set 'max_connections' parameter to a
value bigger than 250.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed
Hi Tiago. Thank you very much for your answer.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed MySQL from sources on '/usr/local/mysql'. Is it as easy
as installing it again on '/usr/local/mysql5'?
Yep. Just change the '--prefix' com './configure' time.
ok
Make sure you use the mysqldump from version 5 and not version 3. Also
recheck all your application queries once you have restored the data the
list of changes SQL syntax might haunt you.
But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3?
--
MySQL General Mailing List
Hi.
I'm suffering a severe slowness of my server (mySQL 3.23), and want to
detect Slow Queries.
I installed mySQL on '/usr/local/mysql', and works ok. But if I insert
this line into '/etc/my.cnf':
-
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long_query_time = 5
-
it won't
I also tried with:
---
set-variable=long_query_time=5
--
mySQL starts ok, but all queries within the file are:
# Query_time: 0 Lock_time: 0 Rows_sent: 119 Rows_examined: 238
The aren't slow queries, are they?
On 10/4/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
I'm suffering
] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 20
This is not a slow query, is it?
On 10/4/07, Jørn Dahl-Stamnes [EMAIL PROTECTED] wrote:
On Thursday 04 October 2007 14:06, thomas Armstrong wrote:
Hi.
I'm suffering a severe slowness of my server (mySQL 3.23
Hi.
Using mySQL 4.1.22, I'd like to carry out an SQL query to find a
string containing acute vowels.
mytable:
- item1:
--- firstname: Antonio
--- lastname: Fernández
--- comments: he's from Spain
My SQL query:
--
SELECT id FROM mytable WHERE MATCH(firstname, lastname, comments)
AGAINST
:
thomas Armstrong wrote:
If you need something more complicated, such as only ignoring (, then you
need to get more complicated. You might even need a regular expression.
I'm to browse:
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
http://www.wellho.net/regex/mysql.html
You know
My ft configuration in /etc/my.conf:
--
ft_min_word_len=1
ft_stopword_file=''
-
On 9/21/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
Using mySQL 4.1.22, I'd like to carry out an SQL query to find a
string containing acute vowels.
mytable:
- item1:
--- firstname: Antonio
Hi Edward. Thank you very much for your answer.
I tried adding these two lines after DB connection (PHP code):
---
mysql_query (SET NAMES utf8;);
mysql_query (SET CHARACTER_SET utf8;);
--
but it won't work :(
The solution you provided could be right because it works, but I don't
dare to
/19/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT
Thank you Chris for your answer.
On 9/19/07, Chris Sansom [EMAIL PROTECTED] wrote:
Well I'm hardly the world's greatest expert, but I'm curious as to
why you're always separating '%' from 'johnie' with a space, because
that way it will only find Johnie if he has a space before or after
him
Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: thomas Armstrong [mailto:[EMAIL PROTECTED]
Sent: Wednesday
Hi.
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT friends.id FROM friends WHERE ((friends.firstname LIKE '%
johnie %' OR
Hi.
Using mySQL 3.23.58, I'm trying to log slow queries and I made:
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long-query-time = 5
(into my '/etc/my.conf' file)
However, I get this error message:
unrecognized option `--long-query-time=5'
Is this parameter supported in mySQL 3?
I also tried with long_query_time = 5
but got the same error :(
On 7/12/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
Using mySQL 3.23.58, I'm trying to log slow queries and I made:
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long-query-time = 5
(into my '/etc/my.conf' file
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created a
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created a
Fixed:
[]# kill `cat /usr/local/mysql/var/server.pid`
[]# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
[]# /usr/local/mysql/bin/mysql
mysql update user set password = password('xxx') where user =
'root' and host='localhost';
On 2/20/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi
Hi.
Using mySQL v4.1.9 on Fedora Core 2, I'm suffering a shutdown everyday
around 04:30. These are the contents of 'mysqld.log':
/usr/sbin/mysqld: ready for connections.
Version: '4.1.9-standard-log' socket: '/var/lib/mysql/mysql.sock'
port: 3306 Source distribution
070201 4:29:40 [Note]
Hi.
There's a lot of '/tmp/ibE3FYj2' files inside my Linux server, created
by mysqld.
Does anybody know how to delete them after being used?
Thank you very much.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi.
I've got three tables (users, books and news), and I would like to
crete a web interface
to manage their data (create items, modify items, delete items).
Is there any PHP script to create it automatically (in the same way
phpMyAdmin does, but
with less functionalities)?
Thank you very
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't
Hola.
With mySQL 4.0.27 I'm trying to create this table
--
CREATE TABLE `test`.`user` (
`user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`email` TEXT CHARACTER SET COLLATE NULL ,
`firstname` TEXT CHARACTER SET COLLATE NOT NULL ,
)
--
but I get this error:
--
#1064 - You have an
Hi.
Working with mySQL 3.23.58 on Linux, I get this error when trying to
start mysqld:
060716 03:07:21 mysqld started
060716 03:07:21 /usr/local/mysql/libexec/mysqld: Table 'mysql.host'
doesn't exist
060716 03:07:21 mysqld ended
-
This Linux machine
-rw 1 mysql root0 may 30 2005 func.MYD
-rw-rw 1 mysql root 8877 may 30 2005 tables_priv.frm
Where are 'host.frm', 'host.MYD' and 'host.MYI'?
On 7/16/06, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
Working with mySQL 3.23.58 on Linux, I get this error when trying
Hi.
Using MySQL 4.1.9 on Linux FedoraCore2 (kernel 2.6.9),
I'm suffering several memory problems ('Out Of Memory'
problem) on my server.
Playing around with my server:
SHOW PROCESSLIST
Id | User | Host | db | Command | Time | State | Info
20138 | user1 | localhost | user1_db |
Hi.
Using MySQL 4.1.9 on Linux FedoraCore2 (kernel 2.6.9),
I'm suffering several memory problems ('Out Of Memory'
problem) on my server.
I've noticed that '/var/log/mysqld.log' is 2Mb, and
'/var/log/mysqld.log.1', 'mysqld.log.2', .. are empty.
Is 2Mb to high to be handled? Thank you very much.
Hi.
Working on Linux Fedora Core 2.
I'm programming an application which requires version 14 of the MySQL Client
libraries. Now I've got version 10:
---
[EMAIL PROTECTED] mysql_config --libs
-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm
[EMAIL PROTECTED] locate mysqlclient
34 matches
Mail list logo