Dear mysql@lists.mysql.com:
Our db is the innodb eng.
We have no hot backup tools to dump the data.
If lock the table by the following cmd before we dump the data
FLUSH TABLES WITH READ LOCK;
It seems ok,it can lock the innodb too.
But the replication would be crushed ,even it start up smoothly,
Hi Scott,
> I have created a web-based simple application, and used mysql for data
storage. All has worked well. But I do have a simple question I would like
to ask the group.
>
> I have some web-based forms that match table structure. Most of the
important fields have validation, and I ensure goo
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/05/2005 04:21:06 PM:
> Hello,
>
> I have created a web-based simple application, and used mysql for
> data storage. All has worked well. But I do have a simple question I
> would like to ask the group.
>
> I have some web-based forms that match ta
SHOW INNODB STATUS indicates these two queries are deadlocking:
(1) REPLACE INTO TMP_pixel_xfer SELECT * FROM user_question q INNER
JOIN user_session s USING(user_session_id) WHERE user_question_id
BETWEEN '27853011' AND '27891923' ORDER BY s.user_id
(2) DELETE t from TMP_user_client_report
I have a problem working with the stored procs.
The stored proc looks like this
create procedure unit_swap()
BEGIN
DECLARE b INT DEFAULT 7;
DECLARE c INT;
DECLARE CONTINUE HANDLER FOR 1176 SET b = ;
DECLARE CONTINUE HANDLER FOR NOT FOUND, SQLEXCEPTION, SQLWARNING SET b =
111
Hello,
I have created a web-based simple application, and used mysql for data storage.
All has worked well. But I do have a simple question I would like to ask the
group.
I have some web-based forms that match table structure. Most of the important
fields have validation, and I ensure good dat
At 12:17 -0700 7/5/05, Jacob S. Barrett wrote:
I have a column of type UNSIGNED INT which holds a 32bit counter. When the
value of the field exceeds 2147483647 (signed max) the value of MAX on the
column returns a negative number. If I convert the column to BIGINT the
correct MAX is returned.
At 16:57 -0700 7/4/05, l'[EMAIL PROTECTED] wrote:
I tried as root having GRANT ALL PRIVILEGES with GRANT OPTION
to change the privilege of a user:
GRANT ALL ON mydb.* TO myUser;
The result of this statement is that the query is OK and 0 rows are affected.
WHen I look at the mysql table holding
I have a column of type UNSIGNED INT which holds a 32bit counter. When the
value of the field exceeds 2147483647 (signed max) the value of MAX on the
column returns a negative number. If I convert the column to BIGINT the
correct MAX is returned. Is this expected behavior, am I doing somethin
You definitely should increase memory sizes in your my.cnf file. The
settings that you have are for a very smal setup. You also need to
allocate more space for innodb table extender. So instead of 10m have
something like 50m or try and see which settings is better. The reason
is under heavy load if
The original message was received at Tue, 5 Jul 2005 19:45:52 +0200
from lists.debian.org [46.122.169.149]
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Hi, We are running mysql version 4.1.7 with innodb on i686 running
2.4.26 linux kernal with 8G memory. Mysql crashes consistently
during heavy usage with fatal innodb error. We are running a high
volume front end application which inserts > 50M data to a row in
innodb table often. I don't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.25, a new version of the popular Open Source/Free Software Database
Management System, has been released. It is now available in source and binary
form for a number of platforms from our download pages at
http://dev.mysql.com/downloads/
Hi Ruben,
> I would like to make a short, quick and simple
> question.
>
> Is it possible to have the following line:
>
> innodb_data_home_dir="X:/data/"
>
> in a my.ini config file?
>
> I'm using windows XP, mysql 4.1.12, X: is a mapped
> network drive to a Linux folder using samba, all the
> per
Hello everyone,
I would like to make a short, quick and simple
question.
Is it possible to have the following line:
innodb_data_home_dir="X:/data/"
in a my.ini config file?
I'm using windows XP, mysql 4.1.12, X: is a mapped
network drive to a Linux folder using samba, all the
permissions are s
search for "my-medium.ini"
[EMAIL PROTECTED] wrote:
Dear Sir or Madam:
After installing mysql, the template files, my-small.cnf, my-medium.cnf or
my-large.cnf, were not created. I uninstalled and then reinstalled mysql, but
they were still not created. I am using mysql-4.0.20a-win on Windo
Hello.
Yes, it works only for MyISAM. You've began a new thread, and
haven't specified that this one is related to the previous. So
I've decided they were independent. Possibly you could obtain
schema information using different levels of innodb_force_recovery.
See:
http://dev.mysql.com
Hello.
Usually you could use template files from another version. If my-xxx.cnf
files are not shipped with windows distribution (and they are not!), take them
from
corresponding Linux packages. But be aware of:
http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html
[EMAIL PROT
On Tue, 5 Jul 2005, Gleb Paharenko wrote:
Hello.
As of MySQL 4.0.2 after REPAIR ... USE_FRM you should be able to get information
about table with SHOW CREATE TABLE, however some information could be lost.
See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
but doesn't that only work w
Hello.
As of MySQL 4.0.2 after REPAIR ... USE_FRM you should be able to get information
about table with SHOW CREATE TABLE, however some information could be lost.
See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
Jason Pyeron <[EMAIL PROTECTED]> wrote:
>
> I am willing to
I am willing to give up on my data recovery efforts if I can just get the
schema from the dead tables, any suggestions?
Sincerely,
Jason Pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyero
Thanks to all! The AS keyword did the trick.
Philippe Poelvoorde wrote:
SELECT mem_number, first_name, last_name, joining_points + emc +
sapmc + starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw +
saloty + safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo +
csf + coc + ncmc
Jacques
Thank you, I will give it a try.
Jacques Marneweck wrote:
Schalk Neethling wrote:
Greetings
Please have a look at the following code and let me know if this is
the correct way to create a virtual row. Also, after having run this
MySQL returns the error that the row total_points, d
SELECT mem_number, first_name, last_name, joining_points + emc + sapmc +
starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw + saloty +
safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo + csf + coc +
ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf = total_points
ncmc + gmgp + nlm
On Mon, 4 Jul 2005, Gleb Paharenko wrote:
Hello.
I think that deleting .ibd files is a weird behavior for installer. Did
you use innodb_file_per_table? If not, then a new version couldn't
it is doing something with the files, but still it looks for the .ibd?
07/05/2005 07:04 10,4
Greetings
Please have a look at the following code and let me know if this is the
correct way to create a virtual row. Also, after having run this MySQL
returns the error that the row total_points, does not exist. Where am I
going wrong? Thank you in advance.
SELECT mem_number, first_name, l
That is what I attempted, but to no success.
I will try again, I think the installer blew away my old my.ini.
On Mon, 4 Jul 2005, Gleb Paharenko wrote:
Hello.
I think that deleting .ibd files is a weird behavior for installer. Did
you use innodb_file_per_table? If not, then a new version cou
Seems that i have a bad block :(
# badblocks -sv /dev/sda3
Checking for bad blocks in read-only mode
From block 0 to 10241437
Checking for bad blocks (read-only test): 102414360/ 10241437
done
Pass completed, 1 bad blocks found.
Ady Wicaksono wrote:
Dear All
I use RedHat 9 with 2,5 Gbyte RA
Hello.
For binaries downloaded from mysql.com you should run mysql_install_db. Not
sure for others.
>
> Thanks. I have read that document. But I wasn't clear as to whether
> or not I should run mysql_install_db. Looks like I should, 'cuz
> slack doesn't use RPM.
>
> Cheers
>
Hello.
I think that deleting .ibd files is a weird behavior for installer. Did
you use innodb_file_per_table? If not, then a new version couldn't
understand an old format of InnoDB data files. Probably, you could
install a binary copy of MySQL 4.1.9, specify your data directory as
it's data
30 matches
Mail list logo
