Hi and thanks for the answers.
As I understand from what I've read in the comments here:
http://www.xaprb.com/blog/2006/07/16/how-we-enabled-threading-in-mysql/
This might be normal behaviour.
Apparently the different types of threading used on the boxes (LinuxThreads
vs NPTL) can result, for the
Hi All,
Can you please suggest any good third party software for backup and restore
of mysql db.
Right now i am looking at ZMANDA. Has any one worked on this, and used for
their production db, please let me know how it is and can we use the same
for our production 24/7 mysql db.
regards
anandkl
Hi Arjan,
Any plans to port Database Workbench to linux?
No, there will be no native Linux Database Workbench. From what I've
heard, it works fine under Wine though.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
MS SQL Server
Upscene Productions
Hello,
I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only mydb2 database specific privileges
(no SUPER privileges). All tables were created prior to granting any
privileges.
Privileges have been granted by this query:
GRANT ALL PRIVILEGES ON
Hi Sergei,
Sergei wrote:
Hello,
I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only mydb2 database specific privileges
(no SUPER privileges). All tables were created prior to granting any
privileges.
Privileges have been granted by this
Hello,
Thanks for the answer!
I checked the thing you suggested:
1) output of SHOW GRANT is correct
2) the problematic table is not a view
3) no triggers - only foreign key constraint. ADD CONSTRAINT
`mydb2_table2_ibfk_1` FOREIGN KEY (`table2_user_id`) REFERENCES `table1`
(`usr_id`) ON DELETE
Hi Sergei,
I can't think of anything else, but I would suggest checking the output of SHOW INNODB
STATUS for clues, just in case the foreign key is causing an odd error message. I
would not be surprised, as InnoDB FK error messages are sometimes hard to understand.
Cheers
Baron
Sergei
Okay, so I have been gooling all over trying to figure this out. I'm
sure it's easy enough to do, but I can't seem to find it.
All I want to do is figure out the difference between 2 fields. IE:
Field 1= 20
Field 2 =10
Difference between Field 1 2 is: 10
Any ideas?
--
MySQL General
Okay, so I have been gooling all over trying to
figure this out. I'm sure it's easy enough to do,
but I can't seem to find it.
All I want to do is figure out the difference between
2 fields. IE:
Field 1= 20
Field 2 =10
Difference between Field 1 2 is: 10
Any ideas?
Umm, basic math?
If they're both numeric fields, then it's as easy as:
SELECT field1-field2 AS difference FROM table;
and if you always want a positive number:
SELECT ABS(field1-field2) AS difference FROM table;
HTH,
Dan
On 6/6/07, Jason Pruim [EMAIL PROTECTED] wrote:
Okay, so I have been gooling all over
Hello,
So I have this somewhat busy mysql box (300qps - 1100 qps) holding a bunch
(20) of myISAM tables.
The Box is Core2Duo 2.4 / 4GB RAM / Gentoo64 / MySQL 5.0.38
There are a number of scripts accessing those tables, both located on the
same machine and on others.
Every day, 1 to 3 tables get
Ysgrifennodd Jason Pruim:
Okay, so I have been gooling all over trying to figure this out. I'm
sure it's easy enough to do, but I can't seem to find it.
All I want to do is figure out the difference between 2 fields. IE:
Field 1= 20
Field 2 =10
Difference between Field 1 2 is: 10
Any ideas?
But beware unsigned math, if your columns are unsigned:
create table t( a int unsigned, b int unsigned);
Query OK, 0 rows affected (0.00 sec)
mysql insert into t(a, b) values(0, 100);
Query OK, 1 row affected (0.00 sec)
mysql select a-b from t;
+--+
| a-b |
Hi group,
Someone can answer me if when I execute the explain in a select
statement, the select is executed to get the parameters or this
information came from other place? In other words, the explain covers
the table and indexes or it calculate based on numbers of rows, etc.
regards
--
Using mysqldump and mysql (Distribution 5.0.22) on CentOS:
[?] Is it theoretically possible to create a mysqldump file using the
default --opt option (i.e., with extended-inserts...) that would create
packet sizes so large that the restore of the backup would fail because
max_allowed_packet
I would disagree on the use of mysql_real_escape_string(). The use of
placeholders is much safer from a maintenance and 'oops look I typoed it'
perspective.
On 04/06/07, Jon Ribbens [EMAIL PROTECTED] wrote:
On Mon, Jun 04, 2007 at 02:44:25PM -0700, Daevid Vincent wrote:
Thanks for the
Hola Ricardo,
Ricardo Conrado Serafim wrote:
Hi group,
Someone can answer me if when I execute the explain in a select
statement, the select is executed to get the parameters or this
information came from other place? In other words, the explain covers
the table and indexes or it calculate
Hi,
First of all, I would like to apologize if I didn't send my message to
the right mailing list.
My question is related to MySQL administration, where I don't have any
particular experience.
I would to trace every SQL statement executed inside a procedure that is
called by a client:
CREATE
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original
19 matches
Mail list logo