Using Visio to diagram MySQL db, export SQL
Hi, I have Visio 2002. I am trying to set it up to use MySQL-specific datatypes (e.g., ENUM) and have some success using the User-Defined Types. But what I really want is something that I can export from Visio to actual SQL statements, and I am not succeeding in finding that at all. If Visio is total toast for this purpose, is there a comfortable open source tool that works under windows that will let me/help me visually set up my entity diagrams as I work out my database schema? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
two masters, one slave
Is it possible to have two masters and one slave? I'm trying to replicate two master databases so that I have a failover. The alternate, I guess, would be to have two instances of mysql listing on different ports on the slave server platform? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: user d/b access
At 01:56 PM 1/6/2004, you wrote: Just fired up mysql 3.23.53 * Created a d/b, and then created an admin user for that d/b, using GRANT ALL ON URCMS.* TO urcms_admin IDENTIFIED BY 'changeme' WITH GRANT OPTION; Yup. Well known privileges problem. The short answer is that the default MySQL install (why) creates an anonymous user who can log on from anywhere. Until you get rid of that user, who has no privileges to read any database, you can't set up any other users who can log in from anywhere. So, USE mysql; DELETE FROM user where User=; FLUSH PRIVILEGES; and all will work. ari -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reverse DNS question
At 10:55 AM 12/17/2003, you wrote: MySQL checks the IP address of the user connecting to it's server. It then does a Reverse DNS lookup on that IP address, to get the name associated with it (there is only one name associated with any IP, the rest are just aliases) Suppose we wanted to associate a batch of queries with a cname, is there a way to do that? In other words, if I have both foo.mysite.com and bar.mysite.com, on a host called baz.mysite.com, and I want to restrict access to some tables to foo, and to other databases to bar, is there something I can do at the cname level? (Obviously I can restrict access to specific users - that's the next level of security down.) ari -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
missing something obvious w/grant statement length?
I seem to have run into a problem with a host name that incorporates a hyphen: mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY foo; ERROR 1064: You have an error in your SQL syntax near '-dev.foo.com IDENTIFIED BY foo' at line 1 mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY foo; ERROR 1145: The host or user argument to GRANT is too long I must be missing something very obvious--how to incorporate a hostname with a hyphen, for instance. Can someone help? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stress testing
We have just put up a new MySQL 3.23.x on a modest Sun V120 with 1GB RAM and a few gig of hard disk space. We're running Solaris 2.8. We seem to be clueless (I am certainly clueless) about testing various configuration options so that we are reasonably optimizing the resources available to this server. We ran through (approximately) the four configuration files included with the MySQL distro, and then added more memory (we had, after all, 1GB). We set up a script to repeated parse some common documents with lots of queries. Then we tried the sort of exercise where we'd create temporary tables and copy back and forth. Finally, we ran a load of SELECTs using full-text search (3 explicitly joined tables). We did not record statistically significant results. In truth, we have just begun using MySQL, and don't know what our pattern of usage is. Is there an idealized generalized configuration model and a tool or method available to test our server against that ideal? The online reference doesn't say much about optimization, and it is surely messier when we don't really know what we are optimizing for (or how to test, assuming we did know). Any suggestions? stress testers that have matched up against specific types of configuration? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
practical MySQL database size limits
We're talking about storing binary files (images) inside a MySQL database to take advantage of the granularity and control we get over file access that way. But we already have 1.5GB, and that could lead to a very large database very quickly. What are people's experiences with large MySQL databases? What are the practical limits under Solaris 2.8? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
binding a domain name to a MySQL instance
Is there any way to bind something other than the hostname to a MySQL instance? I'm going to be moving a database from one server to another, and would like the scripts that reference that data to simply talk to db.mydomain.com, rather than have to reconfigure things during launch. Is this possible? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
permissions for updating from one machine to another
I'm trying to set up a script for updating the tables on our production machine with work done on the test machine. The user that will be running the script, has SELECT privileges on the source database. What privileges does the user need for the target database? Can I get by with DELETE,INSERT? What would be a reasonable way to approach this? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my_print_defaults: not found
When I run my startup script, I get the following message: # /etc/rc2.d/S99mysql start /etc/rc2.d/S99mysql: my_print_defaults: not found # Starting mysqld daemon with databases from /usr/local/mysql/data I've tried adding a command print-defaults to my.cnf, but that caused the startup to terminate. Is this something that can just as easily be disabled, or is there some information that is being sought here that should be placed correctly somewhere? ari Ari Davidow [EMAIL PROTECTED] www.klezmershack.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
@HOSTNAME@: not found
When I start mysql 3.23.38 on our Solaris 2.8 machine, with or without the /etc/my.cnf file read (i.e., I can move it out of the way or not), I get the following messages: /etc/rc2.d/S99mysql: @HOSTNAME@: not found S99mysql is the script that starts up MySQL when I reboot the machine (I believe it points to a script in init.d). This is especially confusing because the script is set to run in the Bourne shell, and my limited knowledge of same doesn't know of a variable called @HOSTNAME@. There is a HOST, accessed, presumably, by $host, but substituting that into the script doesn't appear to work, either. Ideas? Kyle Hayes wrote: On Friday 26 October 2001 07:18, Wai Lee wrote: I dig through the manual and changed any possible settings set-variable= max_heap_table_size=2000M set-variable= key_buffer=2500M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=2500M set-variable= join_buffer=2500M set-variable= record_buffer=2500M set-variable= myisam_sort_buffer_size=2500M set-variable= myisam_max_sort_file_size=2500M set-variable= myisam_max_extra_sort_file_size=2500M set-variable= thread_cache=8 I am not certain, but I think you told MySQL to use 2.5G x 5 or 12.5GB! That is a little more than the 4GB you have in the machine :-) In general, the advice I have seen it to make sure that all allocated buffers take no more than about 50% of the memory in the machine. MySQL allocates buffer space for indexes, but _NOT_ data. It lets the OS do that. Linux does caching of disk data very well, but you need to leave it some room to do this. When you leave at least 50% of the space for the OS, it has a chance to cache disk data and accesses will be much faster. If you have a lot of large indexes, I would drop these settings to something like: set-variable= max_heap_table_size=200M set-variable= key_buffer=1000M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=250M set-variable= join_buffer=250M set-variable= record_buffer=250M set-variable= myisam_sort_buffer_size=250M set-variable= myisam_max_sort_file_size=2500M ?? Not sure about this one. Check the manual. set-variable= myisam_max_extra_sort_file_size=2500M ?? Not sure about this one. Check the manual. set-variable= thread_cache=8 Best, Kyle -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MicroTelco Services saves money on every Fax: - Fax to email (FREE) - Fax to PSTN based Fax (Up to 95% Savings) - Fax Broadcasting: Send 100s of faxes to fax machines and email addresses in the time it takes to send just one! === So send a fax today and let us know what you think! For more info. visit: www.internetfaxjack.com === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php