On Wed, Aug 31, 2005 at 11:18:40PM -0400, Michael Stassen wrote:
> No, with the default transaction isolation level, REPEATABLE READ, that's
> how it is supposed to work. You've started a transaction in Window B, so
> Window B is immune to changes made in Window A until you finish the
> transac
David Griffiths wrote:
I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and
4.0.18) using InnoDB.
If you have two connections to mysql (I use the mysql client), one of
which has autocommit turned on, an the other turned off, a row deleted
from the client with autocommit turned on
Hi All,
I have found that the binlogfiles have changed their name. Initially the
files were using the name of the server followed by the number i.e.
"foo.###". Since two weeks ago the binlog files have changed to be
"mysql.###". As far as I remember there is no change in my.cnf file so
far. I am
I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and
4.0.18) using InnoDB.
If you have two connections to mysql (I use the mysql client), one of
which has autocommit turned on, an the other turned off, a row deleted
from the client with autocommit turned on still shows up in the c
Tim McIntyre wrote:
Can anyone tell me the best way to ignore leading whitespace on orderings?
ORDER BY LTRIM(colname) ?
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
If you find my advice useful, please consider donating to a poor
student! You can choose
Hey all
Can anyone tell me the best way to ignore leading whitespace on
orderings?
Thanks
Tim McIntyre
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:56:23 PM:
>
>>
>> <[EMAIL PROTECTED]> wrote in message
>>
> news:[EMAIL PROTECTED]
>> > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM:
>> >
>> >>
>> >> <[EMAIL PROTECTED]
"Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:56:23 PM:
>
> <[EMAIL PROTECTED]> wrote in message
>
news:[EMAIL PROTECTED]
> > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM:
> >
> >>
> >> <[EMAIL PROTECTED]> wrote in message
> >>
> >
news:[EMAIL PROTECTED]
> >> > "Shaun" <[EM
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM:
>
>>
>> <[EMAIL PROTECTED]> wrote in message
>>
> news:[EMAIL PROTECTED]
>> > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM:
>> >
>> >> Hi,
>> >>
>> >> This que
[EMAIL PROTECTED] wrote:
If that wasn't it, can you explain WHY those numbers are wrong as I have
only the slimmest clue what your data is supposed to look like. If those
aren't the numbers you wanted, what numbers did you expect? Please,
provide sample queries to demonstrate what you expected
"Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM:
>
> <[EMAIL PROTECTED]> wrote in message
>
news:[EMAIL PROTECTED]
> > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM:
> >
> >> Hi,
> >>
> >> This query counts the number of entries in the Bookings table per
month,
> > is
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM:
>
>> Hi,
>>
>> This query counts the number of entries in the Bookings table per month,
> is
>> it possible for this query to return a zero where there are no entries
> for a
"Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM:
> Hi,
>
> This query counts the number of entries in the Bookings table per month,
is
> it possible for this query to return a zero where there are no entries
for a
> particular month?
>
> SELECT COUNT(Booking_ID) AS "Num_Bookings"
Hello.
MySQL 4.1.x has a lot of improvements in the framework
of warnings, which MySQL 4.0.x might not have. So
loading the data on the master (4.0.20) hasn't produced the warnings.
You may want to get the files which was loaded to be able to reproduce
the situation later and get the warning
Hi,
This query counts the number of entries in the Bookings table per month, is
it possible for this query to return a zero where there are no entries for a
particular month?
SELECT COUNT(Booking_ID) AS "Num_Bookings"
FROM Bookings
WHERE User_ID = 1
AND Work_Type_ID = 12
AND DATE_FORMAT(Booking
Hi Shawn,
My mistake, I should have been more precise.
Let me try to clarify situation, here,
The files represented by the "$dir2" variable in the script are the
files created by mysqldump, see below.
So, "Unlock Tables" command is the one immediately before "/*!4
ALTER TABLE `IC_CHAN
> If nothing helps, trace files could spill the light on your problem.
many thanks for your help. With tracing I found the problem. Like almost
every time it was just a typing error :-(
Regards Jan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
"Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 08/31/2005 12:35:19 PM:
> Hi everyone,
>
> I am trying to load backup files into a database using a small script
> where an actual load command is:
>
> /usr/local/bin/mysql -ux -p -f secdocs -v -e "source $dir2"
>
> and it is a part of loop
Hi everyone,
I am trying to load backup files into a database using a small script
where an actual load command is:
/usr/local/bin/mysql -ux -p -f secdocs -v -e "source $dir2"
and it is a part of loop that reads all files fro a directory.
The load freezes at the same point, when at
Thanks. I was already looking at ways to rewrite this query - the link will be
helpful.
I would have expected the query to be slow, but it looked to me like the
database stopped processing the query at all after a while. Now that I
understand just how slow it might be even under the best of circu
100 search items is a lot to search on at once for any system. MySQL
has to search on a 100 terms, no way around that.
I think the only way to optimize your query is to narrow down the
search terms. Perhaps you can search on phrases instead of words?
After the first 5-10 terms have been matc
Bill Duffy <[EMAIL PROTECTED]> wrote on 08/31/2005 11:32:02 AM:
> When I run a query like this
>
> DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM
> test_x_RM_4508_48875 )
>
> it never completes.
>
> test_x_RM_4508_48875 contains 180139 rows. test_P_Cookie contains
22,957,70
Hello.
>> # /etc/init.d/mysql start
>> Starting MySQL database server: mysqld...failed.
Sorry for replying to myself, but this link is helpful as well:
http://dev.mysql.com/doc/mysql/en/starting-server.html
Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
> Have a look here:
When you found this error, go to your MySQL database and do "SHOW INNODB
STATUS"
there will be an information about last foreign key error
Thx
joshua pereira wrote:
hello
when im inserting data to my database
this error occurs
javax.servlet.ServletException: Cannot add or update a
child row
When I run a query like this
DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM
test_x_RM_4508_48875 )
it never completes.
test_x_RM_4508_48875 contains 180139 rows. test_P_Cookie contains 22,957,702
rows. There does not appear to be any iowait problem and CPU is about 50 % in
us
Hi all
Yesterday I try to migrate a database from mysql version is '4.1.5-gamma' to
mysql version 3.23.45 using mysqldump:
in the source server I executed:
loki# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1955 to server version: 4.1.5-gamma-log
Ty
Master: 4.0.20-max
Slave: 4.1.14-max
Replication seems goes well.
This morning i see the follow messages on error log:
050831 5:30:04 [Warning] Slave: load data infile on table 'Stage' at
log position 30438086 in log 'tana-bin.001' produced 5003 warning(s).
Default database: 'TSM'
050831 6:0
hello
when im inserting data to my database
this error occurs
javax.servlet.ServletException: Cannot add or update a
child row: a foreign key constraint fails
pls advice
thank you .
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
Gleb Paharenko wrote:
Hello.
Maybe the output of innodb_monitor won't be truncated.
Create the innodb_monitor table and check if you see
the full output in the .err log. See:
http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
this helps - thanks
--
MySQL General Mailing List
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Marcello Lussana <[EMAIL PROTECTED]> wrote:
> Hi, I've got a problem with mysql4 on debian. I've installed with apt
> but I get this error:
>
> # /etc/init.d/mysql start
> Starting MySQL data
Hello.
Maybe the output of innodb_monitor won't be truncated.
Create the innodb_monitor table and check if you see
the full output in the .err log. See:
http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
Remigiusz Soko$owski <[EMAIL PROTECTED]> wrote:
> Hi!
> problem is not crit
Better you create a PHP page that run "SHOW INNODB STATUS" :-)
Hope that will solve your problem.
Remigiusz Sokołowski wrote:
Ady Wicaksono wrote:
You should try
*SHOW INNODB STATUS \G;*
Remigiusz Soko?owski wrote:
Hi!
problem is not critical, however it would be nice to get some
worka
Ady Wicaksono wrote:
You should try
*SHOW INNODB STATUS \G;*
Remigiusz Soko?owski wrote:
Hi!
problem is not critical, however it would be nice to get some workaround
from time to time I check innodb status - the most interesting
sections, I believe, are:
FILE I/O, INSERT BUFFER AND ADAPTIV
You should try
*SHOW INNODB STATUS \G;*
Remigiusz Soko?owski wrote:
Hi!
problem is not critical, however it would be nice to get some workaround
from time to time I check innodb status - the most interesting
sections, I believe, are:
FILE I/O, INSERT BUFFER AND ADAPTIVE HASH INDEX, LOG, BUFF
Hi!
problem is not critical, however it would be nice to get some workaround
from time to time I check innodb status - the most interesting sections,
I believe, are:
FILE I/O, INSERT BUFFER AND ADAPTIVE HASH INDEX, LOG, BUFFER POOL AND
MEMORY and ROW OPERATIONS
unfortunately they are at the bo
Hi, I've got a problem with mysql4 on debian. I've installed with apt
but I get this error:
# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to l
Hello,
I need some help optimizing a query. The current query is as follows:
SELECT *,
MATCH(title) AGAINST ( 'S' IN BOOLEAN MODE ) AS score
FROM articles
WHERE MATCH(title) AGAINST ( 'S' IN BOOLEAN MODE );
'title' is a FULLTEXT index.
'S' is a query string that may have 100 search term
> >>> I wonder how I'll get a div-function in SQL?
> >>
> >> I dunno, maybe by looking in the manual? From [1]:
> >>
> >> Division:
> >>
> >> mysql> SELECT 3/5;
> >> -> 0.60
> >>
> >> [1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html
> >>
> >
> > Gustav is looking for the DIV-
Hello.
Not enough information to make a conlusion. Please send OS and MySQL
versions. Think about switching from BDB to InnoDB.
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 1 lines --]
>
> When i do some insert or edit operations on my BDB tables i somet
Hello.
According to the:
http://dev.mysql.com/doc/mysql/en/kill.html
"During ALTER TABLE, the kill flag is checked before each block of rows
are read from the original table. If the kill flag was set, the
statement is aborted and the temporary table is deleted."
So, in my opinion, not
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/dns.html
You may want to start mysqld with the --skip-name-resolve option.
Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote:
> Hi,
>
>We seem to be running into a problem with our
> installation that we don't understand.
Hello.
> As mentioned, none of these work and all of these hang the server and
> break the database.
Even after weird queries server shouldn't hang and break the database.
Switch to the official binaries of the latest release (4.1.14 now)
and check if the problem remains.
"Reits
Joachim Klöfers wrote:
Jasper Bryant-Greene schrieb:
Gustav Wiberg wrote:
Hi there!
I wonder how I'll get a div-function in SQL?
I dunno, maybe by looking in the manual? From [1]:
Division:
mysql> SELECT 3/5;
-> 0.60
[1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.htm
Jasper Bryant-Greene schrieb:
Gustav Wiberg wrote:
Hi there!
I wonder how I'll get a div-function in SQL?
I dunno, maybe by looking in the manual? From [1]:
Division:
mysql> SELECT 3/5;
-> 0.60
[1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html
Gustav is looking
Jasper Bryant-Greene schrieb:
Gustav Wiberg wrote:
Hi there!
I wonder how I'll get a div-function in SQL?
I dunno, maybe by looking in the manual? From [1]:
Division:
mysql> SELECT 3/5;
-> 0.60
[1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html
--
--
Hi
MySQL Query Browser do what you want, but it's less traightforward.
Try to click on the wrench/tool just below the data grid, you will be
able to update you field (don't forget do click "apply changes").
That's the only reason why sometimes I still prefer MysqlCC
2005/8/30, Siegfried Heintze <
Jeff Pflueger wrote:
Hi. Thanks for any help on this. I've been beating my head over it for
hours.
Here's what I am trying to do: I have four tables I am joining via a
unique key (Fellow_id).
The results I want to group into three categories, each alphabetized
within the group.
Is this too mu
47 matches
Mail list logo
