Thanks Tom!
Ya it was a problem of SELinux but i had to turn it off from GUI not from
CUI(system-config-securitylevel).
It really did worked.
Thanks Again :)
- Original Message -
From: "Tom Brown" <[EMAIL PROTECTED]>
To: "Atul Aggarwal" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, March 01,
Hi,
We found a severe performance degradation when Hyperthreading is on
and thread_concurrency=20.
We are using OSDL DBT-1 as the benchmark and got about 200 to 250
BT (bogotransactions per second) HT is OFF normal case but 30 to
50 BT on HT is ON.
innodb_thread_concurrency=20
So we did profil
I finally ended up removing and installing back my mysql since i have
to success retrieving my mysql root password.
Now I am putting my databases back. It shows an error something that
it couldn't write unto file already exists. What I did I change the
permission of the directory like thi
Good point about the bin-logs. Yup - that would sink it. If mysql used individual binary logs per master database, it would work.
Ya, if someone was silly enough to have two different databases with the same name, it would be bad, even with separate binary
logs for each database.
If you have tw
- Original Message -
From: Vinay
To: mysql@lists.mysql.com
Sent: Wednesday, March 01, 2006 5:00 PM
Subject: Enforcing Isolation in MySQL database
Hello ,
I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the
default isolation. Is the concurrency enforced automatic
Sorry:-\ Meant to say
I do not understand why mySQL is pointing to this as an error
Bob
-Original Message-
From: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 01, 2006 5:30 PM
To: 'mysql'
Subject: Unknown column 'testcase_root.Test' in 'order clause'
I am
I am receiving an error "Unknown column 'testcase_root.Test' in 'order clause'
I do not understand why the error is pointing to this as an error, nor if it
means anything that the name of the column is correctly identified in the query
below as testcase_root.TestID. I have checked the DB and th
Hello ,
I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the
default isolation. Is the concurrency enforced automatically by the database or
is there anything
the application programmer has to do to make sure the data consistent.
How does the REPEATABLE-READ resolve the f
MySQL cannot handle more than one incoming binlog at a time. The
facilities are just not in the code.
You also run into a nightmare if a database exists on BOTH masters (same
name on both systems) and the PK values of any tables (also with matching
names) overlap. If both masters update the
That's not entirely true.
You can have two instances of mysql running on the slave, and dbA connects to
one instance, and dbB connects to the other.
Jeff, when you say, "different databases", do you mean that each master has a
single mysql instance, and if you typed on M1,
"show databases"
On 3/1/06, Bing Du <[EMAIL PROTECTED]> wrote:
> We're running several mysql servers for different applications on
> different machines. Instead of connecting to each mysql server manually
> to find out basic information, e.g. versions, mostly like what 'show
> variables' returns, plus what databas
On 3/1/06, Jeff <[EMAIL PROTECTED]> wrote:
> Does anyone know if it's possible to replicate to a single slave from
> different databases on different masters?
>
> For instance:
>
> M1:dbAM2:dbB
> \ /
> rep rep
> \ /
> Slave
http://dev.mysql.com/doc/refman/5.1/en/r
Does anyone know if it's possible to replicate to a single slave from
different databases on different masters?
For instance:
M1:dbAM2:dbB
\ /
rep rep
\ /
Slave
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
bobgoodwin wrote:
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning
exercise for me!
I am using O'Reilly's MYSQL Cookbook, have gone through numerous
pages of the "reference manual" and stuff on Google but still can get
the proper commands and syntax to alter the following
[snip]
We're running several mysql servers for different applications on
different machines. Instead of connecting to each mysql server manually
to find out basic information, e.g. versions, mostly like what 'show
variables' returns, plus what databases exist on each server, are there
any tools th
Hello everyone,
We're running several mysql servers for different applications on
different machines. Instead of connecting to each mysql server manually
to find out basic information, e.g. versions, mostly like what 'show
variables' returns, plus what databases exist on each server, are there
an
Hi all.
I've read the instructions at
http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html.
It says
The basic commands that you must execute to install and use a MySQL binary
distribution are:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /pa
I have disabled selinux but no luck
how?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have disabled selinux but no luck
[EMAIL PROTECTED] ~]# system-config-securitylevel
Security Level (*) Disabled OK
[EMAIL PROTECTED] ~]# /etc/init.d/mysql start
Starting MySQL... [FAILED]
[EMAIL PROTECTED] ~]#
I am receiving these errors in /var/lib/mysq
On Wed, 1 Mar 2006, Price, Randall wrote:
} Try the following:
}
} REPLACE(products_description, CHAR(9), " ")
Thanks, Randall, that did it. And I feel quite stupid, as well, because I
re-checked my two test entries [33 and 37] and both had had their tabs
removed at some point. So it turns out
I didn't get it :( for example, I'm using:
SELECT * INTO OUTFILE 'result_a.csv' FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM lista_switches;
But this only saves the rows of data, with no column name; I would like to
store the column name so the .csv is easie
[snip]
This function is great! Anyone know how to include the column names, table
info, any extra miscellaneous info? I use SQLyog for exporting to csv and they
do include the columns, my bet is its some SQL option. The manual doesn't
specify, at least in the select syntax part.
[/snip]
Any sel
This function is great! Anyone know how to include the column names, table
info, any extra miscellaneous info? I use SQLyog for exporting to csv and they
do include the columns, my bet is its some SQL option. The manual doesn't
specify, at least in the select syntax part.
Ariel
-Mensaje or
"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:08:10 AM:
> Does MySQL have support for temporary tables inside stored procedures?
>
> _
> Express yourself instantly with MSN Messenger! Download today - it's
FREE!
> http://messeng
> What is the rowsize limitation in MySQL?
That depends on the table type, for example, take a look here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoug
"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:06:27 AM:
> What is the rowsize limitation in MySQL?
>
> _
> Don’t just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:04:50 AM:
> Does MySQL have the ability to send resultsets from stored procedures?
> (similar to ref cursors in Oracle).
>
> _
> FREE pop-up blocking with the new MSN Toolbar – get it
Does MySQL have support for temporary tables inside stored procedures?
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
MySQL General
What is the rowsize limitation in MySQL?
_
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
Does MySQL have the ability to send resultsets from stored procedures?
(similar to ref cursors in Oracle).
_
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
Try the following:
REPLACE(products_description, CHAR(9), " ")
Randall Price
VT.SETI.IAD.MIG:Microsoft Implementation Group
http://vtmig.vt.edu
[EMAIL PROTECTED]
-Original Message-
From: Vince LaMonica [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 01, 2006 10:44 AM
To: mysql@lists.
On Wed, 1 Mar 2006, Vince LaMonica wrote:
} update products_description set products_description =
} replace(`products_description`,'\t',' ') where products_id = "37";
[snip]
I should have also stated that in the above example, both the table name
and the column name are the same - that's not a
On Wed, 1 Mar 2006 [EMAIL PROTECTED] wrote:
} [snip]
} Does anyone have any suggestions? The mysql server [and client] are
} running under Linux. The products_description field is a 'text' type. If
}
} there's further info you need, please let me know.
} [/snip]
}
} Are you using REPLACE(column
Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for
pid=20857 comm="mysqld" scontext=root:system_r:mysqld_t
tcontext=root:system_r:mysqld_t tclass=process
you have enabled selinux
disable it or learn how to use it correctly
--
MySQL General Mailing Lis
[snip]
Does anyone have any suggestions? The mysql server [and client] are
running under Linux. The products_description field is a 'text' type. If
there's further info you need, please let me know.
[/snip]
Are you using REPLACE(column_name, '\t', ' ') ?
--
MySQL General Mailing List
For list a
Hi all,
I am trying to use the replace() function in MySQL 4.1.13a to find and
remove tab characters. I'm not sure how to signify the tab char, however.
I've tried, "\t" to no avail:
update products_description set products_description =
replace(`products_description`,"\t"," ") where product
In the last episode (Mar 01), Giuseppe Maxia said:
> Yesterday I was analyzing the behavior of the query optimizer, and I
> stumbled into a most curious case. I created two functions returning
> the extremes of a date range, and I wanted to see how many times
> those functions were called when used
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning
exercise for me!
I am using O'Reilly's MYSQL Cookbook, have gone through numerous pages
of the "reference manual" and stuff on Google but still can get the
proper commands and syntax to alter the following table "T1."
I wou
"Shaun" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
The following 3 queries on their own produce more rows than if I UNION
them
together:
SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year,
CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month,
CONCAT('USR_', B.User_I
The UNION Syntax is:
SELECT ...
UNION [ALL | DISTINCT]
SELECT ...
[UNION [ALL | DISTINCT]
SELECT ...]
Lower in the manual it says:
* A DISTINCT union can be produced explicitly by using UNION
DISTINCT or implicitly by using UNION with no following DISTINCT or ALLkeyword.
*
**
So the
Hi,
The following 3 queries on their own produce more rows than if I UNION them
together:
SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year,
CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month,
CONCAT('USR_', B.User_ID) AS User,
Booking_Status,
CONCAT('W_', Work_Type_ID) AS Day_Type,
'1'
Hi,
I am using MYSQL 4.1. But since yesterday I am not able to start the mysqld
daemon.
I am receiving these errors in /var/lib/mysql/*.err
060301 14:32:08 mysqld started
060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976
InnoDB: Error: pthread_create returned 11
Yesterday I was analyzing the behavior of the query optimizer, and I stumbled
into a most curious case.
I created two functions returning the extremes of a date range, and I wanted to
see how many times those functions were
called when used in a WHERE clause So I added log tracing instructions to
Thanks for all,
I have changed the user, and it runs correctly.
Amaia
From: Edwin Cruz <[EMAIL PROTECTED]>
To: "George Law" <[EMAIL PROTECTED]>
CC: "Amaia Anabitarte" <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject: RE: jdbc:mysql
Date: Tue, 28 Feb 2006 10:33:34 -0600 (CST)
does the user
44 matches
Mail list logo
