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
2)
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 Maili
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:h
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 buffe
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:ht
> 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 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
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 My
root[root] @ 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'
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:
&g
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 re
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
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.
>
&
tz <[EMAIL PROTECTED]> wrote:
> 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://d
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 ('+"f
y much!
>
> Regards,
>
> Jerry 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
>
>
> &
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
>
cords in here,
> that's going to kill you.
You're right, but I didn't find another better way. What do you think
it's better?
>
> - michael
>
>
> On 9/19/07, thomas Armstrong <[EMAIL PROTECTED]> wrote:
> > Hi.
> >
> > I've got t
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 friend
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 '/e
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?
--
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, thoma
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 '
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 PROTE
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 much.
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 o
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
only two files:
--
-rw-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]>
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 ha
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.
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 | Slee
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
