Thanks.. It doesn't seem to work though.. I did verify I am on 5.0
Try lose the space after group_concat.
PB
Andrey Dmitriev wrote:
Thanks.. It doesn't seem to work though.. I did verify I am on 5.0
mysql> select service_names.name as 'Service',
-> group_concat (hosts.name)
-> from
I.e. the ideal output would be:
+---+-+
| id| start_date |
+---+-+
| 109k7 | 2007-10-07 12:06:58 |
| s3x6 | 2007-10-07 08:58:20 |
| wt57 | 2007-10-07 15:57:37 |
| sxmns | 2007-10-06 02:17:30 |
+---+-+
What rul
Thanks.. It doesn't seem to work though.. I did verify I am on 5.0
mysql> select service_names.name as 'Service',
-> group_concat (hosts.name)
-> from monarch.hosts as hosts, monarch.services as services,
monarch.service_names as service_names
-> where
-> hosts.host_id=servic
Hello,
I have a query like:
SELECT id, start_date FROM iddt WHERE id IN ('109k7','s3x6','sxmns','wt57');
which gives me:
+---+-+
| id| start_date |
+---+-+
| 109k7 | 2007-10-07 12:06:58 |
| sxmns | 2007-10-06 02:17:30 |
| wt57 | 2007-10
On Thu, 25 Oct 2007, [EMAIL PROTECTED] wrote:
Not sure that I get the whole picture.
We have been running replication since about 4.0 and we have been through
several upgrades and are now at 5.0.27.
The 'show slave status' always gives us an accurate reflection of where it is
at which is us
How about this ...
update schedule s
join directory d on s.email = replace(d.email, '@wnc.edu', '@wncc.edu')
set s.email=replace(s.email, '@wncc.edu', '@wnc.edu' );
PB
-
Kevin Murphy wrote:
I'm trying to do a join on two pieces of data that are not quite
exactly the same. Basic story, I h
I'm trying to do a join on two pieces of data that are not quite
exactly the same. Basic story, I have 2 tables (output from 2
mainframes) in MySQL where one table has our email addresses as
@wncc.edu (our old name) and the other has it as @wnc.edu (our new
name). So here is an abbreviated
I have a database of products, doing a search on them trying to achieve a
modicum of relevancy, but am getting a strange result on some returned rows:
QUERY:
select *,match(code) against ('vic*' IN BOOLEAN MODE) * 8 + match(name)
against ('vic*' IN BOOLEAN MODE) * 4 + match(small_desc) against ('v
Hi,
Andrey Dmitriev wrote:
This is kind of achievable in Oracle in either sqlplus mode, or with the
use of analytical functions. Or in the worst case by writing a function.
But basically I have a few tables
Services, Hosts, service_names
And I can have a query something like
select servic
This is kind of achievable in Oracle in either sqlplus mode, or with the
use of analytical functions. Or in the worst case by writing a function.
But basically I have a few tables
Services, Hosts, service_names
And I can have a query something like
select service_names.name as 'Service', host
ok thanks,
this mysql has got a replication slave...
On the slave the ibdata has got a size close to 15Go (ie the master's size
is 22Go)
have you got an idea about this ???
thanks
2007/10/29, Dan Nelson <[EMAIL PROTECTED]>:
>
> In the last episode (Oct 29), Thomas Raso said:
> > 2007/10/29, Da
sudo apt-get install mysql-server
Should install it. It will even create the user account for you...
http://www.supriyadisw.net/2006/12/lamp-installation-on-ubuntu
Has further information. Scroll down to MySQL.
On 10/29/07, Tim Johnson <[EMAIL PROTECTED]> wrote:
>
> Hello:
> I am preparing to i
In the last episode (Oct 29), Thomas Raso said:
> 2007/10/29, Dan Nelson <[EMAIL PROTECTED]>:
> > In the last episode (Oct 29), Thomas Raso said:
> > > i don't understand the size of the ibdata7
> > >
> > > -rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1
> > > -rw-rw1 mysqlm
There is no way whitout stopping mysql ?
for information it is a version 4.1
2007/10/29, Dan Nelson <[EMAIL PROTECTED]>:
>
> In the last episode (Oct 29), Thomas Raso said:
> > i don't understand the size of the ibdata7
> >
> > -rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1
> > -
In the last episode (Oct 29), Thomas Raso said:
> i don't understand the size of the ibdata7
>
> -rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1
> -rw-rw1 mysqlmysql2.0G Oct 29 15:17 ibdata2
> -rw-rw1 mysqlmysql2.0G Oct 29 15:17 ibdata3
> -rw
Ananda Kumar wrote:
Hi,
Try this.
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
Rather:
set session collation_database=utf8_general_ci;
set session character_set_database=utf8;
Also, make sure you have these in my.cnf:
[client]
default-charact
hi all,
i don't understand the size of the ibdata7
-rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1
-rw-rw1 mysqlmysql2.0G Oct 29 15:17 ibdata2
-rw-rw1 mysqlmysql2.0G Oct 29 15:17 ibdata3
-rw-rw1 mysqlmysql2.0G Oct 29 15:0
At 04:13 AM 10/29/2007, Devi wrote:
I'm running only MySQL in that machine. That's why i can't understand why
it consumes only 50% of CPU.
Because MySQL has to wait for the hard disk. If your table fits into
memory, then make it a memory table and CPU utilitization should increase
dramatica
Hi !
Devi wrote:
Hi,
I'm running only MySQL in that machine. That's why i can't understand why it consumes only 50% of CPU. Interestingly its nice% is also 0.
Like any other user program
(as seen from the operating system point of view),
the MySQL server will use all CPU cycles it is gr
no.. i had an impression that the slowness can be perfectly measured only if i
have very less idle CPU.. My worries how to make MySQL to utilize the fullest
CPU time.. either in User/Nice mode.
Thanks
DEVI.G
- Original Message -
From: Ananda Kumar
To: Devi
Cc: mysql@lists.mys
B. Keith Murphy 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 than reiserfs.
Those fast writes come at a price.
There is no way I'd have any important data on XFS.
Dave
Thanks for the answer :)
Yes, you are right about fedora. I forgot to tell that we are moving the
servers to CentOS 5 now :) i think also that other important thing that
i forgot to tell is that our databases use INNODB engine.
i'm waiting for other opinions.
--
MySQL General Mailing List
F
with this CPU load, is there any database slowness or any other issues.
regards
anandkl
On 10/29/07, Devi <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm running only MySQL in that machine. That's why i can't understand why
> it consumes only 50% of CPU. Interestingly its nice% is also 0.
>
> I me
Hi,
I'm running only MySQL in that machine. That's why i can't understand why it
consumes only 50% of CPU. Interestingly its nice% is also 0.
I mean only if MySQL utilizes the full CPU, i can estimate the performance of
MySQL for different Client Applications.
Thanks
DEVI.G
- Origi
This says, that all app running on this machine are using 50% CPU (50%us).
"If not wrong, for any application, we can estimate the performance level
only it its idle time is less than 5%."
What do u mean by the above statement.
regards
anandkl
On 10/29/07, Devi <[EMAIL PROTECTED]> wrote:
>
>
Hi Anand,
Thanks for the immediate response.
The us% is around 50 and sy% is around 10. Other than idle some 3-5% was
given to software & hardware interrupts.
If not wrong, for any application, we can estimate the performance level
only it its idle time is less than 5%.
Thanks
DEVI.G
---
26 matches
Mail list logo
