Hi
I wondered how you are getting on with installing SSL for mysql 5.1 server.
We are looking to install it too. Do you have any pointers/recommendations
?
Regards
Neil
On Tue, Sep 8, 2009 at 11:36 PM, qt4x11 qt4...@gmail.com wrote:
I'm trying to set up my mysql 5.1 server to work over ssl,
2009/10/7 Brown, Charles cbr...@bmi.com:
Hello All. I would like to implement MYSQL slow query log in table. Can
someone kindly assist me with the table definition and implementation.
SHOW CREATE TABLE mysql.slow_log;
http://dev.mysql.com/doc/refman/5.1/en/log-tables.html
--
Jaime Crespo
Hello. Thanks for quick response. I'm running Mysql 5.0. We have no plans to
upgrade to 5.1 that supports slow-log table. Do you know of any work around to
get my slow query into a table -- just wondering. Desperate for a resolution or
circumvention.
-Original Message-
From: Jaime
Hi All,
I tried to build RPM with version 5.1.23 source package,
mysql-5.1.23a-maria-alpha.tar.gz and mysql-5.1.23-rc.tar.gz. Both failed
on missing a few executable files. I couldn't find those files in the
tarball. And for mysql_explain_log, it seems deprecated in 5.1? Any one
could shed
Hi,
I have a table that stores article views per day per article:
`post_id` int(11) NOT NULL,
`date` date NOT NULL,
`views` int(11) NOT NULL
A couple of entries:
1987 2009-10-04 1744
1583 2009-10-04 2626
1238 2009-10-04 2211
This works fine - but I am now trying to figure out whats the best
Hi.
I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server but
switched my database to another machine, on a Windows Server 2008. Problem
is, the connection to that other server (which is on the same network) is
very slow, taking 4-6 seconds every time. That is impossible to use
Never mind, my bad.
Hi All,
I tried to build RPM with version 5.1.23 source package,
mysql-5.1.23a-maria-alpha.tar.gz and mysql-5.1.23-rc.tar.gz. Both
failed on missing a few executable files. I couldn't find those files
in the tarball. And for mysql_explain_log, it seems deprecated in 5.1?
1) When I select * from whatever; is there a way to have the results go
by one screen at a time?
2) In reference to the above, is there a way to just display the row
that shows the names of each column?
I need to drop one row from a table with a few thousand rows. I
guessing I want to:
delete
On 10/8/2009 4:19 PM, John Oliver wrote:
1) When I select * from whatever; is there a way to have the results go
by one screen at a time?
You can limit output by delimiting your search ie
select * from users limit x,y;
x=offset
y=rows after the ofset
2) In reference to the above, is
On Thu, Oct 08, 2009 at 02:33:34PM -0700, Carlos Proal wrote:
On 10/8/2009 4:19 PM, John Oliver wrote:
1) When I select * from whatever; is there a way to have the results go
by one screen at a time?
You can limit output by delimiting your search ie
select * from users limit x,y;
Try the tutorial:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
Regards,
Gavin Towey
-Original Message-
From: John Oliver [mailto:joli...@john-oliver.net]
Sent: Thursday, October 08, 2009 2:19 PM
To: mysql@lists.mysql.com
Subject: Some MySQL questions
1) When I select * from
Damn I just said I wrote slot instead of slow...
Well I solved the problem, we added the client ip on the etc/hosts file on
the server. Now its pretty fast.
2009/10/8 Kim Delevati kim.delev...@gmail.com
Hi.
I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server
but
ALTER TABLE articles ADD INDEX date_idx (date);
-Original Message-
From: Ian [mailto:barnrac...@gmail.com]
Sent: Thursday, October 08, 2009 12:23 PM
To: mysql@lists.mysql.com
Subject: Trying to index a table - cant figure out best way
Hi,
I have a table that stores article
Hi, MySQL Developers
I'm a beginner of MySQL, and so I'm in a trobble. in MySQL 5.0.45
and acctually, I'm trying to migration my application
from Oracle to MySQL
I'd like to use nowait option (of Oracle) in MySQL when locking one record.
but I could not find nowait oitpin in MySQL.
so I have
Hi Daevid,
Thanks - have tried this - but an explain still shows that its going through
all the articles. See below - note these arent all records, ive taken a
snapshot of the views for a 2 week period to test with:
This is without the index:
1 SIMPLE article_views ALL *NULL* *NULL* *NULL*
15 matches
Mail list logo