15-10-19 14:19, Roy Lyseng wrote:
Hi Ben,
On 19.10.15 15.10, Ben Clewett wrote:
I have noticed that an unqualified boolean expression cannot be
optimized by
MySQL to use an index in 5.6.24.
For example:
CREATE TABLE t (
i INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
a BOOLEAN NOT NULL,
E a = TRUE;
This will return the same results, but not use key 'a':
SELECT * FROM t WHERE a;
Is this a bug, or deliberate behaviour, or a missing feature, or perhaps
something else?
Thanks,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
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
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
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
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
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
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 |
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
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
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
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
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 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
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
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
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
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
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 ...
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
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
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
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
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
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 ?? ,
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
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
,
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
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
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
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
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
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
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
# 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:
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|
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
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]
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
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
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
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
)
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
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
Sorry if this has been asked many times before...
I have 5 MySql systems running on a single server.
I want one to run with maximum priority, the other four to run with minimum.
Can this me archived using something as simple as 'nice':
# nice -10 mysqld --defaults-file=his_priorty
# nice 10 my
From my experience with InnoDB,
IF the field is an index, it will use 3 bytes per character. So
VARCHAR(50) = 150 bytes, when fully populated. (+ 1 for the length =
151 bytes.)
IF the field is not an index, each character will consume between 1 and
3 chars. So VARCHAR(50) = 51 -> 151 char
Ravi,
Got it, thanks!!
Ben
Ravi Prasad wrote:
Make sure each of the replication slaves uses different server_id.
--Ravi
Ben Clewett wrote:
MySql,
I am running 5.0.41 on a master and four replication slaves, all 64
bit Linux.
In the error.log on all four replication servers I keep
MySql,
I am running 5.0.41 on a master and four replication slaves, all 64 bit
Linux.
In the error.log on all four replication servers I keep seeing:
070626 8:34:23 [Note] Slave: received end packet from server, apparent
master shutdown:
070626 8:34:23 [Note] Slave I/O thread: Failed readi
Olaf Stein wrote:
Hi all,
Are there any reasons why one would NOT use separate ibd files for each
table (--innodb_file_per_table). It seems logical to me to separate what
does not belong together logically (different databases), but I as the
shared tablespace is the default I wonder if it has na
> Hi all,
>
> Are there any reasons why one would NOT use separate ibd files for each
> table
Fragmentation for one.
A single file can re-use empty space from deleted rows for any added
rows. A single file can only re-use space from that one file.
Therefore the sum table size will be larger
Dear MySql,
I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with
date comparisons.
In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True.
In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False.
In 5.1.6-alpha: '2007-06-15' = '2007-06-15 00:00:00' is True.
nstalled 5.0.41 and have found that the 'hostname' variable does
report the hostname of the physical server. I have no idea how it does
it :)
I have my solution, thanks for the help,
Ben Clewett.
Baron Schwartz wrote:
Gerald L. Clark wrote:
Baron Schwartz wrote:
Gerald L. Clark w
Baron,
Thanks for the fast reply.
I like the idea of piping in the servername to a small table on startup.
Since this will only change on startup, sounds like an excellent idea.
Or I may upgrade to above 5.0.41...
Regards,
Ben
Baron Schwartz wrote:
Hi,
Ben Clewett wrote:
Dear MySQL
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
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
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
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
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
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
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
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
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&#
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
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]
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
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]
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]
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:
, 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
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
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
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
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'
>
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
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
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
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'
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
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
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
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
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
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
ome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-----
From: Ben Clewett [mailto:[EMAIL PROTEC
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
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
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
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
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"
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
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
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
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
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]
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
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]
1 - 100 of 139 matches
Mail list logo
