Re: error with java
Can you post few lines of the code where you are making the connection? On 4/10/06, marco stagno [EMAIL PROTECTED] wrote: Wild stab in the dark here - Java I/O permissions not set correctly on your machine to allow it? If I recall, Java's sandbox feature means you have to supply a permissions file for I/O. Perhaps that file already exists on the other machine that works? I don't know so much Java, but I didn't changed anything in the 2 machine from the default installation (Java 1.5xx) if you can tell me more, I can check thank you again!! MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- http://chatter.mirislam.com/
Re: Help...I am desparate
I suppose you could set the suid bit on mysqld binary. But that itself will be a security risk. I am not sure why your security folks are insisting on ports below 1024. I hope they realize anything running under 1024 must be run as root. And anything running root can pose a serious security risk. On 1/5/06, Logg, Connie A. [EMAIL PROTECTED] wrote: No...One machine eventually worked on port 1000, and another I changed the port back to the standard port 3306. I have run into this before and don't know what makes it finally run. My security folks asked me to run on port 1000 or another port less than 1024. Fortunately the machine they were concerned about did finally work on 1000...but I do not know why. Thanks for everyone's suggestions, Connie Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -Original Message- From: Caroline Jen [mailto:[EMAIL PROTECTED] Sent: Thursday, January 05, 2006 10:13 AM To: Logg, Connie A. Subject: Re: Help...I am desparate Is there anything in your PC listening to Port 1000? It seems that there is a conflict. --- Logg, Connie A. [EMAIL PROTECTED] wrote: I am trying to start mysql and I keep getting the following error. There is no other server or anything else using port 1000. I have checked netstat and the port is not active. 60103 15:54:02 mysqld started 060103 15:54:02 InnoDB: Started; log sequence number 0 386242 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? 060103 15:54:02 [ERROR] Aborting 060103 15:54:02 InnoDB: Starting shutdown... 060103 15:54:04 InnoDB: Shutdown completed; log sequence number 0 386242 060103 15:54:04 [Note] /usr/sbin/mysqld: Shutdown complete 060103 15:54:04 mysqld ended My /etc/my.cnf file is: [EMAIL PROTECTED] v3src]$ more /etc/my.cnf [mysqld] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [mysqld.server] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [client] socket=/home/iepm/mysql/mysql.sock port=1000 The system had crashed and burned because of a disk error so I have loaded it with the following rpms [EMAIL PROTECTED] v3src]$ rpm -qa | grep -i mysql MySQL-client-standard-5.0.18-0.rhel3 MySQL-server-standard-5.0.18-0.rhel3 MySQL-standard-debuginfo-5.0.18-0.rhel3 MySQL-shared-standard-5.0.18-0.rhel3 MySQL-devel-standard-5.0.18-0.rhel3 The machine is running: Linux socrates.xxx.xxx.xxx 2.4.21-27.0.2.ELsmp #1 SMP Tue Jan 18 19:25:35 CST 2005 i686 i686 i386 GNU/Linux And the release is: [EMAIL PROTECTED] v3src]$ more /etc/redhat-release Scientific Linux SL Release 3.0.4 (SL) [EMAIL PROTECTED] v3src]$ I have not been able to load the perl DBD bundle either. I do: /usr/bin/perl -MCPAN -e 'install::DBD::mysql' and it complains because the server isn't running. I actually am having this problem also on a system running mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686) It will not sucessfully install the perl bundle there. I have run into these problems several times in the past, and eventually tried everything I have tried today, and something usually breaks it loose...but I have had no luck for several days now. Any help you can provide will be greatly appreciated. Connie Logg Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Yahoo! DSL - Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- http://chatter.mirislam.com/
Re: Database slows down when mass users logging on
If you are knowledgeable about the application and know which tables are frequently accessed during the time of crash, you can send the create statements used to create those tables. Also any indexing and how many rows are in the table will also help. In my opinion over a hundred tables for an application sound bit too high. Perhaps some of table can be collapsed to fewer tables. On 1/4/06, Jonathan Chong [EMAIL PROTECTED] wrote: Hi Alex There are over a hundred tables for the site, and those that are related to this query are probably about 15-30. Do you want the CREATE TABLE syntax for all of them? Funnily enough, the file /var/log/mysql_error.log doesn't exist .. I'm using myISAM tables, yes. On 04/01/06, Alex [EMAIL PROTECTED] wrote: the table type whether it is myisam or innodb. create table statements are preferred when you have slow query issues. --Alex On Wed, 04 Jan 2006 15:57:06 +0530, Jonathan Chong [EMAIL PROTECTED] wrote: Sorry I also forgot to ask - when you say the tables, did you want the table structure? There are quite a few tables, perhaps I should just send the tables that are read and written to often when a user hits a page? On 04/01/06, Alex [EMAIL PROTECTED] wrote: Hi, Please provide details like what tables are you using, the entire my.cnf and the information from the mysqld.err when the crashes occurred. --Alex -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- http://chatter.mirislam.com/
Re: Alternative Mysql gui than Navicat for OSX
What is it you are looking for in the application? I use DBVisualizer free version for most of my mysql and oracle use. You can give it a try and see if you like it or not. On 1/2/06, Dan Rossi [EMAIL PROTECTED] wrote: Hi there i am looking for an alternative gui app than navicat for osx. Ive used CocoaMysql in the past and is limited in terms of administration, however has more working features than navicat ever does. I assumed this product was pretty good, however after purchasing boy was i wrong. I wished SqlYog had an osx version as it is a very good application. These people have extremely poor support and have features missing out of it which should be in there in the first place, like advanced dump options like adding bloody drop table statements LOL, they claimed its a feature request. Im really peeved now so i am telling people not to buy this product they are ignoring all my tickets now. The application systematically crashes just doing something simple , i cannot find any crash logs in the normal places osx apps usually use, and ive just found thats its storing saved queries and saved views in a folder called osx in my /Applications root folder not in the Navicat folder or a preference folder ! I had no idea what it is and like to clean my machine up alot and kept trashing it and couldnt work out why the saved queries went missing, this is extremely poor programming. So dont buy navicat , stick with the terminal client :D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- http://chatter.mirislam.com/
Re: Best way to store these data?
You did not say what these data would be used for. Will there be heavy reads? What is the time requirement for each query? Proper way to do this would be by having three different normalized tables. State: state_id PK state_name County: county_id (either abbreviate or create unique numeric id) county_name state_id FK Zip: zip_code PK county_id FK The above schema is normalized. But since portion of the data is static (state and county) it is possible to combine the first two tables into one table. However, the zip table needs to be in separate table unless you like updating records in multiple places. With proper indexing you can find a county name by a zip code with a simple where. It should be very fast. But still slower than one table solution. On 7/13/05, Laszlo Antal [EMAIL PROTECTED] wrote: Hi, I need to store all 50 states and there county + zip in mysql. What is the best way to do it? Should I just put them in to one table and use the states row for primary Id? or Put every state in separate table and use the zip row for primary Id? Which would be faster to find a county? The main search would be by zip or state. Thank you Laszlo Antal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- http://chatter.mirislam.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database structure question...
You have not said what type of information you will be storing in this database. Is it going to be just faculty information? Even if it is just faculty information, you do realize that each school treats departments a bit dfferently. The faculyt maybe under different school, may specialize in certain field(s). What about all those data? Or are you going strictly for First, Last, College type simple scenario? On 7/7/05, Daniel Kasak [EMAIL PROTECTED] wrote: bruce wrote: even though this might mean i get a table with 5 million records??? as opposed to say a 1000 different tables, each with 50,000 records? -bruce That's right. Databases are made for this sort of thing. If you have a separate table for each location, constructing queries to pull data from a number of them at once will be an absolute nightmare, not to mention what will happen if you have to modify the table structure. For example, what do you do if you want to see all records that were entered yesterday? You run 1000 separate queries! You can bet that this will be slower than if everything was in 1 table. Seriously, put everything in 1 table. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb crashes during heavy usage with exceeded memory error
Matthew has already responded. But I will also add, you must rethink how your application is coded. I can not possibly imagine a situation where a user session needs 200meg insert. No matter what database you use you will have a terrible time trying to scale this application. If you give more details about your application and what is being stored as session data perhaps we can help. snip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb crashes during heavy usage with exceeded memory error
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 innodb has to constantly extend the table space it will not have opportunity to anything else. So having 100m for each extend will reduce the number of times it has to increase table space. Are you doing any deletes/updates at the same time? You said 50m inserts to a table. Is that figure per day ? How large (in bytes) is an average row? Lastly look into the my.cnf for a large setup that ships with mysql. I think it is called my-large.cnf that will give you some help on settings. On 7/5/05, Kasthuri Ilankamban [EMAIL PROTECTED] wrote: 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 know whether these inserts causing the memory overflow. Anyway I have included our my.cnf file and error logs from last crash below. Any help would be greatly appreciated. Thanks in advance. Kasthuri -- /etc/my.cnf key_buffer = 8M max_allowed_packet = 128M read_buffer_size = 512K sort_buffer_size = 512K myisam_sort_buffer_size = 5M thread_cache = 1024 table_cache = 1024 query_cache_size = 32M max_connections=1000 wait_timeout=300 # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /var/mysql/data innodb_data_file_path = ibdata1:10M;ibdata2:1G;ibdata3:1G:autoextend # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 1024M innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 256M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DSYNC innodb_lock_wait_timeout = 10 - Mysql Error from error logs: 050704 18:19:21 InnoDB: Error: cannot allocate 101892621 bytes of memory for InnoDB: a BLOB with malloc! Total allocated memory InnoDB: by InnoDB 1989384815 bytes. Operating system errno: 12 InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. 050704 18:19:21 InnoDB: Warning: could not allocate 100892621 + 100 bytes to retrieve InnoDB: a big column. Table name `sessions/horde_sessionhandler` 050704 18:37:16 InnoDB: ERROR: the age of the last checkpoint is 483189148, InnoDB: which exceeds the log group capacity 483180135. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least 10 times bigger than the InnoDB: largest such row. 050704 18:38:23 InnoDB: Fatal error: cannot allocate 100892688 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 1787599407 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=524288 max_used_connections=608 max_connections=700 threads_connected=33 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size) *max_connections = 724986 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x893b6018 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfb3e0b8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x81767d9 0x401698e5 0x83c1657 0x83c1690 0x83bef0c 0x83bef9f 0x832d1c1 0x832d33c 0x82ff5f3 0x83026c5 0x8202b0b 0x8202d63 0x81f021a 0x81bb4fc 0x81bb01d 0x81b1432 0x81b1b20 0x81aea76 0x8189f10 0x818ef68 0x8188a2e 0x81885ee 0x8187e34 0x40163d03 0x402f0267 New value of fp=(nil) failed sanity check, terminating stack trace!
Re: Help needed regarding MySQL-C Libraries on Linux....
The same source that you compiled under VC++ may not work at all under linux. Especially since the header files will be different. Make sure you have the proper header files for linux installed. Also I did not see any linking flags during compilation. On 7/3/05, Ashok Kumar [EMAIL PROTECTED] wrote: Dear Friends, I'm Ashok here. first i'll tell my sys configuration. 1.Redhat-Linux 9 2.Intel Pentium chipset 3.MySQL 4.1 with Development Libraries For this i've downloaded the MySQL4.1 under the specification Linux x86 RPM downloads from the site. In my system, the MySQL Server is working well. I tried to run the C program that will make the connection to the MySQL database and create the user database and useracc table. It's finely working with Windows-VC++. But when i'm trying to run with Linux gcc, I'm getting lots of errors. I don't know what's the problem. I've attached the C-Pgm and the Error info. Pls, help me regarding this. Thanks and Regards, Ashok. Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld error [Can't start server: can't create PID file: No such file or directory]
Make sure /var/run/mysqld exists and wrtable by mysql user snip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compile error
I am stumped with this compile problem with 4.0.24 src. Not sure what is causing it. Can anyone provide some insights? Last time I compiled on the same environment was 4.0.20 source. And all was ok. gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/ms/svc/mysql/4.0.24\ -DDATADIR=\/ms/data/mysql/4.0.24\ -DSHAREDIR=\/ms/svc/mysql/4.0.24/share/mysql\ -DHAVE_CONFIG_H -I. -I. -I.. -I../innobase/include -I./../include -I./../regex -I. -I../include -I. -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -mcpu=v8 -Wa,-xarch=v8plusa -fno-implicit-templates -fno-exceptions -fno-rtti -D_FILE_OFFSET_BITS=64 -DHAVE_CURSES_H -I/netapp/home/mislam/devel/database/mysql40/include -DHAVE_RWLOCK_T -fno-inline -c sql_yacc.cc /usr/local/share/bison.simple: In function `int yyparse()': /usr/local/share/bison.simple:347: `YYSIZE_T' undeclared (first use this function) /usr/local/share/bison.simple:347: (Each undeclared identifier is reported only once /usr/local/share/bison.simple:347: for each function it appears in.) /usr/local/share/bison.simple:347: parse error before `;' make[3]: *** [sql_yacc.o] Error 1 make[3]: Leaving directory `/netapp/home/mislam/devel/database/mysql40/sql' make[2]: *** [install-recursive] Error 1 make[2]: Leaving directory `/netapp/home/mislam/devel/database/mysql40/sql' make[1]: *** [install] Error 2 make[1]: Leaving directory `/netapp/home/mislam/devel/database/mysql40/sql' make: *** [install-recursive] Error 1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL data files
Sure you can. Just move your current data to the location you like to use and then do either of the followings: 1) supply parameter --datadir during startup (or equivalent in my.cnf file) 2) Create a symlink from old location to new location - Original Message - From: VijayKumar Dogra [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 11:22:55 +0530 Subject: MySQL data files To: [EMAIL PROTECTED] Hello All, Is there any way by which I can store data files of mysql in other partition of my system Regards, VijayKumar Dogra -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb - datafiles on an ipstore disk appliance
We have been using innodb tables on our systems and we use netapp to store all the tables. It will be however wise to put transaction logs into a different netapp or somewhere else so that even if the netapp goes kaput (highly unlikely) totally you do not lose any data. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Choosing the option file
How do you start your mysql now ? In any case you need to supply the --skip-innodb option either in the option file (which most likely you don't have) or at the startup time. If you use safe_mysqld script to start your installation just pass on --skip-innodb to it. And even if you don't, it is not going to harm anything as far as I know. On Wed, 22 Sep 2004 19:45:03 +0530, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, Actually i want mysql 4.0 classic version which donot support innodb engine. As classic version is a commercial base one, i installed the mysql 4.0 standard one (which includes innodb). Here my problem is , i have to inactivate the innodb engine. For that what we need to do is From MySQL 4.0 on, the InnoDB storage engine is enabled by default. If you don't want to use InnoDB tables, you can add the skip-innodb option to your MySQL option file. but my problem is how to find out the MySQL option file, and in that how to add that skip-innodb option. Please advise me in this asap. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multi inserts and duplicate key handling
Does anyone know mysql handles duplicate key handling during multi inserts? INSERT INTO test values(1,2),(3,4),(4,5),(1,6),(6,7); Now the above statement fails and gives duplicate key error and exits. Is there a way for it to ignore the key violation and continue processing the batch? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Logging on through ODBC w/o UN Password (Why is my query tool allowing this?)
In all likelihood in your database you have not setup any access privilege yet. You need to look at GRANT command and assign password to atleast root account and any other accounts which will be connecting over network. On Fri, 23 Jul 2004 11:38:06 -0700 (PDT), john sayre [EMAIL PROTECTED] wrote: I am able to log onto a database through ODBC without using a user name or password. I don't want this to be possible for obvious security reasons. What do I need to do to prevent this? This seems pretty freaky! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]