Re: Which AMD Dual Core Processor?
mos wrote: I'm thinking of upgrading my AMD3500 to a dual core AMD processor. Is there any noticeable difference between these? AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939 Toledo (2x1MB cache) AMD Athlon 64X2 4600+ Dual Core S939 Manchester (2x512k cache) Surprisingly, in my tests, a 4600+ Manchester core beats a 4800+ Toledo. I do not recall the cache size on the 4800+s but all my 4600+s have 2x512. I tested extensively using PostgreSQL on kernel 2.6.14 in 64-bit mode as well as a number of custom apps. I did not run mysql however, so the results might be meaningless for your workload. For my purposes, the 4600+ give more performance/$ even though they are slower on paper. The difference was relatively small however, and the biggest impact on speed came from using a gcc CVS/SVN snapshot. Regards, LL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with insert +php
my friend... just put the correct variables : ... VALUES ($_POST['nombreempresa'],$_POST['nombrecontacto'],$_POST['nit'],$_POST['direccion'],$_POST['ciudad'],$_POST['pais'],$_POST['telefono'],$_POST['fax'],$_POST['email1'],$_post['email2'],$_POST['$web'],$_POST['casilla'],$_POST['observaciones'])"; -Original message- From: Marcelo Fabiani [EMAIL PROTECTED] Date: Fri, 01 Sep 2006 15:27:19 -0300 To: Jerry Schwartz [EMAIL PROTECTED] Subject: Re: help with insert +php > Jerry Schwartz escribió: > > I don't see the form. > > > > Unless one of your included files sets the values of your variables, this > > code will insert a row of empty strings every time it executes. > > > > Regards, > > > > Jerry Schwartz > > Global Information Incorporated > > 195 Farmington Ave. > > Farmington, CT 06032 > > > > 860.674.8796 / FAX: 860.674.8341 > > > > > > -Original Message- > > From: Marcelo Fabiani [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 01, 2006 1:06 PM > > To: mysql@lists.mysql.com > > Subject: help with insert +php > > > > > > I'm trying to insert some data to my our web database, but when Insert > > the data, it inserts all the data from my form and ads two rows with no > > data. > > > > Can someone tell me what I'm doing wrong? > > Here is the code: > > > include 'config.php'; > > include 'opendb.php'; > > $sql="INSERT INTO empresas (nombreempresa, nomcontacto, nit, > > direccion, ciudad, pais, telefonofijo, fax, email1, email2, web, > > casilla, observaciones) VALUES > > ('$nombreempresa','$nombrecontacto','$nit','$direccion','$ciudad','$pais','$ > > telefono','$fax','$email1','$email2','$web','$casilla','$observaciones')"; > > mysql_query($sql) or die ("problema con query"); > > echo " Registro Insertado!!"; > > $sq = "SELECT * FROM empresas"; > > $result = mysql_query($sq)or die ("problema Leyendo Tabla");; > > echo ""; > > echo "Nombre > > EmpresaNitDireccionTelefono"; > > while ($row=mysql_fetch_row($result)){ > > echo > > "$row[3]$row[4]$row[5]$row[8]"; > > } > > echo ""; > > include 'closedb.php'; > > ?> > > Regards > > > > Marcelo Fabiani > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > Yes here Is the part of the code of the form: > > > > Nombre Empresa: * > maxlength="100" type="text"> ? > > > Nombre Contacto: * > maxlength="100" type="text"> ? > > name="reset" id="reset" value="Limpiar" type="reset"> > > > Marcelo Fabiani > > > > -- > 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: help please, help please
I am not able to install Mysql on my 2003 server at home. error 1045!! I get an accesd denied for user [EMAIL PROTECTED] I need the full error, but have some questions: 1. Are you sure that you set a root password? 2. Are you using the command line client or some other administrative tool? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which AMD Dual Core Processor?
At 02:59 PM 9/1/2006, you wrote: mos wrote: AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939 Toledo (2x1MB cache) AMD Athlon 64X2 4600+ Dual Core S939 Manchester (2x512k cache) I would think, as a blind guess, that the Toledo processor (twice the cache) would be the hands-down winner in this list. I would think so too but common sense approach when choosing hardware isn't always correct.:) What looks good on paper doesn't necessarily make it in the real world. Take a look at Intel's HyperThreading feature which delivered very little performance improvement but was a great marketing ploy. I just wanted to know if anyone actually has used the chip and has seen a difference using 1mb cpu cache compared to the 512k cache. TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help please, help please
I am not able to install Mysql on my 2003 server at home. error 1045!! I get an accesd denied for user [EMAIL PROTECTED] my firewall is off and I know it is not the port becuase when I configure it as 'anonymous" it works like a charm. Please help me - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
Re: help with insert +php
Chris W escribió: Marcelo Fabiani wrote: Here is the code: . . . $result = mysql_query($sq)or die ("problema Leyendo Tabla");; . . . Why are there two ; at the end of that line? I'm really not sure what if anything that will do but I would remove it just in case. Also are there any triggers on this table that could be doing this? One for the insert comand and the other to browse the data that I have -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with insert +php
Marcelo Fabiani wrote: Here is the code: . . . $result = mysql_query($sq)or die ("problema Leyendo Tabla");; . . . Why are there two ; at the end of that line? I'm really not sure what if anything that will do but I would remove it just in case. Also are there any triggers on this table that could be doing this? -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Restore Questions
We're using MySQL 5.0.22 on CentOS 3.7 (running on VMWare). We use InnoDB tables and also use views, stored procedures, and functions. I had to move our development databases to a new server this week by doing a backup with mysqldump and then restoring the databases on the new server. I ran into a weird problem, in one database the views were restored as tables! I also got this error: ERROR 1418 (HY000) at line 206: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) Looking at the dump file, in general the sequence of statements is: 1. create tables 2. insert into tables 3. create tables that are really views in the original db 4. create functions 5. create stored procedures 6. drop the tables that should be views and re-create them as actual views In my case, #4 caused the error, #5 succeeded (all procs were created), and then it's like #6 doesn't happen. I fixed this by adding deterministic to the offending function, but it brings up some questions. Why does mysqldump first create views as tables, then drop and re-create them as views? Why did the stored procs get created after the error, but not the views? I also tried to create another function without specifying deterministic, and was unable to...so how did I create that function in the first place? Note that when we built out the new server, we used the same my.cnf file so the two should have been configured the same. Thank you. Donna DeVaudreuil
Re: help with insert +php
John Meyer escribió: Try this $retval = mysql_query($sql) or die(mysql_error()) To at least get an idea of what MySQL thinks is the error. The is no error in the insert it adds the row, but in addition add's two more rows with no data, only the auto_increment ; Example: Adds 1 Marcelo Fabiani x 2 3 Marcelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with insert +php
> [EMAIL PROTECTED] escribió: >> Marcelo, >> >> The usual advice is to echo out the query string and examine it for syntax. >> Assuming it has form data in it for the variables, then try copying/pasting >> it into the mysql client and run it from there. Let us know how that goes. >> >> David >> > Already done that and it inserts one row Have you run mysql_error($link) after mysql_query() in PHP? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which AMD Dual Core Processor?
mos wrote: AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939 Toledo (2x1MB cache) AMD Athlon 64X2 4600+ Dual Core S939 Manchester (2x512k cache) I would think, as a blind guess, that the Toledo processor (twice the cache) would be the hands-down winner in this list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with insert +php
[EMAIL PROTECTED] escribió: Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David Already done that and it inserts one row Marcelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with insert +php
Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which AMD Dual Core Processor?
I'm thinking of upgrading my AMD3500 to a dual core AMD processor. Is there any noticeable difference between these? AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939 Toledo (2x1MB cache) AMD Athlon 64X2 4600+ Dual Core S939 Manchester (2x512k cache) TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with insert +php
Jerry Schwartz escribió: I don't see the form. Unless one of your included files sets the values of your variables, this code will insert a row of empty strings every time it executes. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Marcelo Fabiani [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 1:06 PM To: mysql@lists.mysql.com Subject: help with insert +php I'm trying to insert some data to my our web database, but when Insert the data, it inserts all the data from my form and ads two rows with no data. Can someone tell me what I'm doing wrong? Here is the code: Registro Insertado!!"; $sq = "SELECT * FROM empresas"; $result = mysql_query($sq)or die ("problema Leyendo Tabla");; echo ""; echo "Nombre EmpresaNitDireccionTelefono"; while ($row=mysql_fetch_row($result)){ echo "$row[3]$row[4]$row[5]$row[8]"; } echo ""; include 'closedb.php'; ?> Regards Marcelo Fabiani -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Yes here Is the part of the code of the form: Nombre Empresa: * maxlength="100" type="text"> ? Nombre Contacto: * maxlength="100" type="text"> ? name="reset" id="reset" value="Limpiar" type="reset"> Marcelo Fabiani -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: help with insert +php
I don't see the form. Unless one of your included files sets the values of your variables, this code will insert a row of empty strings every time it executes. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Marcelo Fabiani [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 1:06 PM To: mysql@lists.mysql.com Subject: help with insert +php I'm trying to insert some data to my our web database, but when Insert the data, it inserts all the data from my form and ads two rows with no data. Can someone tell me what I'm doing wrong? Here is the code: Registro Insertado!!"; $sq = "SELECT * FROM empresas"; $result = mysql_query($sq)or die ("problema Leyendo Tabla");; echo ""; echo "Nombre EmpresaNitDireccionTelefono"; while ($row=mysql_fetch_row($result)){ echo "$row[3]$row[4]$row[5]$row[8]"; } echo ""; include 'closedb.php'; ?> Regards Marcelo Fabiani -- 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]
help with insert +php
I'm trying to insert some data to my our web database, but when Insert the data, it inserts all the data from my form and ads two rows with no data. Can someone tell me what I'm doing wrong? Here is the code: include 'config.php'; include 'opendb.php'; $sql="INSERT INTO empresas (nombreempresa, nomcontacto, nit, direccion, ciudad, pais, telefonofijo, fax, email1, email2, web, casilla, observaciones) VALUES ('$nombreempresa','$nombrecontacto','$nit','$direccion','$ciudad','$pais','$telefono','$fax','$email1','$email2','$web','$casilla','$observaciones')"; mysql_query($sql) or die ("problema con query"); echo " Registro Insertado!!"; $sq = "SELECT * FROM empresas"; $result = mysql_query($sq)or die ("problema Leyendo Tabla");; echo ""; echo "Nombre EmpresaNitDireccionTelefono"; while ($row=mysql_fetch_row($result)){ echo "$row[3]$row[4]$row[5]$row[8]"; } echo ""; include 'closedb.php'; ?> Regards Marcelo Fabiani -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Incorrect information in file...
I have pretty much figured out what is going on. I forgot one pretty major item from my initial message. I had started mysql up without any my.cnf configuration file at first and was using it without prior to my using the my-huge.cnf config file. Please correct me if I'm wrong. That ultimately changed the way InnoDB tables were viewed by MySQL because of the new log file and data file path parameters. Which ultimately lead me to this page: http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html On Thursday, August 31, 2006 at 2:25:07 PM, Mikhail confabulated: > How much do you care about "test" table, Duane? > In your own words: "I do not have anything really set up yet", so drop > the table or even the whole testdb database and see if that helps > Regards, > Mikhail Berman > -Original Message- > From: Duane Hill [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 31, 2006 10:18 AM > To: Mikhail Berman > Cc: mysql@lists.mysql.com > Subject: Re: Incorrect information in file... > On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: >> Hi Duane, >> Have you tried to repair "test" table using "REPAIR" to see if that >> solves your problem? > That didn't seem to work. The result returned was: > mysql> repair table test; > > +-++--+- > + > | Table | Op | Msg_type | Msg_text > | > > +-++--+- > + > | testdb.test | repair | error| Incorrect information in file: > './testdb/test.frm' | > > +-++--+- > + > I even tried with the USE_FRM option and received the same result. > >> -Original Message- >> From: Duane Hill [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 31, 2006 9:49 AM >> To: mysql@lists.mysql.com >> Subject: Incorrect information in file... >> MySQL v5.0.24 on FreeBSD v6.0-RELEASE >> I was attempting to do some tweaking in a my.cnf to increase >> performance on a server here. I had copied the my-huge.cnf config >> file into /etc and uncommented the section on InnoDB from within. I >> also changed the thread_concurrency option from 8 to 4. That was the >> only changes I made in the configuration file. Upon restarting >> MySQL, I could not select anything from any of the InnoDB tables >> and received this error: >> ERROR 1033 (HY000): Incorrect information in file: >> './testdb/test.frm' >> >> I did do some searching in the list archives but couldn't come up >> with anything concrete. >> For the convenience, here is the options that were uncommented: >> innodb_data_home_dir = /var/db/mysql/ >> innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend >> innodb_log_group_home_dir = /var/db/mysql/ >> innodb_log_arch_dir = /var/db/mysql/ >> innodb_buffer_pool_size = 384M >> innodb_additional_mem_pool_size = 20M >> innodb_log_file_size = 100M >> innodb_log_buffer_size = 8M >> innodb_flush_log_at_trx_commit = 1 >> innodb_lock_wait_timeout = 50 -- "This message was sent using 100% recycled electrons." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to make this work ?
Mikhail Berman wrote: Hi Ravi, If you are working with one of *NIX, you can try to use $mysqldump --no-data DB1 tblname | mysql DB2 --no-data switch will dump only data base structure Regards, Mikhail Berman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 5:47 AM To: mysql@lists.mysql.com Subject: How to make this work ? Hi All, How to make this work "CREATE TABLE DB2.tblname LIKE DB1.tblname;" Can we have simultaneous connections with 2 DBs? Regards, Ravi K Hi - You can also do a: CREATE TABLE newtable SELECT * FROM oldtable; I use this often for creating backups before I run code in testing. Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql crashes on drop database?
Hi, Each night I replicate a server running a 4.1 version of mysql via mysqldump and then import to a box running a 5.0.18-standard. It has been working well for some four or five months. Suddenly, the job started failing during the import. After stepping through the job, I determined that attempting to drop the first database causes mysql to crash. There are about seven or eight tables in said database, mostly empty, with about five or six records total in the database in question mysql> drop database AccountingAdminDB; ERROR 2013 (HY000): Lost connection to MySQL server during query Per the mysql docs, I first tried rebooting the machine, to no avail. Interestingly, I can read all of the records in the all of the associated files. Check table on each table did not turn up anything. File permissions look ok. I use innodb file per table for most tables. The data directories and subordinates all use mysql.mysql as the owner and group. The data files are rw by owner. A mysql.error.log file is being generated: 060901 9:45:18 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060901 9:45:24 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 68 3744135056. InnoDB: Doing recovery: scanned up to log sequence number 68 3744135056 InnoDB: Last MySQL binlog file position 0 0, file name 060901 9:45:24 InnoDB: Started; log sequence number 68 3744135056 060901 9:45:24 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.18-standard' socket: '/srv/mysql/lx07sock' port: 3307 MySQL Community Edition - Standard (GPL) InnoDB: Error: trying to access page number 464309120 in space 0, InnoDB: space name /srv/mysql/lx07/ibdata1, InnoDB: which is outside the tablespace bounds. InnoDB: Byte offset 0, len 16384, i/o type 10 060901 10:03:37InnoDB: Assertion failure in thread 2934508464 in file fil0fil.c line 3869 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. 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=268435456 read_buffer_size=8384512 max_used_connections=2 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2719343 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8a40170 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=0xaee8cd1c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x815bbb0 0xe420 0x82f2c3e 0x82f2c3e 0x82ea23c 0x8308090 0x83074ee 0x82b5e4f 0x826ff01 0x82a7ed6 0x82a813c 0x82a825c 0x8282ec0 0x8282bfb 0x82979e2 0x820cd73 0x81fffdb 0x8212f00 0x82128b4 0x8211cce 0x8211509 0x81728bf Stack trace seems successful - bottom reached Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x8a5fde8 = drop database AccountingAdminDB thd->thread_id=57 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 060901 10:03:37 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060901 10:03:37 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 68 3744135066. InnoDB: Doing recovery: scanned up to log sequence number 68 3744135066 InnoDB: Last MySQL binlog file position 0 0, file name 060901 10:03:37 InnoDB: Started; log sequence number 68 3744135066 060901 10:03:38 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.18-standard' socket: '/srv/mysql/lx07sock' port: 3307 MySQL Community Edition - Stan
Re: solaris build mysql from source using gcc
Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. Sorry I meant 10 theremy solaris experience comes from the 'old days' before they went and dropped the 2. from the version scheme. Here's my config.nice for Solaris 2.x on Sparc with gcc: CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex --enable-thread-safe-client --enable-loca l-infile --disable-shared --without-innodb --with-named-curses-libs=-lncurses Just in case anyone's curious, here's my config.nice for Solaris 2.x on x86 with gcc: CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer -march=pentiumpro" CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -march=pentiumpro" ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex --with-unix-socket-path=/tmp/mysql.sock --enable-thread-safe-client --enable-local-infile --disable-shared --without-innodb --with-named-curses-libs=-lncurses --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static Couple of notes: I build without INNODB and ncurses is installed. This works great... very stable. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: solaris build mysql from source using gcc
--On September 1, 2006 8:38:21 AM -0600 Michael Loftis <[EMAIL PROTECTED]> wrote: Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. Sorry I meant 10 theremy solaris experience comes from the 'old days' before they went and dropped the 2. from the version scheme. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql privileges
* now i can access with [EMAIL PROTECTED] but i can't create databases What does "show grants" display when you login as root? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql privileges
Hello, ok, you can tell me i'm a crazy boy... I've made a lot of changes to privileges in a mysql server. Then, i saw 2 root account: the first may be able to access from localhost, the second from all hosts. Mysql server is inside our intranet so i decided to drop [EMAIL PROTECTED] Now we have a lot of problem. I made a lot of things when i understood that it was not a good idea and actual situation is this: * now i can access with [EMAIL PROTECTED] but i can't create databases * now i can't access with [EMAIL PROTECTED] or [EMAIL PROTECTED] How can i interpret this situation? How can i access to mysql server from other hosts? How can i create db as root? Thank you for answers! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
partial word search with FULLTEXT
MySQL FULLTEXT searches support wildcard suffixes such as: mysql> SELECT * FROM articles WHERE MATCH (title,body) -> AGAINST ('apple*' IN BOOLEAN MODE); which returns all title/body lines that contain the prefix 'apple', such as appleby appleseed but not bigapple redapple This is described online at: http://dev.mysql.com/doc/refman/4.1/en/fulltext-boolean.html Question: can FULLTEXT be configured to support wildcard prefixes _and_ suffixes simultaneously? IE, something like: mysql> SELECT * FROM articles WHERE MATCH (title,body) -> AGAINST ('*apple*' IN BOOLEAN MODE); so that we would get back all of the above results: appleby appleseed bigapple redapple Thanks, creadcdd - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
Re: solaris build mysql from source using gcc
Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. --On September 1, 2006 2:10:17 PM + [EMAIL PROTECTED] wrote: Hi, Any chance i could get somebody's help on how to build MySQL from source using the gcc compiler on Solaris (10)? Thanks, Charles -- "Genius might be described as a supreme capacity for getting its possessors into trouble of all kinds." -- Samuel Butler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
solaris build mysql from source using gcc
Hi, Any chance i could get somebody's help on how to build MySQL from source using the gcc compiler on Solaris (10)? Thanks, Charles
RE: mysql_upgrade script problems on MySQL 5.0.24
Chris, That's a great question. Especially since this file does not exist anywhere on my system. I'd be glad to create it by hand, but I wouldn't know what should be in it. I tried copying the my.cnf file to this location and naming it upgrade_defaults.cnf, upgrade_defaults, and also a 3rd try (created a sub-directory called "upgrade_defaults) and put the my.cnf in this new subdirectory. All of these attempts ended up giving me the same error I had originally. Any ideas? Has anyone upgraded up to 5.0.24 on Solaris 9 (or other platforms) and been able to run this script successfully? -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 2:02 AM To: Whisler, David Cc: mysql@lists.mysql.com Subject: Re: mysql_upgrade script problems on MySQL 5.0.24 > error: Found option without preceding group in config file: > /u07/mysql/data/upgrade_defaults at line: 2 Fatal error in defaults > handling. Program aborted This is your problem. What's in that file (/u07/mysql/data/upgrade_defaults) ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Insane execution time for JOIN query
>> On 8/31/06, Harrison Fisk ** <[EMAIL PROTECTED]> *** wrote: >> Hello, >> >> On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote: >> >>> Hey list; >>> >>> I posted this message under an earlier thread which touched the same >>> subject - but I realized my case could be slightly different, thus >>> posting a new thread here. Sorry for any inconvenience. >>> >>> I have two tables, one of which is a list over products which all have >>> unique product id's (product_id). The other table, items, is a list >>> over the products' corresponding prices and stock info; one row per >>> each one of our supplier that has the item. >> >> The problem is that your product_id is an INT in one table and a >> VARCHAR in the other. This will cause MySQL to have to do >> conversions of data types, which means it can't use indexes. Switch >> product_id to be an INT and both tables and it should solve your >> performance problems. > Ouch. I reduced the DELETE... query time to 0.4 secs in total after > changing the second table's product_id to an INT. Thanks alot, I sure > wouldn't have seen this on my own after staring myself blind on this - > you've saved me lots of work! > > I'm sure gonna be more careful with the data types next time! :-) Having taken a weeklong MySQL course with Harry a number of years ago, I'm not surprised by his knowledge and acumen. It's a benefit to us all that he still frequents this mailing list. David Giragosian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to make this work ?
Hi Ravi, If you are working with one of *NIX, you can try to use $mysqldump --no-data DB1 tblname | mysql DB2 --no-data switch will dump only data base structure Regards, Mikhail Berman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 5:47 AM To: mysql@lists.mysql.com Subject: How to make this work ? Hi All, How to make this work "CREATE TABLE DB2.tblname LIKE DB1.tblname;" Can we have simultaneous connections with 2 DBs? Regards, Ravi K 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 proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to dump stored procedures to a file?
It seems that mysqldump on mysql 5.0 does not export my stored procedures. How do I dump these out so that other people can load them into their copies of my database? Matt -- A better way of running series of SAS programs: http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to make this work ?
On Fri, Sep 01, 2006 at 03:17:14PM +0530, [EMAIL PROTECTED] wrote: > How to make this work "CREATE TABLE DB2.tblname LIKE DB1.tblname;" It does work perfectly with 5.0. Mabe cross-database queries didn't work with earlier versions? Which version do you use? > Can we have simultaneous connections with 2 DBs? Using /usr/bin/mysql? Even with one connection you can access as much databases as you like. Even a join of tables from different databases work. bye, -christian- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Drop Index if Exists
Thanks What I am getting at is: does the "IF EXISTS" qualifier work in this context? I have an index that is present in some DB's but not in others. I want to run a generic script to upgrade them all. I don't want the script to stop if the index is not present. Thanks - Adam Visolve DB TEAM wrote: Hello Adam,This is the exact syntax to drop the index.DROP INDEX index_name ON tbl_nameThanksVisolve DB Team . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Drop Index if Exists
Hello Adam,This is the exact syntax to drop the index.DROP INDEX index_name ON tbl_nameThanksVisolve DB Team . - Original Message - From: "Adam Lipscombe" <[EMAIL PROTECTED]> Cc: Sent: Friday, September 01, 2006 3:28 PM Subject: Drop Index if Exists Folks, Does this work in MYSQL 5? I tried "DROP INDEX [NAME] IF EXISTS;" and got an error "check your syntax". Thanks - Adam -- 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]
Drop Index if Exists
Folks, Does this work in MYSQL 5? I tried "DROP INDEX [NAME] IF EXISTS;" and got an error "check your syntax". Thanks - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to make this work ?
Hi All, How to make this work "CREATE TABLE DB2.tblname LIKE DB1.tblname;" Can we have simultaneous connections with 2 DBs? Regards, Ravi K 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 proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
Re: mysql_upgrade script problems on MySQL 5.0.24
Hi, could it be this bug : http://bugs.mysql.com/bug.php?id=21011 2006/8/31, Whisler, David <[EMAIL PROTECTED]>: I've upgraded from 5.0.22 to 5.0.24 MySQL Server on Solaris 9 using the Solaris package utility (which means I de-installed 5.0.22 then installed 5.0.24 in the same location, environment, configuration). I'm having the following error when trying to execute the mysql_upgrade executable according to the directions. This may not be necessary given it's a minor upgrade, but still - it should work, right? Here's the error. -- $ mysql_upgrade -u=root -p --basedir=/u01/app/mysql --datadir=/u07/mysql/data -v Enter password: Running /u01/app/mysql/bin/mysqlcheck --defaults-extra-file=/u07/mysql/data/upgrade_defaults --check-upgrade --all-databases --auto-repair --user==root error: Found option without preceding group in config file: /u07/mysql/data/upgrade_defaults at line: 2 Fatal error in defaults handling. Program aborted Error executing '/u01/app/mysql/bin/mysqlcheck --defaults-extra-file=/u07/mysql/data/upgrade_defaults --check-upgrade --all-databases --auto-repair --user==root' -- What's the deal with the "upgrade_defaults" file that it's complaining about? This file doesn't exist anywhere on my server (does it create it automatically), and according to the instructions it should be using the options I setup on the command line (and if not, it should at least be using the "my.cnf" file that I've setup in the MYSQL base directory. Here's my mysql.cnf (Note, I added the [mysql_upgrade] group options to see if that made a difference - and it didn't). $ more my.cnf [mysqld] basedir=/u01/app/mysql datadir=/u07/mysql/data #log #log-bin log-slow-queries [mysql_upgrade] basedir=/u01/app/mysql datadir=/u07/mysql/data --- This is on my test box (I'm no dummy - or at least I like to think that), so no harm no foul. However, I'd like to upgrade my Production box, but am waiting for this to be resolved first. MySQL 5.0.24 seems to run fine without running this script, but then again - I like to play it safe.Any ideas? David Whisler -- http://www.myspace.com/sakuradrop : forget the rest http://www.w-fenec.org/ Webzine rock/metal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Understanding Query-Cache math...
Hello I don't understand why query_cache_size / query_cache_min_res_unit != Qcache_total_blocks and Qcache_free_memory / query_cache_min_res_unit != Qcache_free_blocks Can anybody enlight me so that I know if I have to increase the Query-Cache or not? mysql> SHOW status LIKE "Qcache_%"; +-+---+ | Variable_name | Value | +-+---+ | Qcache_free_blocks | 10382 | | Qcache_free_memory | 247491776 | | Qcache_hits | 119254865 | | Qcache_inserts | 5412923 | | Qcache_lowmem_prunes| 0 | | Qcache_not_cached | 58724815 | | Qcache_queries_in_cache | 16002 | | Qcache_total_blocks | 42464 | +-+---+ mysql> SHOW variables LIKE "query_cache_%"; +--++ | Variable_name| Value | +--++ | query_cache_limit| 8388608| | query_cache_min_res_unit | 4096 | | query_cache_size | 268435456 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF| +--++ thanks, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10 Tel 0241/701333-11 [EMAIL PROTECTED]D-52064 Aachen Fax 0241/911879 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Comparing to a part of a string
Hi All, Is there a faster way of doing this query SELECT t1.to_uri as to_uri, t1.from_uri as from_uri, t1.sip_from as sip_from, t1.username as username, DATE(t1.time) as startdate, t1.time as start, t2.time as stop, TIMEDIFF(t2.time,t1.time) as timediff FROM acc AS t1 INNER JOIN acc AS t2 ON t1.sip_callid = t2.sip_callid AND ((t1.fromtag = t2.fromtag AND t1.totag = t2.totag) OR (t1.fromtag = t2.totag AND t1.totag = t2.fromtag)) LEFT JOIN acc AS t3 ON t1.sip_callid = t3.sip_callid AND ((t1.fromtag = t2.fromtag AND t1.totag = t2.totag) OR (t1.fromtag = t2.totag AND t1.totag = t2.fromtag)) AND t3.sip_method='INVITE' AND t1.time > t3.time WHERE t1.sip_method='INVITE' AND t2.sip_method='BYE' AND t3.sip_method IS NULL AND ((t1.sip_status ='200' and t2.sip_status='200') AND (YEAR(t1.time) = '2006' AND MONTH(t1.time)='9' AND SUBSTRING_INDEX(t1.sip_callid,'@',-1)='210.1.71.51')) order by t1.time what i really want to do is get the IP address part of t1.sip_callid, is there a faster way of extracting it? here is a sample string in t1.sip_callid [EMAIL PROTECTED] TIA Regards, Nhadie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]