Hi Devi,
If idle time is around 37%, it means your cpu is 63% utilized. It again
depends on what kind of query is running on ur system.
Can u also please check %us, %wa and %sy.
%us will give amount cpu utilized by any applicaiton running on the machine.
%wa will give amount of wait io.
%sys wil
Hello friends,
I'm using MySQL5 on RHEL5. From the top, i understood that the CPU is under
utlized by MySQL, whose idle time is around 37%. It is dedicated box for MySQL
alone. Is there any way to reduce the idle time of the CPU or how can i make
my MySQL to Utilize the full CPU time.
Thank
Hi,
Try this.
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
regards
anandkl
On 10/29/07, Dušan Pavlica <[EMAIL PROTECTED]> wrote:
>
> Are you sure your file is coded in utf8? Character set of your file must
> be same as charset of your database.
>
Are you sure your file is coded in utf8? Character set of your file must
be same as charset of your database.
Dusan
Caleb Racey napsal(a):
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mys
Hello:
I am preparing to install the latest mysql server on ubuntu - I think it will
be version 5+. It has been some time since I have done a setup and I would
appreciate updated instructions.
The ubuntu install via Adept Manager will ask for a root password.
Following that I know that I must add
You seemed to have answered your own question. What did you mean to ask?
On 10/28/07, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
>
> I dashed off this email too fast. What I meant to say was "I am
> migrating our data partitions for MySQL from reiserfs to xfs because xfs
> has faster write rates
I dashed off this email too fast. What I meant to say was "I am
migrating our data partitions for MySQL from reiserfs to xfs because xfs
has faster write rates than reiserfs.
Craig Huffstetler wrote:
I agree, Fedora is not very good at production work. Reiserfs is one
of the best file system
In production we use both reiserfs and xfs. I am migrating our data
partitions for mysql because it has faster write rates than reiserfs.
You need to stop using fedora and at least use CentOS. Fedora is not
stable for production work.
Just my two cents :)
Keith
Ali Nebi wrote:
Hi,
i wan
Hi,
i want to ask for your opinions about the best combination for mysql
with filesystem (like ext2, ext3... and so on).
We have problems with mysql under fedora 6 with ext3 and i want to
know under wich filesystem mysql works best.
I will be glad to read your opinions.
Thanks in advance
Martin Gainty wrote:
Good Morning-
Good afternoon :-)
http://www.mysqlperformanceblog.com/2006/09/04/group_concat-useful-group-by-
extension/
I did'nt see your where clause ?
I'm probably missing your point here. But there's no "where clause"
because I want all records from the tickets tab
Baron Schwartz wrote:
I'm tempted to solve this using a view or two, but would like to know
if there's a better way.
GROUP_CONCAT() takes an optional DISTINCT modifier, and that might do
what you're looking for.
It sure does the trick. I'll use that, I was afraid that I was missing
somet
Hi,
Morten wrote:
Hi,
I'm trying to write a query which returns a single record which contains
concatenated values for referencing records:
SELECT tickets.id AS id,
CAST(GROUP_CONCAT(tags.name SEPARATOR ' ') AS CHAR) AS tags,
CAST(GROUP_CONCAT(events.value SEPARATOR ' ') AS CH
Hi,
I'm trying to write a query which returns a single record which contains
concatenated values for referencing records:
SELECT tickets.id AS id,
CAST(GROUP_CONCAT(tags.name SEPARATOR ' ') AS CHAR) AS tags,
CAST(GROUP_CONCAT(events.value SEPARATOR ' ') AS CHAR) AS text
FROM tic
Dan Nelson wrote:
In the last episode (Oct 27), Baron Schwartz said:
InnoDB has the following extra things, plus some things I might forget:
a) the primary key B-Tree
b) row versioning information for every row
c) 16k page size; each page might not be completely full
Those are all counted towa
14 matches
Mail list logo