I used sysbench to test mysql with 2000 threads and then sysbench threw some
alerts below: ALERT: failed to execute mysql_stmt_execute(): Err1114 The table
'sbtest' is fullFATAL: database error, exiting...I don't know what does it mean
because sbtest is not full.mysql> show create table
sbtest
In the last episode (Jan 03), bruce said:
> i've asked something similar before.. but it appears something is going
> wrong... so, back to basics...
>
> i have the following test tbl.
>
> dog
> fooID int
> size int
> id int
>
> dog
> fooIDsizeid
> 1 2 1
> 2
i think you are in fact duplicating an entry on the index, probably one of
your indexes on that table is length restricted and that cause that 2 fields
that as a whole are different, they are not to the index length.
My two cents.
Carlos
On 1/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
hi...
i've asked something similar before.. but it appears something is going
wrong... so, back to basics...
i have the following test tbl.
dog
fooID int
size int
id int
dog
fooIDsizeid
1 2 1
2 5 2
1 5 3
if i do a query
select * from
Many thanks for your kind response. I was using a form that was submitted twice
for any given new ssn. I have also benefited from your comments on how to write
a better java code. Turns out my html and javascript skills need improvement.
Many thanks again.
Regards
David Griffiths <[EMAIL P
Hi all.
I have some code which was working brilliantly, but just stopped :(
I'm importing stuff in to a temporary table, mangling it considerably,
then importing it into the final destination table.
The tmp table is created:
create temporary table tmp_AAPT_OnlineAnalyser_ChargeTypeSummary (
Just a thought, if I were to JOIN or reference a SUBQUERY instead,
inside the UPDATE statement, would that lessen the length of time for a
SELECT lock? From what I understand, subqueries get temporarily cached
as a temp table, so theoretically it would be a way to avoid locks, no?
(or, reduce the t
That would be fine with me, but then conversely it means multiple tables
would be locked by one query, which is bad in our environment (high
transaction)
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 03, 2007 4:24 PM
To: Jonathan Langevin; mysq
I'm gettig it on browser after I run php code for adding new products.
http://www.vernoncompany.com/screen/PrntScrn.gif
> Where is the error message itself coming from? Is MySQL itself generating
> any error? I ask because that error message shouldn't be coming from
> MySQL.
>
> Regards,
>
> Jer
I hope it is locking both tables. Even if you aren't changing any fields in
the right-hand column, you don't want anyone changing it under you. I hope
that, if you aren't actually modifying the right-hand table, that MySQL uses
a read (SELECT) lock.
Regards,
Jerry Schwartz
Global Information Inco
Where is the error message itself coming from? Is MySQL itself generating
any error? I ask because that error message shouldn't be coming from MySQL.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Origina
I've used the syntax, UPDATE ... LEFT JOIN a few times in the past, and
today I used it again for a new employer that I work for.
Several of my associates were unaware that the UPDATE ... LEFT JOIN
syntax is valid in MySQL. After I demonstrated that the query does
indeed work fine on our MySQL 5.x
Yes, it's custom made app, written in php.
The code/query is really very simple:
INSERT INTO products
(prod_no, prod_name, prod_description, prod_colors, prod_includes,
prod_catalog, prod_supplier, prod_start_date, prod_end_date,
prod_status)
VALUES
('H846', 'Lavender Peak Purse', 'Large main top
Aaron Cannon wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
SELECT c.value FROM c WHERE c.value NOT IN
I think you want
SELECT * FROM a LEFT JOIN b on a.c = b.d WHERE b.d IS NULL;
The LEFT JOIN means to create a composite record from both tables even if
there is no match on the right-hand table. Checking to see if b.d is null
selects out those composite records that came up empty on the right-hand
Are you using a custom-written application to do the loading? If so, what
language is it written in? I suspect that some of your variables are getting
clobbered by a bad subscript, bad pointer, so something like that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Far
Dear mySQLers,
We are currently running into performance problems as the database gets bigger:
3.2 million rows, 1.3GB innodb file size on a proliant ML360 G4 machine with 2
3GHz CPUS and 4GB RAM on Windows 2003 server RAID1. recently upgraded to 5.0.27
[starting from 4.x in 2005].
How much
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
I need a select statement that will return all records whose C valu
Hi,
While we were using old hosting company (15 days ago) on php 4.3.4/mysql
4.x based Linux server, the application I wrote to upload new products i
MySQL was working fine.
After we moved now I'm getting strange error I can't explain. I think it's
caused by moving to mysql 5.
For example: in the a
Dan Buettner wrote:
SHOW PROCESSLIST should show local queries as well as remote - in my
experience, it has been utterly reliable in terms of showing all
current queries, regardless of origin.
InnoDB by default uses a single "tablespace", which some people do
find inefficient because it never ge
SHOW PROCESSLIST should show local queries as well as remote - in my
experience, it has been utterly reliable in terms of showing all
current queries, regardless of origin.
InnoDB by default uses a single "tablespace", which some people do
find inefficient because it never gets smaller even after
Dan Buettner wrote:
Michael -
You should see all running queries in the output of SHOW PROCESSLIST.
MyISAM is a multiple-reader/single-writer design, also known as table
locking design - that is to say, you can have lots of threads reading
simultaneously, but only one writing. Also, when one i
Michael -
You should see all running queries in the output of SHOW PROCESSLIST.
MyISAM is a multiple-reader/single-writer design, also known as table
locking design - that is to say, you can have lots of threads reading
simultaneously, but only one writing. Also, when one is writing,
reading th
Hello,
we are going to move our mysql installation to a mysql cluster,
either 5.0.x or (because the databases will be > 1 GB) to 5.1.x due
to disc based clustering,
At the moment we have to independent mysql servers which should work
as a cluster in the future. I am wondering of anyone can giv
24 matches
Mail list logo
