Gabriele,
http://dev.mysql.com/doc/mysql/en/Innodb_deadlocks.html
SET AUTOCOMMIT=0;
LOCK TABLES t1 WRITE, t2 READ, ...;
[do something with tables t1 and t2 here];
COMMIT;
UNLOCK TABLES;
In applications using AUTOCOMMIT=1 and MySQL's LOCK TABLES command, InnoDB's
internal table locks that were
Hi,
How do I install MySQL 4.1.7 on Windows Millenium so that it start
automatically on startup? mysqld --install ... does not work on Win9x
setups.
Thanks.
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi Mike,
I tried read-locking the tables as you suggested, but regrettably it
didn't help a bit. If there is nothing running but selects on that
database, mysql shouldn't lock ever, should it? or is it locking the
table if it's doing a full table scan (why?!)?
Bernd
On 23.11.2004, at 5:39 Uhr,
Hi all.
I'm pleased to announce the 5th release of Gtk2::Ex::DBI ...
http://enthalpy.homelinux.org/Gtk2-Ex-DBI/
Gtk2::Ex::DBI is a helper object that makes your gtk2-perl apps data
aware.
Changes in this release:
- Formatting changes in sourcecode. I bought myself a copy of Komodo,
and decided
Hello.
MySQL was developed to hold huge count of users and databases.
In addition to:
http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html
You may read:
http://dev.mysql.com/doc/mysql/en/Source_notes-Linux.html
(There is also some tips about the magic number 1024).
Hello.
Sounds very strange. May be there is a bug, and it would be great if someone
corrects me, but I haven't found anything related in bugs database.
You said that you issued show tables statement on your database? Maybe
it would be helpful to try not only show tables from your_database,
Hello.
I guess your MySQL client library is fresh enough to support authentication
protocol of 4.1.x versions. Otherwise you should read:
http://dev.mysql.com/doc/mysql/en/Old_client.html
If you have 4.1.x client library on your windows machine, probably
you should add ability to
Hello.
I think you should read good answers from Paul DuBois and
Egor Egorov at:
http://lists.mysql.com/mysql/169769
http://lists.mysql.com/mysql/169821
In which they've described behavior of mysqldump when it dumps columns with
AUTO_INCREMENT attribute.
Stuart Felenstein
No body has answered my question so far. Does that mean there is no way
to retrieve current row numbers in a query or no way to retrieve results
jumping steps?
I would appreciate any help.
Thanks,
Joao.
-Mensagem encaminhada-
From: João Borsoi Soares [EMAIL PROTECTED]
To: [EMAIL
Hi!
On Nov 22, Santino wrote:
At 15:23 +0100 22-11-2004, Sergei Golubchik wrote:
Hi!
On Nov 22, Dilipan Sebastiampillai wrote:
I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query
using LEFT JOIN gives me different result.
The result from 4.0.18 does s real LEFT JOIN
I think the reason nobody has replied is that the term row number does
not really have any meaning in a DBMS. How the database stores rows
inteneally is the DBMS's private business, and should not be visible to
you. I think it is true that MySQL does not *have* an internal row number,
so there
First thanks for the answer Alec. But I think you didn't understood my
problem. Maybe nobody replied because of that. Let me try again.
Suppose I make a select which returns 100 ordered rows. I only want to
read rows number 10, 20, 30, 40, 50, 60, 70, 80, 90 and 100.
To read the 10th row I
Hi list,
We have apps that try to open 700 simultaneous connections to our
4.0.20-max mysql server running on RH7 (Linux kernel 2.4.20). We get
many 'Can't create a new thread (errno 11)' errors returned by
mysql_real_connect().
I'm trying to follow the directions given in the Linux Source
João Borsoi Soares [EMAIL PROTECTED] wrote on 23/11/2004
12:34:01:
First thanks for the answer Alec. But I think you didn't understood my
problem. Maybe nobody replied because of that. Let me try again.
Suppose I make a select which returns 100 ordered rows. I only want to
read rows
MySQL 4.0.14
InnoDB (File size as it stands at present) = 6 GB
We have tried move the data folder from one hard disk
to another still the same problem. We really are in
need of help here. Is there any size limit in InnoDB?
I did ask this before, I did get some reponse thank
you. But due to
What you are trying to make is called either a pivot table or a
crosstab report. There is a very simple pattern to writing one. I am
assuming that all of the data is on just one table and that there can be
one or more entries per person per program per month. I know these do not
line up with
Kieran Kelleher wrote:
This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks
after MySQL installations for Yahoo.com) (fix the link if it wordwraps
in this email):
http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20?
creative=327641camp=14573link_code=as1
I have an interesting problem that I cannot find any clues to in the MySQL
documentation. The following query works in 3.2.3, but does not work in
4.1.7:
SELECT `Product`.`Product`, `AssignedToAgent`.`AgentName` AS `AssignedTo`,
sum(`Inquiries`) AS `Inquiries` FROM `Inquiry` INNER JOIN
Hi all,
I have installed MySQL Server 4.1.7 on both my Windows XP and Linux
Fedore Core 3 systems. It was amazing that everything can be configured
in a visual way and it is almost ready to use after installation when
install it on Windows XP and I could even change the way thatI want to
use
Hi!
The size limit in InnoDB is 64 TB.
You have probably mixed up ibdata files or ib_logfiles. The ib_logfiles that
you are using are probably completely zero-filled. No checkpoint info in
them.
What does
mysqld-nt --console
print if you move the ib_logfiles away?
When creating new ibdata
Windows has always been more graphical. For Linux, depending on the version
that you have downloaded
(binary v. source) you have to do very little to configure it for a dedicated
server. Check out the
my.cnf files in the /support-files/ folder of your MySQL installation. Use
these as a
At 04:16 AM 11/23/2004, Bernd Heller wrote:
Hi Mike,
I tried read-locking the tables as you suggested, but regrettably it
didn't help a bit. If there is nothing running but selects on that
database, mysql shouldn't lock ever, should it? or is it locking the table
if it's doing a full table scan
The reason I ask this here. Is I have graphics that are loaded by Mysql
and
was wondering if I can do the same for them since some of these sites can
call my server 10-20,000 times a day for that same graphic.
I assume you mean that you have image data stored in a MySQL
table somewhere and are
Try changing your GROUP BY to use the column name of the second column in
the SELECT, not the alias of the second column name, i.e.
GROUP BY `Product`.`Product`, `AssignedToAgent`.`AgentName`
That should work on any version of MySQL. I don't think you're allowed to
use aliases in a GROUP BY,
Very good feedback on multiple books. Thank you. So many good choices.
If only I had time to read them all...
Jonathan
Ugo Bellavance [EMAIL PROTECTED] 11/23/04 7:46 am
Kieran Kelleher wrote:
This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks
after MySQL
Hi. Thanks for the response.
Here is all the relevent information you asked for:
[EMAIL PROTECTED] mysql]$ ./bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 130 to server version: 3.23.55
Type 'help;' or '\h' for help.
If I understand your question correctly you want to group results for
statistical analysis. For instance if you have 2000 results (sequenced in
some way) you want to be able to split those results into 10 equal (or
nearly equal) groups of results and re-aggregate your results based on the
new
I have a database that is constantly moving large numbers around.
At the moment when a simple INSERT into Table_Name
('3573286532896523465328654654365436543'); is run
the value entered into the table is a zero. The field type that I am inserting
into is DOUBLE(200,0) unsigned.
Also this is all
Rhino:
Thanks for the feedback.
The query is generated by a home-grown tool, which allows the users to build
ad-hoc reports. For this reason, and because there are aliases in use (in
this case, two agents are joined to the underlying table), it would be
possible for a similar query that would
Read thru the changelog online and see if there's any fixes that
affect you or new features you want.. otherwise just leave it..I
have some terribly old mysql versions running, but they are rock solid
doing their job.. If it aint broke don't fix it? might apply...
On Mon, 22 Nov 2004
Hi!
On Nov 22, Dilipan Sebastiampillai wrote:
I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query
using LEFT JOIN gives me different result.
The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs
sometimes and I don't want that.
I think it comes from an
Well that´s me again with a new problem. I am runnig another database
with 7gb of data and this db can´t stop. All the time we have queries
being inserted by a plain text file and all the time customers get
information of this database. I obvserved that for a insert query is
taking about 5 to 15
Actually no. I have a file that is determined to be requested by mysql (Top
100 site) What I am wanting to do is put the images and or files into Ram
to serve them from there instead of the harddrive and conserve hd resources
for not known tasks.
Thanks
Donny Lairson
President
Carlos,
Give us more details about our system:
What are the table types you´re using?
What are the configs in your my.cnf file?
Ronan
- Original Message -
From: Carlos Augusto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 3:41 PM
Subject: Mysql Performance
I do not believe that your problem is based on your hardware but ...
Inserting data requires to reorganize your indexes. Please try to drop
them (only for testing ;-) )
Hagen
Carlos Augusto wrote:
Well that´s me again with a new problem. I am runnig another database
with 7gb of data and this db
Is the actual data stored in the database or somewhere in the file
system? If you do not have text or blob columns you may be able to use
heap/memory tables.
[EMAIL PROTECTED] wrote:
Actually no. I have a file that is determined to be requested by mysql (Top
100 site) What I am wanting to do
Heap/Memory tables that is the phrase I couldn't remember. The data is
stored in the file system.
I have one file that that is linked to via JavaScript to run a php file and
send an output. That file accesses MySql OR if I am overloaded it bypasses
my local system and goes directly to
This error results from Berkley Databases (bdb) not being enabled. This is
normally OK (unless you
want to use them), but it seems as though your have it set in your my.cnf file
to have them enabled
and not in MySQL. Go back into your my.cnf file and put a '#' in front of all
the bdb and innodb
Are you inquiring about database heap/memory tables or file system
memory tables? This is the link for MySQL heap/memory tables,
http://dev.mysql.com/doc/mysql/en/MEMORY_storage_engine.html. As for the
file system you could look at using ramfs,
I need to make query that adds numbers. The fields are varchar format
so I have some value 12121 and some values 121212,121212.
I think I need string replace function that replace comma. What
function can do this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I could see how the Pentium 4 may be faster for certain things. In some
cases, older Pentiums with larger caches (i.e. 2MB) would outperform a
Pentium 4. Rumor has it that MySQL loves level 2 cache, but don't tell
PHP. But in this case, the Pentium 4 and Xeon I'm pretty sure both have
512K
I installed mysql on windows XP pro without any problems. But, on Linux
can't get it to work so far.
I get the error:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
The directory is there. I thought that mysqld would create what it
needed at
Brent,
Would you be so kind to throw out some links to tweaking mysql to run
to its full performance. I am googling right now for the answeres. Is
there books you would recommend?
THANKS
On Tue, 2004-11-23 at 14:29 -0500, Brent Baisley wrote:
I could see how the
At 14:12 -0500 11/23/04, Jerry Swanson wrote:
I need to make query that adds numbers. The fields are varchar format
so I have some value 12121 and some values 121212,121212.
I think I need string replace function that replace comma. What
function can do this?
It's called REPLACE().
Hi!
On Nov 23, Dilipan Sebastiampillai wrote:
Hi!
On Nov 22, Dilipan Sebastiampillai wrote:
I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query
using LEFT JOIN gives me different result.
The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs
No books to recommend, although there was a review of one on
slashdot.org this morning, but you can start with the manual here:
http://dev.mysql.com/doc/mysql/en/Server_parameters.html
Other articles you may find helpful:
http://www.f3n.de/doku/mysql/manual_10.html
I have converted some tables from MyISAM to INNO
using an ALTER TABLE statement. It seems to work
fine. However, when I copy that database to another
directory for purposes of backup, a subsequent 'use'
statement on the backup directory (db) reports that
Didn't find any fields in table
I have what I thought was a simple, well-indexed query, but it
turns out that it's acting as a pretty big drag. The one thing
that's clearly a problem (though I'm not sure of the extent of
the problem), I'm not sure how to fix.
There are three tables: citations, subjects, and a many-to-many
Move this:
tries.status IN('running','waitkill','preemption'
to a where clause and remove it from the join.
Never actually tried to do a IN in a join before. I personally don't think
it should work.
Donny
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]
Sent:
Ok, when you have a GROUP BY clause, you can specifiy the column name, the
column alias or an ordinal number representing the column position. That's why
`AssignedTo` works -- it is the column alias. `AssignedToAgent`.`AssignedTo`
doesn't work because AssignedTo is not a column name in table
* Jesse Sheidlower
[...]
CREATE TABLE `citation_subject` (
`id` int(11) NOT NULL auto_increment,
`citation_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `citation_id` (`citation_id`,`subject_id`)
)
Try adding an index with
Vasiliy Boulytchev wrote:
Brent,
Would you be so kind to throw out some links to tweaking mysql to run
to its full performance. I am googling right now for the answeres. Is
there books you would recommend?
THANKS
High Performance Mysql (oreilly)
MySQL enterprise solutions
On Tuesday 23 November 2004 02:12 pm, Titus wrote:
I have converted some tables from MyISAM to INNO
using an ALTER TABLE statement. It seems to work
fine. However, when I copy that database to another
directory for purposes of backup, a subsequent 'use'
statement on the backup directory
On Tue, Nov 23, 2004 at 09:55:15PM +0100, [EMAIL PROTECTED] wrote:
* Jesse Sheidlower
[...]
CREATE TABLE `citation_subject` (
`id` int(11) NOT NULL auto_increment,
`citation_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
I have seen mails talking about MydbPAL. I downloaded it and I have
MySQL ODBC data source too but not able to connect to MydbPal at all. I
have tested my odbc data source, it work just fine. My machine is having
Linux and Windows through vmvare workstation. I installed dbpal on
windows and try to
Are there any MySQL errors being logged? Did you confirm that the ODBC
connection is working?
Sanjeev Sagar wrote:
I have seen mails talking about MydbPAL. I downloaded it and I have
MySQL ODBC data source too but not able to connect to MydbPal at all. I
have tested my odbc data source, it work
YES ODBC work perfect. I am using same data source for MySQL
administrator and Query Browser too.
Anyway, if you are using can you go over the steps for db connection
1. Open dbPAL, Click on Workshop
2. Choose data source by clicking ODBC from the list under MySQL
3. What next after that??
4.
Hey guys,
We just had a small incident. I was hoping for confirmation on why it happened.
A person updated a large table. They were trying to update one record
but due to keyboard fumbling sent the update without a where
statement. Left unchecked, it would have made a lot of records in the
I guess I am getting close
I drag the odbc connection line to database icon in db-test-connection.
I created new user and drag it to user part of db-test-connection. Now
the waiting tray has go icon. I drag the go icon to console tray,
nothing happened.
What is the next step to see if database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.16, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.16 is a bugfix release for the stable tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0
You could look at the processlist in the MySQL monitor to see if a
connection has been made. You may also want to enable ODBC tracing.
Sanjeev Sagar wrote:
I guess I am getting close
I drag the odbc connection line to database icon in db-test-connection.
I created new user and drag it to user
At 16:09 -0800 11/23/04, Gary Richardson wrote:
Hey guys,
We just had a small incident. I was hoping for confirmation on why
it happened.
A person updated a large table. They were trying to update one record
but due to keyboard fumbling sent the update without a where
statement. Left unchecked,
How can I reset the permissions on my database? I have no clue when I did
it (at least several months ago), haven't used it until today but I cannot
for the life of me figure out how I can create a new user with all
permissions. The only user I have does not have grant or create privileges.
Am I
i have an question about ordering a set of records...
ab c d
-
1Tax 120001.33
1Tax 115002.5
1Tax 110003.25
1Tax 10 4.5
Do you know what is differnet between command mysql_connect and
mysql_pconnect
Thankx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear all,
We are running mysql 4.0.17 on linux environment. Our database resides
on external disk connected via FC cables. We recently noticed a loss
of data in the following scenario.
Inserted a row in a table in a separate transaction by a java
application,
queried a row in the table in a
The mysql_pconnect() is a persistent connection and won't close even
with mysql_close(). Try to avoid it if you can.
On Wed, 2004-11-24 at 00:54, TM wrote:
Do you know what is differnet between command mysql_connect and
mysql_pconnect
Thankx
--
MySQL General Mailing List
For list
You can try to use two subqueries and an union ala
SELECT * FROM tab where c0 ORDER by C UNION ALL SELECT * FROM tab where
c=0;
Hagen
dan orlic wrote:
i have an question about ordering a set of records...
ab c d
-
1
On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote:
Dear all,
We are running mysql 4.0.17 on linux environment. Our database resides
on external disk connected via FC cables. We recently noticed a loss
of data in the following scenario.
Inserted a row in a table in a separate transaction by a
69 matches
Mail list logo