Hi Mike,
i'm a newbie in optimizing the inner structure of a db - so i stick to the
os-part where i might have a vague clue ;-)
did you take a look at the memory / swap-space mysqld used when doing the
query?
(maybe use TOP (add swap to the view by hitting "f" and then "o"), look at
the swapspace
--
-
- Nikolas Galanis -
- Computer Engineering & Informatics Department -
- University of Patras -
- http://www.ceid.upatras.gr-
- 061 99
ion_views` smallint(5) unsigned NOT NULL default '0',
`date_added` timestamp(14) NOT NULL,
PRIMARY KEY (`poem_id`,`language`,`made_by_id`),
KEY `language` (`language`)
) TYPE=MyISAM
Paul DuBois wrote:
At 2:09 +0200 11/7/02, Galanis Nikolas wrote:
Yes, that is exactly what happens. It
:
> At 23:47 + 11/6/02, Nikolas Galanis wrote:
> >Hello
> >
> >I have a column of type timestamp(14) and I thought it would not be
> >updated on a query with simple select statements, though it does! I
> >read in the manual that it
> >shouldn't, what cou
Hello
I have a column of type timestamp(14) and I thought it would not be
updated on a query with simple select statements, though it does! I read in the manual that it
shouldn't, what could be wrong? Thanks.
-
Bef
Hello
I was wondering about the following:
I am hosting an application with a web hosting company and the character
set doesn't satisfy me because I am doing some sorting of greek names
and the hosting company uses the default character set for the mysql
server. Is it possible that they let my
Hi
I have written a web application that is hosted in a server which uses
the default character set. This causes problems in the sorting that
MySQL does because most of the data is in Greek. When developing it
locally, I run the MySQL server with the greek character set and sorting
works fine.
Hello
When I want to update a value, I can use numerical functions like +,*
etc. Can I do the same with strings? For example, when I want to append
a string in an existing value, how (if of course) can I do it inside the
update query? Thanks.
Nikolas
p.s: I know I can do it with PHP, I was
think, in the meantime, I found the way. I will make a COUNT of all
pages, then I will
make a COUNT of the pages that have been visited less times than the one
I want and
then I will add 1 to that. Am I in the right direction. Thanks for your
interest.
Roger Baklund wrote:
>* Nikolas
>
I am novice in SQL so I may ask something very obvious, sorry.
If I have a table ordered by something, is it possible to select fields
from a record that appears on the table in a specific row number. And if yes, how can
I do it?
By row number, I mean that if the table has 10 records, I want t
idea. Thanks.
Nikolas
-
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 unsub
11 matches
Mail list logo
