MySQL Connector/J 5.0.7 Has Been Released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 5.0.7 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. This is a bug fix release for the current production branch of Connector/J. Version 5.0.7 is suitable for use with any MySQL version inclu

how to do replication for InnoDB

hello list, I'm not familiar with Innodb.I have done well on MyISAM replication. Can you tell me how to replicate Innodb database?thanks. --jennifer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question, please: How to fix TABLE LOCK table and lock mode AUTO-INC waiting ?

Hi, I have been using 5.0.32 MySQL on Debian. Everything worked properly. DRBD has been added and configure with MySQL and restarted. The tables used are InnoDB type and use auto_increment. After that during INSERTs and UPDATEs innodb started to roll back for table lock on AUTO_INC How could

Show command for max_connection_errors. Any ?

Hello All. Is there a way to monitor the max_connection_errors. I'm asking because we had a problem the other day in MYSQL when slowed down and stopped accepting connections from one of the boxes. To resolve this problem, I issued FLUSH HOST and the problem went away. Is there a SHOW command that

Select problem

I am having a problem with SELECT. The table has 3 rows. I am using the C api. Here is my C code. count = mysql_query(my_db, "SELECT * FROM accounts"); er = mysql_error(my_db); res = mysql_use_result(my_db); num_row = mysql_num_rows(res); count is returned as 0 (no error) er is NU

Re: User Administration

How were you manipulating the permissions? I find that the stock query works fine: GRANT SELECT, INSERT,DELETE on mydb.* to systemuser@'%' ; GRANT SELECT, INSERT,DELETE on mydb.* to systemuser@'localhost'; although you may want to play around with allowable networks to connect from. More typic

User Administration

Today I tried to set few user rights for a user. What I need is- There a database called 'mydb' Two users for Mysql 5 on Win 2003 server. One is root and second is 'systemuser'. 'systemuser' do not have right for anything on Mysql, information_schema, but should have only SELECT, INSERT, UPDATE an

Re: Hypothetical design question regarding keyword searching

Greetings, Buy 'Building Scalable Web Sites' [http://www.oreillynet.com/pub/pr/1582], authored by the chief architect of Flickr. Among other interesting topics, he describes the system they use for full-text search. Its pretty simple, though this is just one of the ways you can solve this problem

Re: Hypothetical design question regarding keyword searching

Ysgrifennodd Scott Haneda: I have been looking at stock photo sites lately, started wondering how they are doing their keyword searched. Given a potential for millions of images, each with x keywords, I have come up with two approaches... Is this the sort of thing you're looking for: htt

Re: Replication broken - fatal error 1236: 'error reading log entry'

On Wed, Jul 18, 2007 at 06:13:10PM -0400, I wrote: > This afternoon, both slaves stopped at the same place, with the same error: > 070718 17:28:00 [ERROR] Error reading packet from server: error reading log > entry ( server_errno=1236) > 070718 17:28:00 [ERROR] Got fatal error 1236: 'error readin

Hypothetical design question regarding keyword searching

I have been looking at stock photo sites lately, started wondering how they are doing their keyword searched. Given a potential for millions of images, each with x keywords, I have come up with two approaches... Approach one Images table, with a parent id Keywords table, each keyword would be its

Re: Unique Rowid

On 7/19/07, John Comerford <[EMAIL PROTECTED]> wrote: I am in the process of putting together a web application. I have decided to add a 'RowId' field to all my tables and assign it a unique number so that I use it to retrieve data. In concept this number might be passed back to the server as p

Re: Question related to MySQL and Threads and "Context_voluntary"

On 7/19/07, Mariella Petrini <[EMAIL PROTECTED]> wrote: Question: Which could be the MySQL variables that could be changed and that could provide a major increase ? Take a look on that[1]. [1] http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ --

Re: Unique Rowid

There is a general concern if the user can manipulate variables so that they pose a threat to your app... On 7/19/07 12:56 AM, "John Comerford" <[EMAIL PROTECTED]> wrote: > Hi Folks, > > I am in the process of putting together a web application. I have > decided to add a 'RowId' field to all m

Re: Query Problems

We solved it here, There was a problem in the query, we removed the "t1" at the 'group by' section. The problem was really a sintax error in the code not in the server. Thanks, Douglas 2007/7/19, Michael Dykman <[EMAIL PROTECTED]>: instead of leaving it in PHP, please print out your fully fo

Re: confirm unsubscribe to mysql@lists.mysql.com

On Wednesday 18 July 2007 19:35, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > removed from the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/u/mysql/469e6b8e57586622/kneel.pardoe=virgin.net > > This confirmation serve

Question related to MySQL and Threads and "Context_voluntary"

Hi, I have been working with MySQL 5.1.20 (64 bits compiled on Mac OS for MacPro Intel Xeon Quad-Core qith 2 processors and 8GB of RAM) and MySQL 5.0.41 (32 bits). While running some of the select statements (independently of the storage engine used, either InnoDB or MyISAM) I have noticed that

Re: error once backing up database

Ananda, I cannot host the reasons. Just add one more parameter to avoid "LOCK TABLES". mysqldump --lock-tables=false db That works. Cheers, Thx guys. Ananda Kumar wrote: Hi Banyan, Permission can vary from database to database. Please ask your dba to grant you the permission and then try th

Re: error once backing up database

thx Ananda. I will try. Cheers, Ananda Kumar wrote: Hi Banyan, Permission can vary from database to database. Please ask your dba to grant you the permission and then try the mysqldump On 7/19/07, Banyan He <[EMAIL PROTECTED]> wrote: The question is in this server, I cannot backup the dat

Re: What is the maximum length of "TEXT" column?

> I got a "Data is too long for content column" error in jdbc insert > statement. I defined "content" as "TEXT", and what is the maximum length of > "TEXT"? thanks! Too lazy to search through the MySQL Online Documentation? http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html Mar

What is the maximum length of "TEXT" column?

Hi, all, I got a "Data is too long for content column" error in jdbc insert statement. I defined "content" as "TEXT", and what is the maximum length of "TEXT"? thanks! Yours, Sincerely. Liao Xuefeng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: error once backing up database

Hi Banyan, Permission can vary from database to database. Please ask your dba to grant you the permission and then try the mysqldump On 7/19/07, Banyan He <[EMAIL PROTECTED]> wrote: The question is in this server, I cannot backup the database by issuing mysqldump. On another server, I can. I a

Re: error once backing up database

The question is in this server, I cannot backup the database by issuing mysqldump. On another server, I can. I am sure nobody changes the settings. That's confusing to me. ant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and t

my.cnf components

Hello Everybody, I am working on the tweaking of my.cnf and i am not able to understand that which component should get the maximun ram usage. for example max_allowed_packet, innodb_buffer_pool_size component how much of memory should be alloted to them. How the memory division should be done amo

Re: error once backing up database

You cannot execute the grant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and tables, thereby giving access to possibly sensitive data. It is in no way a serious restriction, it is a very important security feature. If you

Re: error once backing up database

Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the "GRANT" command. regards anandkl On 7/19/07, *Banyan He* <[EMAIL PROTECTED] > w

Re: Restore take lot of time

If you doing for innodb and myisam try this. mysqldump --opt..this will have one insert statements for multiple records . On 7/19/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: Hi Anand, the command is mysqldump -B dp user1 user2 > dump.sql dp - database user1, user2 - table

Re: Restore take lot of time

Hello, On 7/19/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: Hi Anand, the command is mysqldump -B dp user1 user2 > dump.sql dp - database user1, user2 - table The following excerpt is from the mysqldump manpage. It might helps. -B|--databases To dump several

Re: error once backing up database

You mean to say, you cannot execute the "GRANT" command. regards anandkl On 7/19/07, Banyan He <[EMAIL PROTECTED]> wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two

Re: Foreign key constraints - Known issues ?

>I just wanted to know whether there are any known issues in defining and using Foreign key constraints in MySQL 4 and >MySQL 5. >To be specific, are there any issues on using ON DELETE CASCADE and ON UPDATE CASCADE? > >Would there be any performance issues when we define Foreign key constraints? >

Foreign key constraints - Known issues ?

Hello All, I just wanted to know whether there are any known issues in defining and using Foreign key constraints in MySQL 4 and MySQL 5. To be specific, are there any issues on using ON DELETE CASCADE and ON UPDATE CASCADE? Would there be any performance issues when we define Foreign key const

Re: Restore take lot of time

Hi Anand, the command is mysqldump -B dp user1 user2 > dump.sql dp - database user1, user2 - table Regards, Krishna On 7/19/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: what is the command u used for taking mysqldump On 7/19/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: > > Hi All,

Re: error once backing up database

Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kuma

Re: error once backing up database

Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, Banyan He <[EMAIL PROTECTED]> wrote: Hi Guys,

Re: Restore take lot of time

what is the command u used for taking mysqldump On 7/19/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: Hi All, I have taken dump of two table using mysqldump. The size of the dump file is 175 MB. To restore dump file to another machine. It takes about more than 30 minutes. Why it is

error once backing up database

Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker > z:sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any adv

Read the counters for max_questions, max_updates, etc.

hi, According to http://dev.mysql.com/doc/refman/5.1/en/user-resources.html, MySQL can keep track on the number of queries, updates, and connection for user within on an hourly bases. This is done with the help of counters. My question is; how can I read these counters and see the current update