Dear MySQL,
Can you please tell me if there is a way of listing all child tables
which have a foreign key reference to a parent?
Therefore I can find and delete a child row, then delete the parent
without getting:
"a foreign key constraint fails"
Regards,
Ben Clewett
--
MyS
ype = 'FOREIGN KEY'
AND u.referenced_table_schema='db'
AND u.referenced_table_name = 'table'
ORDER BY c.table_schema,u.table_name;
PB
-
Therefore I can find and delete a child row, then delete the parent
without getting:
"a foreign key constraint fails"
Peter,
I see... I was thinking 'db' might have been a system table name or
something...
This works perfectly, thanks.
Ben
Peter Brawley wrote:
Ben Clewett wrote:
Unfortunately I get:
mysql> SELECT
->
c.table_schema,u.table_name,u.column_name,u.referenced_column_n
turns instantly without any delay and to all nested levels of RI.
How does MySQL do this? Is it possible to use MySQL to find out what it
thinks is the problem?
Regards,
Ben
Peter Brawley wrote:
Ben Clewett wrote:
Unfortunately I get:
mysql> SELECT
->
c.table_schema,u.tab
turns instantly without any delay and to all nested levels of RI.
How does MySQL do this? Is it possible to use MySQL to find out what it
thinks is the problem?
Regards,
Ben
Peter Brawley wrote:
Ben Clewett wrote:
Unfortunately I get:
mysql> SELECT
->
c.table_schema,u.tab
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usual innodb variables.
The innodb table space has been created in ~/var/ibdata1.
But if I enter:
C
t
---
-Original Message-
From: Ben Clewett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 May 2006 4:57 PM
To: mysql@lists.mysql.com
Subject: InnoDB problems under 5.1.9
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
ome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-----
From: Ben Clewett [mailto:[EMAIL PROTEC
interested!
Thanks for the advise,
Ben
gerald_clark wrote:
Ben Clewett wrote:
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usua
interested!
Thanks for the advise,
Ben
gerald_clark wrote:
Ben Clewett wrote:
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usua
e engine |
++-++
12 rows in set (0.00 sec)
Ben Clewett wrote:
Hi Gerald,
I am sure I don't have this in my my.cfg. I am using the supplied
'large table' my.cfg. The *only* inno
e needed options for InnoDB.
See http://dev.mysql.com/doc/refman/5.0/en/mysqld-max.html, near the
bottom of the page it explains what DISABLED means and refers you to the
error log for messages.
Dan
Ben Clewett wrote:
Hi Dan,
This is what I have. What does this mean wi
ot it disabled in my.cnf or with a
startup flag, or you've not set all the needed options for InnoDB.
See http://dev.mysql.com/doc/refman/5.0/en/mysqld-max.html, near the
bottom of the page it explains what DISABLED means and refers you to the
error log for messages.
Dan
Ben Clewett wrot
Dear MySQL,
I am interested in clustering for MySQL. This claims to offer the
redundancy scalability and performance we require.
One thing I am really disappointed at is that clustering seems not to
offer much Referential Integrity (RI). Specifically, Foreign Key
References.
For better o
g to offer this functionality initially through the MySQL
interface (not the NDB API) some time next year.
Look for announcements on the MySQL Cluster forum and mailing list for it's
availability.
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
-Original Message-----
From: Ben Cl
To whom it may concern,
I'm involved in lots of C# coding with several coders.
I have a gripe with MySQL which may be easy to solve in future development.
C# has two DateTime constants:
DateTime.MinValue = '0001-01-01 00:00:00.000'
DateTime.MaxValue = '-12-31 23:59:59.999'
QL giving the
warnings which crash MySql.Data.dll.
MySQL version 5.1.6
Just a suggestion for later versions of MySQL :)
Ben
Barry wrote:
Ben Clewett schrieb:
To whom it may concern,
I'm involved in lots of C# coding with several coders.
I have a gripe with MySQL which may be easy
developer on this list,
please remove this warning :)
Ben
Barry wrote:
Ben Clewett schrieb:
Hi Barry,
This will happen when comparing against a TIMESTAMP field.
CREATE TABLE a ( t TIMESTAMP );
SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Well my msql doesn't gi
E
could be made time-zone aware. Maybe something like:
CREATE TABLE a ( t DATETIME WITH TIME_ZONE )
But this is a much bigger question!
Barry wrote:
Ben Clewett schrieb:
Hi Barry,
This is what I get:
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affected (0.25 sec)
mysql&g
ind it again if anybody is interested...
Thanks for the info,
Regards,
Ben
Michael Stassen wrote:
Ben Clewett wrote:
> C# has two DateTime constants:
>
> DateTime.MinValue = '0001-01-01 00:00:00.000'
>
Dear List,
I compiled 5.1.6 on Linux, works perfectly. Been running for a few
weeks, now want to port to live server.
Same compilation on AIX 5.2.0.0, I get:
Making all in storage/archive
if gcc -DHAVE_CONFIG_H -I. -I. -I../.. -I../../include
-I../../include -DDBUG_OFF -O2 -m
Chris,
Previous version which did compile was 4.1.9. May be glibc was not
required for this version. Glibc is not native to AIX so I can see some
fun ahead.
Thanks, Regards,
Ben
Chris White wrote:
On Monday 24 July 2006 08:36 am, Ben Clewett wrote:
Making all in storage/archive
Lost connection to MySQL
server during query'
After which MySQL needs restarting.
I have executed the usual 'CHECK TABLE tax EXTENDED' and alike, which
results no errors.
Obviously this is quite worrying. Can any expert on InnoDB Referential
Integrity offer any clues?
Than
, the other
little-endium. So some RI reference in the InnoDB table space might be
garbage on the Pentium server.
Might this explain the crash?
Any thoughts would be very welcome!
Ben
Ben Clewett wrote:
Dear MySQL,
I am getting an unexpected crash in MySQL 5.1.6, with nothing written to
which causes complete failure of their product?
Is there anybody I can talk to about this? Anybody who has some advise
on how to stop MySQL crashing?
Or provide a small shell script to restart MySQL each time it crashes??
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives:
documentation about how to control MySQL memory use.
Would some kind member help me find these?
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
at
every incontinuity to try and work out if this is the reason.
Thanks for any help,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ng? I am confused...
Regards,
Ben
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
On Mon, Oct 23, 2006 at 01:49:14PM +0100, Ben Clewett wrote:
MySQL,
I am trying to upgrade from 4.1 to 5.1.
Your manual states I should run mysql_upgrade.
But there is no such
ng? I am confused...
Regards,
Ben
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
On Mon, Oct 23, 2006 at 01:49:14PM +0100, Ben Clewett wrote:
MySQL,
I am trying to upgrade from 4.1 to 5.1.
Your manual states I should run mysql_upgrade.
But there is no such
table release?
If we upgraded to 5.0.1 now, is this stable for all the features in
4.1.9? So could we safely move now?
Kind regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
g to occur, why is it not 'release' now?
Sorry for my confusion,
Ben Clewett
Joerg Bruehe wrote:
Hi Ben!
Ben Clewett wrote:
[[...]]
Approximately when will 5.0.1 be available as stable release?
5.0.1 will never change, it is out (and obsolete by now).
You probably refer
Thanks for the detailed information, this is much clearer. I look
forward to 5.0.x becoming release.
Kind regards,
Ben Clewett.
Joerg Bruehe wrote:
Hi Ben, all!
Ben Clewett wrote ((re-ordered into posting sequence)):
Joerg Bruehe wrote:
Hi Ben!
Ben Clewett wrote
kill' will not cause MySQL to exit. Is there
any other know way to ask MySQL to exit cleanly?
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s any other part of MySQL which uses DNS
lookups? For instance, logging of some kind?
Or any other reason a MySQL daemon would not respond to a kill?
Thank for the ideas,
Ben Clewett.
Jigal van Hemert wrote:
Ben Clewett wrote:
It had been suggested that our DNS failed prior to this even
If there is anybody who knows how to build a DNS clean MySQL, I would be
very interested in knowing.
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Michael,
Thank for the reference. This is useful.
Ben.
Michael Stassen wrote:
Ben Clewett wrote:
JamesDR wrote:
I noticed, on my Linux server, that MySQL makes a DNS lookup anyway.
Even if the IP is used or not. It normally digs on the PTR record. I
had all of my perms IP based, however
anual
to elaborate on this problem. As far as I can see, this should work
perfectly.
Would any users be able to suggest a solution to this?
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GRANT syntax I use. Why would MySQL think my
client is from '0.0.0.0'?
Thanks in advance for any person who can offer a solution to these problems.
Ben Clewett wrote:
Dear MySQL,
A new installation of 4.1.9 on AIX 5. I have a GRANT that is not working.
Connecting from foreign serv
Dear MySQL,
My MySQL 4.1.9 has lost the ability to work out what IP address clients
are connecting from. Eg:
$ mysqladmin processlist
++--+---+--+-+--+---+--+
| Id | User | Host | db | Command | Time | State | Info|
have no problem.
Regards,
Ben Clewett.
Eric Bergen wrote:
MySQL 4.1.14 is the current version. You should always upgrade to the
lastest release and test your problem before trying to report bugs.
Ben Clewett wrote:
Dear MySQL,
My MySQL 4.1.9 has lost the ability to work out what IP
ype of index I need.
This must be a common problem, is there any person who can help me?
Thanks in advance,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rary tabel temp_a if exists 'temp_a';
it said syntax error.
Try:
DROP TEMPORARY TABLE IF EXISTS `temp_a`;
('table' instead of 'tabel'; table name only once; backticks around
table name instead of quotes)
http://dev.mysql.com/doc/refman/5.0/en/drop-table.html
R
Sorry, subject corruption, my last email should have had this subject,
not 'temporary table issue'...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jigal,
Thanks, I'll give this a go...
Ben
Jigal van Hemert wrote:
Ben Clewett wrote:
But the index does not seem nearly as fast as liner (normal) indexes.
Hence using a less effective liner index may be better...
After this method I still need select a radius within these data
p
Dear MySQL,
I have just upgraded 4.1.9 to 5.1.6, by compiling source code. I have
lost my binary logs.
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
eg: my-bin.01
my-bin.02
The usual option is present:
[mysqld]
log-bin = /usr/local/mysql/logs/my-bin
**or**
[mysqld]
l
In answer to my own question:
Why don't the binary logs write?
The '%-bin.index' file left over from previous version (4.1.9) had to be
deleted after the conversion to 5.1.6.
By deleting this file, the binary logs started to recreate.
I hope this is useful to somebody :)
Ben
s? Do any users know of a fix?
Thanks!
Ben Clewett.
Thread pointer: 0x7f6ea014cf90
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 410220e8 thread_stack 0x4
/usr/sbin/m
LOBAL VARIABLES LIKE 'query%';
SHOW GLOBAL STATUS LIKE 'Qc%';
Because of inefficiencies in 'pruning', having a query_cache_size bigger than
50M may actually degrade performance.
In you have a reproducible test case, submit to bugs.mysql.com .
-----Original Messa
Dear MySQL,
Using 5.1.56, I have experienced this core dump. Is there anybody out
there qualified to give an opinion on this?
Many thanks,
Ben Clewett.
Thread pointer: 0x7fd5280dbd90
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no
n 0; hex ; asc ;; 13: len 0; hex ;
asc ;; 14: SQL NULL; 15: len 4; hex 8000; asc ;; 16: len 4; hex
8001; asc ;; 17: len 1; hex 80; asc ;; 18: len 4; hex 64626d73;
asc dbms;; 19: len 1; hex 00; asc ;;
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archive
)
VALUES ( NULL , '35126600409511509' , '2007-12-18 23:59:58' ,
'5.150556400501e+01' , '-3.696216681689e-01' ,
'8.000000016653e-02' , '1.0
Many thanks!
Ben Clewett.
--
MySQL General Mailing List
For list archive
way for minutes or hours, or until it is restarted.
This load cannot be accounted for by the processlist.
I need to know why MySql does this. If any person knows how I an
identify the problem, please let me know!
Thanks!
Ben Clewett.
# top
top - 08:19:50 up 5 days, 9:52, 1 user, load
I do it all the time, look at:
--replicate-do-table
In: http://dev.mysql.com/doc/refman/5.0/en/replication-options.html
Section of my mysql.conf:
# Replication Options
replicate_do_table = db.member
replicate_do_table = db.company
replicate_do_table = db
ich are replication slaves and masters at the same time who
tend to do this 100% CPU thing for hours on end...
Kind regards,
Ben
Kevin Hunter wrote:
At 3:25a -0500 on 17 Jan 2008, Ben Clewett wrote:
I need to know why MySql does this. If any person knows how I an
identify the problem, plea
Kevin Hunter wrote:
At 12:08p -0500 on 17 Jan 2008, Ben Clewett wrote:
The package you show gives the same output as the 'SHOW PROCESSLIST'
output, which I included in my previous email :)
Heh, that'll teach me to actually /use/ the package before recommending
it. :-P (I just fou
ntial read and write.
If any members can suggest what might be appropriate, I would be
interested in knowing :)
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Philip,
If you are worried about permissions, go to your mysql root directory
and enter:
# chown -R mysql.mysql .
The UID and GID should not make any difference. I don't think this
would effect your ability to log in.
If this is a new installation of the server, check the default MySql
Try:
SELECT DISTINCT Colour FROM table;
Or, if you want to do it correctly:
SELECT Colour FROM table GROUP BY color;
Richard wrote:
Hello,
I don't know if it is possible to do this with mysql alone ...
Here goes :
I've got a database list which is like to following :
Num|Name|
# mysqldump --help
look for the flag --no-data
Ben
Esbach, Brandon wrote:
Is there any way to backup a complete database structure
(tables/fields/indexes/etc), without the data? Or even get a creation
script per table?
At present the only way I can think of is to restore a backup to anothe
Try:
> mysql -u root -p
mysql> GRANT SUPER ON *.* TO myuser@'%';
mysql> GRANT SUPER ON *.* TO myuser@'localhost';
Andre Hübner wrote:
Hi List,
i wrote this alrready in mysql-forum a few days ago, but did not get any
answer. :(
i try to do backup with mysqldump from external host with
privileges for normal db-users.
rights should be limited to own db.
Thanks
Andre
- Original Message - From: "Ben Clewett" <[EMAIL PROTECTED]>
To: "Andre Hübner" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, February 20, 2008 9:46 AM
Subject: Re: external mysql
This is something I do with replication.
You can replicate a list of tables, see the 'replicate_do_table' config
option.
Then you can euse the 'read_only' option. Replication still works but
nothing else. But it would give you more options by using GRANT instead
of 'read-only':
CREATE US
A modification to my last email, try:
SELECT
*, IF(update != '', update + 10, date) AS o
FROM
my_table
ORDER BY o DESC;
+-+--++--+
| num | date | update | o|
+-+--++--+
| 5 | 40 | 90 | 100 |
| 2 | 10 | 60 | 70 |
| 6 | 50 |
I think the easiest is to create a new logical column with the correct
ordering, something like:
SELECT *, IF(update != '', update, date) AS o
FROM my_table ORDER BY o DESC;
I note that both 'update' and 'date' are reserved works :)
Also worth noting that this cannot be assigned an index an
Richard,
No problem, glad it works. But note: this is not scalable. If you have
more than a few hundred rows, you may want to think about a better
solution, like storing the order field permanetly and giving it an index :)
Ben
Richard wrote:
Thanks, it works like a charm :)
Ben Clewett
limited number of results on one page.
Every time a question is answered the update date will change, and the
status could also change. So I don't see how to easily do this by
creating another table.
Ben Clewett a écrit :
Richard,
No problem, glad it works. But note: this is not scala
,
I am setting up a replication with 1 master and multiple slave. My question
is can i use the same user (from master) for setting up replication on
multiple slaves. Is there any advantage for replication by creating
different user for different slave.
Thanks & Regards,
--
Ben Clewett
Are you using MyIsam or InnoDB? Or something else?
In either case the speed to get a COUNT() is largely down to the speed
if your disks and size of disk caching. A COUNT() forces the system to
read every row in order to count them, and any large table is probably
larger than your caches.
I
ype!
Ben
Wm Mussatto wrote:
On Fri, April 11, 2008 06:47, Ben Clewett wrote:
Are you using MyIsam or InnoDB? Or something else?
In either case the speed to get a COUNT() is largely down to the speed
if your disks and size of disk caching. A COUNT() forces the system to
read every row in orde
No problem.
I do this using three triggers on Insert, Update and Delete. Then
update a log file who's schema starts:
CREATE TABLE ?_log (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
transact ENUM ('I','U','D') NOT NULL,
key_from_table ??? NOT NULL,
KEY (key_from_table),
field_1 ?? ,
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does this help?
Ben
P
Check the error.log on both server and client, should show where
connected and disconnected.
Or write a small program to execute SHOW SLAVE STATUS every minute and
log the results. Which I belive is done for you in the MySql dashboard
program suit.
Ben
Kaushal Shriyan wrote:
Hi
Is there
Pam Astor wrote:
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does
Pam Astor wrote:
The ANSI-SQL syntax is to just use GRANT to create users. You will
still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
But I find the MySql syntax for creating user with CREATE USER and then
GRANT easier to follow:
CREATE USER joe@'%' IDENTIFIED BY
Are you sure, I just get:
CREATE TABLE ...
ERROR 1075 (42000): Incorrect table definition; there can be only one
auto column and it must be defined as a key
On version 5.0.41. What version are you using?
Hiep Nguyen wrote:
hi list,
reading manual on mysql regarding auto_increment with m
You are right, I've tried 5.0.18 and 5.0.45 which work.
There must have been a bug in 5.0.41 with which I used test the question...
I belive the question has been answered by now anyway :)
Ben
Sebastian Mendel wrote:
Ben Clewett schrieb:
Are you sure, I just get:
CREATE TABLE ...
I would use as large a block size as you dare, especially with InnoDB.
Makes reading and writing faster as custs down seek time as cuts down
disk fragmenation and avoids block table reads. With MyIsam you have
lots of files, but if you only have a few again might work well with a
large bloc
Dear MySql,
I am trying to optimise InnoDB, and trying to find out how much of the
innodb log file contains row data which has not been written to storage.
Therefore I can optimize the size of the log, keeping it low to reduce
crash recovery time yet high enough to be useful.
I can see th
Thanks for the idea. Unfortunately nothing I can easily use (for
instance in MySql Administrator) to log and monitor the lag in bytes
between log writes and row data writes. :)
Iñigo Medina García wrote:
Hi Ben,
Dear MySql,
I am trying to optimise InnoDB, and trying to find out how much
SHOW CREATE TABLE ...
Martijn Tonies wrote:
Hi,
How does one know if ON UPDATE CURRENT_TIMESTAMP was specified when
creating a column? How do I retrieve this bit of info from the metadata
queries?
(also MySQL 4.1)
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB
If you use InnoDB you should not have a problem as it used row-level
locking and isolated transitions.
Other than that you can split your tables into smaller ones using either
partitioning or the federated engine...
Ben
Krishna Chandra Prajapati wrote:
Hi,
Generally, in data modelling t
Table level locking is inherent to MyIsam.
Look into partitioning, as this breaks table into two or more other
tables which will lock separately.
Or use InnoDB:
ALTER TABLE ... SET ENGINE=InnoDB; (I think)
Ben
Krishna Chandra Prajapati wrote:
Hi,
I am looking for a solution to reduce th
If you using C++ then you can use this:
http://developer.gimp.org/api/2.0/glib/glib-Timers.html
I use this in my code, does an excelent job.
Also you may want to look at the 'slow log' in mysql which will show, to
the nearest second, the length of queries
Ben
Neil Tompkins wrote:
Hi Cr
Hi Neil,
If your using Linux then you have to install the glib RPM's in the usual
way. I don't know about other platforms, but I am sure there will be a
version of glib out there...
Also ensure the correct include and link directives are in your
Makefile, which you can get (on Linux) using
Dear MySql,
Hope somebody might give some advise about replication!
On 5.1.24, I have something simple like:
CREATE TABLE big_f_er (
id BIGINT UNSINGED NOT NULL AUTO_INCREMENT,
t TIMESTAMP NULL NOT NULL,
PRIMARY KEY (id, t),
KEY (t)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RA
You might be able to do it with the federated engine:
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
Fire a trigger on your main tables which update some row in a foreign
MySql database used for accounting. I've not tried this but the theory
is sound.
Ben
Andrey Dmit
Under 5.0.41 I have having problems of CPU sitting at exactly 100% load
on a single CPU for very long periods of time, like 10 hours.
I traced this command:
mysql> SHOW MUTEX STATUS;
Which returned 1281006 lines, ending with:
+-+--+--+
| File| Line | OS_waits |
As far as I am aware, the index's are built on import.
It may be that the key-buffer or innodb-buffer (depending on engine),
and the query cache, are all cold. May take a day or so to build them
up depending on size and load.
Other than that there must be some external difference. Is it the
It could be the size of your InnoDB log files. Or something else which
stops InnoDB running.
I once changed server and by mistake changed the size of the
innodb_log_file_size. The result was that InnoDB could not start and
instead dissabled its self. Therefore every table I created became M
Dear MySql,
Can you please tell me if there is a tool to view the queries stored in
the Query Cache?
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
structure, does it use a file?
If you have the name of the Query Cache file, this would be very useful.
Regards,
Ben.
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote:
Dear MySql,
Can you please tell me if there is a tool to view the queries stored
in the Query Cache?
Regards,
Ben Clewett
sure that since this is a memory structure, there must be a command
in MySql or an admin tool which can be used to expose the Queries.
If anybody knows this really would be very useful.
Regards, Ben.
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote:
Hi Mohsen,
Thanks for the reply.
I&#
Hi Mohsen,
I see, the difference between the home of mysql and the mysql home...
As you asked:
mysql:*:204:1::/home/mysql:/usr/bin/ksh
# ls -la /home/mysql
4 -rwxr- 1 mysqlstaff 254 14 Feb 2005 .profile
Regards,
Ben
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote
rce code directories...
Regards,
Ben
Chris wrote:
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote:
Hi Mohsen,
Thanks for the reply.
I'm looking in the home directory, as well as the other directories
used by mysql and I can't see any files which I do not recognise. (I
am UNIX so t
Dear MySql,
I am finding my version 5.1.6 and 4.1.9 sometimes locking up during the
passing of BLOB data. Size between 25 and 250 KB.
If I repeat the transaction it will pass.
Statistically it occurs about 1 in 30 INSERTs or UPDATEs or a blob.
Non-Blob data to the same table will never lock
e any software they can
recommend which:
- Stops the replication daemon.
- Sets the replication server to Read/Write.
- Shuts down the primary.
- Routes traffic to the replication.
Any advise or ideas would be very useful...
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list arc
I forgot to mention that I am running Linux.
If anybody has some idea of software which can do this, I'd be very
interested.
Regards,
Ben
Ben Clewett wrote:
Dear MySql,
I'm looking into availability and wonder if any member might be able to
help me.
I have two databases, o
g with the 'log-slave-updates' option.
2. After you run a back issue a reset master on the slave server.
Hope this helps,
Scott Tanner
On Mon, Apr 02, 2007 at 08:43:35AM +0100, Ben Clewett wrote:
I forgot to mention that I am running Linux.
If anybody has some idea of software wh
Dear MySql,
Using 5.0.26 I am trying to get a consistent image of some tables using
mysqldump. This is for replication. All my tables are InnoDB.
I am using:
# mysqldump h \
--master-data=1 \
--single-transaction \
I was hoping that the '--master-data=1' would rep
Dear MySQL,
I'm running 5.0.26 through Heartbeat. Which seems to work well, even as
a replication slave and Heartbeat continously stopping and starting the
server.
The Heartbeat moves MySQL around from server to server when a failure
occures. I am trying to find a way for MySQL to report t
1 - 100 of 139 matches
Mail list logo
