Re: a curse on OS sierra and MySQL?
Well, the command sudo /usr/local/mysql/support-files/mysql.server stop generates the error message: ERROR! MySQL server PID file could not be found! On the other hand, sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist stops the server and sudo /usr/local/mysql/support-files/mysql.server start starts it On 12/3/16, 4:40 PM, "Peter Brawley" wrote: On 12/3/2016 13:58, Martin Mueller wrote: > I was able to install a version of MySQL 5.6 on OS Sierra. It appears that the “launchdaemon’ method works while the mysql.server start/stop method does not work. In retrospect I should have seen that, but I also think that the official documentation could and should be more explicit about what is a significant change in Apple’s start/stop routines. If you mean that seriously, it needs to be more specific. PB - > > On 12/3/16, 12:43 PM, "Peter Brawley" wrote: > > On 12/2/2016 17:58, Martin Mueller wrote: > > Alas, running the stop and start commands under sudo makes zero difference. > > ?! The cited page recommends more than sudo starts and stops, eg ... > > |unset TMPDIR mysql_install_db | > > Did you try that? Did you check the pid setting in my.cnf, eg > pid-file=/var/run/mysqld/mysqld.pid? I believe you need to ensure that > the pid file specified in my.cnf exists and that the mysql daemon owns > it ... > > mkdir /var/run/mysqld > touch /var/run/mysqld/mysqld.pid > chown -R mysql:mysql /var/run/mysqld > > Also see > https://urldefense.proofpoint.com/v2/url?u=http-3A__superuser.com_questions_159486_how-2Dto-2Dkill-2Dprocess-2Din-2Dmac-2Dos-2Dx-2Dand-2Dnot-2Dhave-2Dit-2Drestart-2Don-2Dits-2Down&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=Rp61bfD4ngoSU50qebNy37Nmv34OSqdiU4Sigj8b9zI&s=RDN0din-b9O7hEkNJOKe1CbYe_5MipeeuN2oeOMsWfI&e= > > > This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because the Web is full of complaints and tips. But there doesn’t seem to be any convergence a bout a diagnosis or a likely cure. And there is nothing in the MySQL documentation that draws attention to the probem. > > > > In my case, I’m double frustrated because some months ago my MySQL application broke around this problem, and then a couple of weeks ago it cured itself when I somewhat arbitrarily picked up an earlier version of my installation from Time Machine. > That suggests the problem arose from a change in your app, or a setting > change that occurred in a MySQL upgrade. To show that this is a common > problem that MySQL docs ought to address, you'll need to identify the > setting that's gone awry. > > PB > > > -- MySQL General Mailing List For list archives: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=I5PKsknY5e1wjZZG11zhg1tGbZKrqgs0FExanPNtMkk&s=40lzUebvOmuxTUq-dnXHbwXgaFEyIyYqf93pjPGQibU&e= To unsubscribe: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=I5PKsknY5e1wjZZG11zhg1tGbZKrqgs0FExanPNtMkk&s=40lzUebvOmuxTUq-dnXHbwXgaFEyIyYqf93pjPGQibU&e= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
rescue Inno tables from an abandoned data directory?
I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to start up again. The data directory consists of a mix of ISAM and Inno tables. I was able to copy the ISAM tables into a new 5.6 version, and they work. I understand that INNO tables are different because different tables share a common table space. The MySQL documentation refers to a “cold backup,” where you copy the separate files after a “slow shutdown.” It doesn’t tell you what to do with them after you’ve put them in a “safe place.” In my case, I can reproduce Time machine backups of data directories at varying times. At one point I was able to replace the non-working installation with an earlier installation, but then it failed unpredictably. Are the Inno tables on Time Machine useless, or can I rescue data from them? I’ll be grateful for help
Re: a curse on OS sierra and MySQL?
Alas, running the stop and start commands under sudo makes zero difference. This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because the Web is full of complaints and tips. But there doesn’t seem to be any convergence a bout a diagnosis or a likely cure. And there is nothing in the MySQL documentation that draws attention to the probem. In my case, I’m double frustrated because some months ago my MySQL application broke around this problem, and then a couple of weeks ago it cured itself when I somewhat arbitrarily picked up an earlier version of my installation from Time Machine. But after a couple of weeks it suddenly failed in the same way although I had done nothing on the system administration end. I’m not a programmer, but I’ve worked with lots of programs, and MySQL, which is wonderful when it works, is absolutely the worst in the obscure and poorly documented steps that take you from the code to an installation that works. At least that is the case with OS 10. On 12/2/16, 5:42 PM, "Peter Brawley" wrote: On 12/2/2016 16:59, Martin Mueller wrote: > I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at https://urldefense.proofpoint.com/v2/url?u=http-3A__community.jaspersoft.com_wiki_uninstall-2Dmysql-2Dmac-2Dos-2Dx&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=LP2YLfUL67Gr-H-dkv9ZuW5LDsLMTL-M7m7g50wBPu4&s=sqlfF8DCjesZOKwqOhB8bmyF0bkpvNWHU8cXz-amxg4&e= , and installation progresses smoothly and terminates successfully. Bu the attempt to start the server produces the error message : > ERROR! MySQL server PID file could not be found! Is https://urldefense.proofpoint.com/v2/url?u=http-3A__stackoverflow.com_questions_861_pid-2Derror-2Don-2Dmysql-2Dserver-2Dstart&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=LP2YLfUL67Gr-H-dkv9ZuW5LDsLMTL-M7m7g50wBPu4&s=M2Yd8vqNwYiRfeLsjhV2Ut_dG-pxlDiy5d-eEx1rubQ&e= helpful? PB -
a curse on OS sierra and MySQL?
I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at http://community.jaspersoft.com/wiki/uninstall-mysql-mac-os-x, and installation progresses smoothly and terminates successfully. Bu the attempt to start the server produces the error message : ERROR! MySQL server PID file could not be found! I have tried this and that, looking at advice on the Web, which is plentiful but not always. Nothing works. I have installed Postgresql, about which I know very little. But the installation proceeded smoothly, and turning the server on and off works like a charm. Is it a reasonable conclusion that MySQl and OS 10 just don’t like each other very much and that a prudent man is better off with some other database? The MySQL documentation is not very helpful in the sense that following it doesn’t produce good results.
Re: MySQL Platform Migration
Not very helpful rhetoric on either side of the fence. Every time an unnecessary comment is made, some time cost is imposed on the folks who make the mistake of opening the email thinking there was some useful advice. Civilization and good manners consist very largely of bitten tongues. And biting your tongue might be a good thing for others MM Martin Mueller Professor emeritus of English and Classics Northwestern University On 9/11/16 12:27 PM, "Ryan Coleman" wrote: >Because they want to be belittled by european jackasses online. > >On Sep 10, 2016, at 11:56 PM, Reindl Harald >wrote: >> >> >> Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: >>> Is the mysql datafile compatible with different operation system ? I >>>have not done this in the past. >> >> why shouldn't it when the identical software is running? >> it's just a bunch of files used by mysql >> >> as said copy it to the new machine and you are done - why do people >>these days not just try out things, look if it works and when it don't >>asking questions? >> >>> - Original Message - >>> From: Reindl Harald >>> To: mysql@lists.mysql.com >>> Sent: Saturday, September 10, 2016 7:19 PM >>> Subject: Re: MySQL Platform Migration >>> >>> Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal: >>>> Is there any documentation for migrating mysql 5.0 database from >>>>darwin to Linux >>> >>> what do you need to migrate? >>> >>> shutdown mysqld, copy the datadir to the new machine, start mysqld with >>> adopted configuration on the new machine - done >>> >>> P.S: >>> don't cross-post on mysql and mariadb list >> >> -- >> MySQL General Mailing List >> For list archives: >>https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql >>&d=CwIFAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz >>4x1GLlmLOW60xyVXydxwnJZpkxbk&m=cQyy1LyUdO1_o4_3K62-IxYpnXPNhcErgHZ2NXXmnT >>c&s=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow&e= >> To unsubscribe: >>https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql >>&d=CwIFAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz >>4x1GLlmLOW60xyVXydxwnJZpkxbk&m=cQyy1LyUdO1_o4_3K62-IxYpnXPNhcErgHZ2NXXmnT >>c&s=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow&e= >> > > >-- >MySQL General Mailing List >For list archives: >https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql&; >d=CwIFAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x >1GLlmLOW60xyVXydxwnJZpkxbk&m=cQyy1LyUdO1_o4_3K62-IxYpnXPNhcErgHZ2NXXmnTc&s >=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow&e= >To unsubscribe: >https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql&; >d=CwIFAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x >1GLlmLOW60xyVXydxwnJZpkxbk&m=cQyy1LyUdO1_o4_3K62-IxYpnXPNhcErgHZ2NXXmnTc&s >=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow&e= > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
... ERROR! The server quit without updating PID file
I ran into the problem referred to in the subject line. It seems to be fairly common, to judge from stuff on the Internet, but none of the explanations or solutions offered there were of any help to me. I run MySql 5.22 on a Mac desktop with El Capitan, but the MySQL installation is inherited from an earlier version of OS X. I stopped the server from the MySQL icon in the System Preferences panel, because I wanted to perform a proper binary backup and Dubois’ book said to stop the server especially if you are using INNO tables. When I restarted it with the restart seemed to work for a while but then aborted with the message “... ERROR! The server quit without updating PID file” As I understand it, the start and stop operations for MySQL server on the Mac changed between Yosemite and El Capitan. So it seems plausible to me that the server shut down according to one protocol and the way in which it shut down prevents it now from starting. I turned the computer on and off many times and the MySQL always automatically restarted, but I don’t remember ever stopping it from the MySQL icon in the Mac’s System preferences, and I suspect that using it was the cause of the malfunction. What can I do? One voice on the Internet suggested simply replacing the installation altogether, keeping the data directory and then updating the new data directory with the old one. If I read Paul Dubois’ MySQL manual correctly that should be OK. Because I made what he calls a “binary backup” and all my files are MyISAM or InnoDb and should be machine or version independent. I hesitate because on a previous occasion an older version of MySQL was extraordinarily difficult to get rid of and the machine in later installations seemed to remember a password that I had forgotten. In this case, I know the passwords. So, is the best thing to do 1) Move the data directory out of the current instllation 2) Get rid of the current installation 3) Replace the data directory of the new instllation with the old data directory Or are there problems and unknown dependencies in that approach? Martin Mueller Professor emeritus of English and Classics Northwestern University
Re: parallel installations of mysql
Thanks. That’s helpful and makes me think that there may be a “Mac hole” in the MySQL documentation. Windows is one thing and Linux another. OS X is sort of Unix, but only sort of, and the conventions are not as firmly established. For instance, the instructions for the MySQl Sandbox—on the face of it a useful utility—are much more Linux specific than the author tells you. Making them work on a Mac might be easy for someone who knows a lot about Linux. But if you don’t, as I don’t, you’re stuck It would actually be terrific if MySql 5.7 by default installed itself as a neighbor without encroaching on the 5.6 that is already there, like oXygen. It would be equally terrific if it just superseded 5.6, but let you get on with your work. But it doesn’t do one or the other. It will overwrite without replacing, and you have to take a lot of very careful steps to make sure that things don’t get in each other’s way. The documentation for that, especially on the Mac side, is not good. If port 3306 is taken, how is one supposed to know that 3307 is a good alternative? Why not 3317 or 3703. The MySQL documentation here is plagued by what Steven Pinker in a recent book on writing called the “curse of ignorance,” the fact that one neither knows nor cares about what the other person doesn’t know. On 7/2/16, 9:11 PM, "Hal.sz S.ndor" wrote: 2016/07/02 18:49 ... Martin Mueller: > It’s clear from Section 6.6 of the Reference manual that I need to make sure > that the new installation differs from the old one with regard to the data > directory, the port number, the socket, the shared memory-base-name, and the > pid-file. > > It’s less clear to me where to change these setting. In the .dmg version of a > Mac version, you can’t make any choices. I don’t know whether it’s a bug or a > feature, but the button for customizing an installation doesn’t work. > > So the other option is the .tar file. There are a lot of files in that > directory, but no file that draws attention to itself as the file where you > make these changes. > > Some of the instructions are obscure to folks like me. What is a good port > number? Will anything do, or is there a list somewhere? What do I call an > alternate pid file? Since I use Windows and not Mac, not all my experience is relevant, but there is a file, that for wIndows is called "my.ini" but the original name is "my.cnf", which is full of stuff. For a while I ran both 5.5 and 5.6, with port 3306 for the former and 3307 for the latter. There is on this machine a top-level directory "ProgramData", and the version-5.6 files are under "\ProgramData\MySQL\MySQL Server 5.6" (yuck, backslash). I imagine for version 5.7 there is to be "\ProgramData\MySQL\MySQL Server 5.7". This directory is named in "my.ini". The PID file is under this directory. Maybe some of this maps onto the Mac version. (Iself have begun to use SQLite for some purposes.) -- MySQL General Mailing List For list archives: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql&d=CwID-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=BLzHSJhRl4rLPDJAWZ1n77yXtR7Lqg1Y8QC5CQp7BJo&s=vGlmKmD1QtPMLr9EqCWQyn1arUfs2LuZXkmqj_U5aCU&e= To unsubscribe: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql&d=CwID-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=BLzHSJhRl4rLPDJAWZ1n77yXtR7Lqg1Y8QC5CQp7BJo&s=vGlmKmD1QtPMLr9EqCWQyn1arUfs2LuZXkmqj_U5aCU&e=
Re: parallel installations of mysql
Dear Mr. Green, After struggling for several hours with installing an alternate installation of MySQL, I’ve concluded that this may be beyond my feeble powers but also that the official instructions are not very good. They are written for system administrators who are doing work of this kind all the time. I’m a scholar who has a reasonably firm command of SQL code but doesn’t work much at the command line. So you could say “tough luck” or you could try to be a little more explicit in the official instructions. I work with a Mac, and as far as I can tell there isn’t much love lost between Apple and Oracle. And proper Linux users may think of Mac users as wimps. Which they may be. But they still want to use relational databases. It’s clear from Section 6.6 of the Reference manual that I need to make sure that the new installation differs from the old one with regard to the data directory, the port number, the socket, the shared memory-base-name, and the pid-file. It’s less clear to me where to change these setting. In the .dmg version of a Mac version, you can’t make any choices. I don’t know whether it’s a bug or a feature, but the button for customizing an installation doesn’t work. So the other option is the .tar file. There are a lot of files in that directory, but no file that draws attention to itself as the file where you make these changes. Some of the instructions are obscure to folks like me. What is a good port number? Will anything do, or is there a list somewhere? What do I call an alternate pid file? In documentation that would be friendlier, there might be a side-by side scenario, showing the values for the first installation, and possible alternate values for a second installation. And it would help to remind the user, who is not a systems administrator dealing with this stuff every day, where you find the relevant configuration files. It’s an odd feature of MySQL that it doesn’t seem to have an initial configuration file in the tar version of the program. So the question where to go in the first place is not obvious. Having failed to get it right, I tried a MySQL sandbox program that promised to do all this without trouble. Alas, it didn’t work on the Mac at all. Perhaps I should use SQLite, where you don’t have to worry about any of this stuff. On the other hand , MySQL has very elegant and logically organized functions, and it’s a joy to work with once you have it actually installed an running. I’ll be grateful for any help. Martin Mueller Professor emeritus of English and Classics Northwestern University On 4/21/16, 5:42 PM, "shawn l.green" wrote: On 4/20/2016 2:04 PM, Martin Mueller wrote: > > I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to > install 5.7.12. Can I install it as a parallel and independent instance? And > if so, are there special problems to watch out for? > > > > > > Why would I want to do this? Well, I have a set of databases and tables on > the old installations that have grown over the years. Given the way I work, > the simplest thing would be install the new database and then work through my > existing tables over a number of weeks and transfer stuff as I go along. > That may not be very professional but it works for me, and it would let me > keep the old along the new, just in case something goes wrong/ > > My friends tell me to use sqlite, and they are probably right since file > management is so much simpler. But I find the many builtin functions of MySQL > very helpful and don't particularly want to learn a new set. > > Martin Mueller > Many systems have more than one mysqld running on them at the same time. To make them operate safely, you have to isolate them from each other using the guidance in this section of the manual: http://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Integrated Cloud Applications & Platform Services Office: Blountville, TN Become certified in MySQL! Visit https://www.mysql.com/certification/ for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
corrupt INNO table
I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it does not respond to queries, and the command to drop it does not execute. The database seems to be OK in other respects. What can I do to get rid of the table? Would it be safe just to remove the two .frm and .ibd files from the database directory or is there other stuff that I need to worry about. Thanks in advance for any help.
utf8 options under Mysql
MySQL has a bewildering variety of unicode collation choices. Most of them are language specific, but what is the difference between "utf8-general-ci", "utf8-unicode-ci", and "utf8-unicode-520-ci." Do they differ in the range of characters they can handle or is it just a matter of the cort order. I understand that utf8-bin is different because it is case sensitive, but the other differences elude me. Under what circumstances does it make a difference to use on or the other? I work with a lot of Early Modern print data and the weird symbols of various kinds they use. I've had trouble at times with the "utf8-general-ci" setting, but it may have been more a matter of settings on my front end tool than of the choice of this rather than unicode collation. Under character sets, there is just one utf8 setting. The simplest way to make sense of the choices would be to say that given a character set (utf8) the collation only makes a difference to the sort but makes no difference to what can be displayed. Is that correct.
parallel installations of mysql
I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to install 5.7.12. Can I install it as a parallel and independent instance? And if so, are there special problems to watch out for? Why would I want to do this? Well, I have a set of databases and tables on the old installations that have grown over the years. Given the way I work, the simplest thing would be install the new database and then work through my existing tables over a number of weeks and transfer stuff as I go along. That may not be very professional but it works for me, and it would let me keep the old along the new, just in case something goes wrong/ My friends tell me to use sqlite, and they are probably right since file management is so much simpler. But I find the many builtin functions of MySQL very helpful and don't particularly want to learn a new set. Martin Mueller -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
moving inno tables
I moved the data directory of a MySQL installation from one computer to another. This works for MyISAM tables. Unfortunately I inadvertently created some INNO tables, and it doesn't seem to work. The show tables command accurately lists the following the tables from a longer list pospairs | | purchas4 | The ls -l command for the directory /usr/local/mysql/data/tcpcurrent shows what I take to be all the required files for these two tables: -rw-r- 1 _mysql wheel 66152 Jul 28 15:53 pospairs.MYD -rw-r- 1 _mysql wheel 45056 Jul 28 15:53 pospairs.MYI -rw-r- 1 _mysql wheel8664 Jul 28 15:53 pospairs.frm -rw-r- 1 _mysql wheel 13792 Jul 28 15:53 purchas4.frm -rw-r- 1 _mysql wheel 385875968 Jul 28 15:54 purchas4.ibd The permissions are identical, and the file sizes seem appropriate. But the first ISAM file responds while for the INNO file the command mysql> select spelling from purchas4 where spelling like 'z%'; produces the response: ERROR 1146 (42S02): Table 'tcpcurrent.purchas4' doesn't exist I ran a mysql check routine on this, and it appears that all of the INNO tables are identified as not existing, although it is there on the hard drive with substantial byte counts. Is there something I can do about this or is it an intrinsic problem to moving INNO tables? Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
pid-file quite
Dear Mr. Green, first I'd like to thank you for your very clear explanations, which helped. 'mysql' is an overdetermined word with all the advantages and disadvantages of that. While finally getting into the door, I ran into another problem: "pid-file quit without updating." This seems to be a fairly common phenomenon, to judge from offered help on the Web. But the explanations are all over the map, and the help is of dubious value. I've run into this problem several times. One piece of advice was to use ps ax|grep mysql and then kill the processes with the number returned by the query. That worked on one occasion, but on another occasion it didn't. On that occasion, though, if I logged in as superuser and started the server it worked. There doesn't seem to be anything about this problem in the mysql documentation. I not that it seems to be a fairly common kind of error, with no clearly diagnosis or therapy from a source that can speak with much authority. It may be Mac specific and has to do with Startup items that you're not supposed to use anymore and launcher daemons that are not easily understood by poor mortals by me. But OS X is a very popular operating system and MySQL is a very popular database. So I don't quite understand why very basic installation and operating procedures are so complicated. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 8:40 AM, "shawn l.green" wrote: > > >On 7/31/2015 8:40 AM, Martin Mueller wrote: >> Sorry for the off-list reply. It was an oversight. >> >> That said, the instructions for resetting a forgotten root password >>have a >> section for Windows and a section for Unix. The Unix section begins as >> follows: >> >> >> 1. Log on to your system as the Unix user that the MySQL server runs as >> (for example, mysql). >> > >Everything that executes on a Linux/Unix/Mac machine executes in the >context of some kind of user account (the system login). By default, >mysqld (the database server daemon) is installed to run under the host >machine user account 'mysql'. It can be changed if you want to change it >but that is the default. That is why 'mysql' was listed in the "for >example" section of that instruction. > > >> But if I do this with the command 'mysql -u mysql I get the answer >> > >No. That is how you log into mysqld to open a MySQL client session. The >instruction was to login to your operating system as the user that >mysqld operates as. These are fundamentally different accounts at two >very different levels. > > > >> Access denied for user 'mysql'@'localhost' (using password: NO) >> >> I can do this as super user or normal, and I can try passwords from >> earlier installations, but none of them work. So I am stopped dead in my >> tracks, am I not? >> > >That is because you didn't add this line to the [mysqld] section of your >configuration file before you started mysqld. > >skip-grant-tables > >If you had, you would not have needed to use any passwords at all. This >command (on the system prompt) would be all you need to connect to your >now completely-unlocked database server (see the third section of >generic instructions that work on any platform). > >mysql > > >> As for the datadir, the command "update db locate mysql" works on the >>Mac >> and gives me info about a whole set of files in >> /usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, >>and >> I deleted a previous installation because I had moved the data I needed >>to >> another machine. >> >> I'm not a very experienced programmer and have trouble wrestling with >>the >> command line. But I think I did my due diligence and didn't find any >>open >> doors. >> > >The door is there, you just just need to be able to see it as a door. >Just a little more experience working on the command line will help. >... remainder snipped ... > >-- >Shawn Green >MySQL Senior Principal Technical Support Engineer >Oracle USA, Inc. - Integrated Cloud Applications & Platform Services >Office: Blountville, TN > >Become certified in MySQL! Visit https://www.mysql.com/certification/ >for details. > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: password problem
Dear Mr Harald, I've learned some things from your responses and even more from shawn green's. You might learn a lot from him about patience and courtesy, which make life on a technical forum a lot easier. You clearly know a lot about technical stuff, but you're short on patience, and it would help you a lot to practice a little courtesy and refrain from vulgar language. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 9:12 AM, "Reindl Harald" wrote: > > >Am 31.07.2015 um 15:40 schrieb shawn l.green: >>> 1. Log on to your system as the Unix user that the MySQL server runs as >>> (for example, mysql). >> >> Everything that executes on a Linux/Unix/Mac machine executes in the >> context of some kind of user account (the system login). By default, >> mysqld (the database server daemon) is installed to run under the host >> machine user account 'mysql'. It can be changed if you want to change it >> but that is the default. That is why 'mysql' was listed in the "for >> example" section of that instruction > >but this part of the docs is completly bullshit > >a) on no sane system the user "mysql" has a password, hence >no login possible and typically it has also no shell >configured > >b) for what reason "mysql -u root" and you are done with >skip-grant-tables (and skip-grant-tables is the only >relevant point) > >why in the world should i need to logon as the user mysqld runs for >connect to mysqld? but anyways, "mysql -u mysql" would have worked also >as well as "mysql -u bullshit" because skip-grant-tables does what it >says, you can do anything you like to do > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: password problem
Data directory path mention in cnf is of old mysql. Make a fresh data directory, configure it in configuration file and execute mysqlinstall_db, I don't understand the sentence about the data directory path mention. The my.cnf file is at /etc/my.cnf . It doesn't have any data directory path mention, but neither does the my.cnf file on a laptop, which works. So there seems to be nothing wrong with the location or content of the my.cnf file. On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller mailto:martinmuel...@northwestern.edu>> wrote: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same. Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks and Regards: Nikhil Anand +91 9650024197
Re: password problem
Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). But if I do this with the command 'mysql -u mysql I get the answer Access denied for user 'mysql'@'localhost' (using password: NO) I can do this as super user or normal, and I can try passwords from earlier installations, but none of them work. So I am stopped dead in my tracks, am I not? As for the datadir, the command "update db locate mysql" works on the Mac and gives me info about a whole set of files in /usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, and I deleted a previous installation because I had moved the data I needed to another machine. I'm not a very experienced programmer and have trouble wrestling with the command line. But I think I did my due diligence and didn't find any open doors. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 3:36 AM, "Reindl Harald" wrote: >first: don't reply off-list, a answer on a mailing-list is no invitation >for private support! > >Am 31.07.2015 um 02:34 schrieb Martin Mueller: >> I read that section but was stopped in my tracks by >> >> "Log on to your system as the Unix user that the MySQL server runs as >> (for example, mysql)" >> >> Because I have no password for ANY thing. > >read the f**ng >https://dev.mysql.com/doc/refman5.0/en/resetting-permissions.html ><https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html> - >unbelievebale that users these days need anything ready chewed and are >too lazy to click on a link and read more than 5 lines > >Resetting the Root Password: Generic Instructions >Stop the MySQL server if necessary, then restart it with the >--skip-grant-tables option > >> I used the uninstall routine recommended by Rob Allen, in which you >>remove >> the directories /usr/local/mysql as well as /usr/local/mysql* and a lot >>of >> other library and etc files. So there is no trace of the old system on >>my >> machine. How come a routine installation of mysql then locks up the >> application. > >the datadir is *not* removed by any sane installer, dunno where it lives >on Apple machines since i banned them 5 years ago for good reasons > >on a non-OSX i would just type "updatedb; locate mysql" als root > >> On 7/30/15, 19:22, "Reindl Harald" wrote: >>> >>> Am 31.07.2015 um 01:41 schrieb Martin Mueller: >>>> I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I >>>> cannot >>>> run the mysql command because it challenges me for a password. But I >>>>did >>>> not set any password, either for the root, for mysql, or for myself >>>>as a >>>> user. >>>> >>>> So the installation has somehow installed passwords about which I know >>>> nothing or there is some error in the installation process. >>>> >>>> There is a lot on the Web about resetting a forgotten password. But >>>>the >>>> assumption is always that you can get at the program via some other >>>> password. But in this case every door is shut. >>>> >>>> Does anybody recognize this problem? I've uninstalled and re-installed >>>> the >>>> program, but the results are always the same >>> >>> * install and uninstall *never* removes the datadir >>> * users and permissions are in the DB "mysql" >>> * https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
password problem
I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same. Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
installation problem of MySQL on OS Lion
I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generated the following error message: Martin-Muellers-Mac-Pro:~ martin$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ... ERROR! Manager of pid-file quit without updating file. I'll be grateful for any help Martin Mueller Professor emeritus of English and Classics Northwestern University
Re: create_time
So, if you want to have a permanent record of when a table was created‹never mind subsequent adjustments, you should personally enter the data as a table comment? On 5/4/15, 9:13 AM, "Johan De Meersman" wrote: >...sigh. > >That sounds logical. I have, however, also had Martin's experience where >create_time seemed improbable; and the structure is unlikely to have >changed without my knowledge as user accounts don't have DML privileges. > >I didn't pay any further attention to it, though, as it wasn't important >to me at the time. I'll be monitoring this thread with interest :-) > > >- Original Message - >> From: "Johan De Meersman" >> To: "Pothanaboyina Trimurthy" >> Cc: "Martin Mueller" , "MySql" >> >> Sent: Monday, 4 May, 2015 16:11:24 >> Subject: Re: create_time > >> That sounds logical. I have, however, also had Martin's experience where >> create_time seemed improbable; > >-- >Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: create_time
That’s not quite an answer to the question I asked. Does “create_time” represent the date at which a table was created, and does that date change or stay the same if there is an update on the table or columns are removed or added? I had an experience where a table that I knew to be several months all of a sudden showed a create_time that was more or less identical with the last update of the table. Which surprised me. From: Pothanaboyina Trimurthy mailto:skd.trimur...@gmail.com>> Date: Friday, May 1, 2015 at 12:15 AM To: Martin Mueller mailto:martinmuel...@northwestern.edu>> Cc: "mysql@lists.mysql.com<mailto:mysql@lists.mysql.com>" mailto:mysql@lists.mysql.com>> Subject: Re: create_time Hi Martin, which table are you looking at from information_schema? TABLES table should give you the correct information based on CREATE_TIME column, also if you check for show table status like 'table_name'; gives you the right information. On Fri, May 1, 2015 at 3:12 AM, Martin Mueller mailto:martinmuel...@northwestern.edu>> wrote: I had thought that MySQL remembers the date when a table is first created and stores it in the create_time column of Information Schema. But this doesn¹t seem to be the case.On my machine it seems to record the date of most recent access. Which seems odd. Am I doing something wrong? Is there a way of finding the date when a table was first created? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks, Trimurthy P Mobile : +91 97397 64298 http://mysqlinternals.blogspot.in/ https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b
create_time
I had thought that MySQL remembers the date when a table is first created and stores it in the create_time column of Information Schema. But this doesn¹t seem to be the case.On my machine it seems to record the date of most recent access. Which seems odd. Am I doing something wrong? Is there a way of finding the date when a table was first created? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
time stamp specific to columns
I understand how a timestamp column automatically changes when there is a change in a data row. Is it possible to limit the update to changes in particular columns? I have a table where I care about changes in any of four different columns, but I don¹t care about changes in other columns or added columns. Is there a command that says ³update the time stamp if and only if there is a change in columns a, b,c, or d" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Users and Groups
> Date: Wed, 4 Mar 2015 14:04:55 +0100 > From: vegiv...@tuxera.be > To: lu...@lambrate.inaf.it > CC: mysql@lists.mysql.com > Subject: Re: Users and Groups > > > That reminds me, this may be of interest: > http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/ MG>très bon johann ! > - Original Message - > > From: "Lucio Chiappetti" > > To: "MySql" > > Sent: Wednesday, 4 March, 2015 12:39:01 > > Subject: Re: Users and Groups > > > When several years ago a colleague here set up the user interface for an > > astronomical database (originally using servlets now with Tomcat, and > > anyhow accessing mysql in JDBC) he considered the internal mysql privilege > > system, and for some reasons decided not to use it. > > > > He wrote an additional layer inside our java front end. We have > > "workspaces", each workspace can access a number of advertised tables, and > > view advertised columns (but other columns remain accessible if called by > > name). Users belong to one (or more workspaces) and specify it when > > logging in our system. All workspaces have readonly access (we do not > > consider user-writable tables). Our java engine communicates with mysql > > as a single user. > > > > This way we do not have to care about granting access to the mysql server > > to external hosts. > > > > Anyhow I presume that playing around with the grants and privileges > > tables, one could find a way to write a template set of privileges for a > > "typical user" and replicate it for all users of same "logical group" > > > > > > > > -- > > > > Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) > > For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html > > > > Do not like Firefox >=29 ? Get Pale Moon ! http://www.palemoon.org > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/mysql > > -- > Unhappiness is discouraged and will be corrected with kitten pictures. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: How to retrieve next record?
If you *dont* mind implementing your fetch in PHP: Get ALL of the records into a resultset then fetch each record one a time from the resultset e.g. if($con != null) { //start $con!=null $res = mysqli_query($con, "SELECT *FROM Table"); //we have all records in $res if ($res != null) { //check to make sure resultset != null $rowcount = 0; $row=mysqli_fetch_array($res,MYSQLI_ASSOC); //get the first record from the resultset $res while($rowcount < $res->num_rows) { // start while $row = mysqli_fetch_array($res); //get the NEXT record from the resultset $res $rowcount = $rowcount + 1; } } //end res!=null } //end $con!=null Martin Gainty > Date: Thu, 11 Dec 2014 14:07:33 -0800 > Subject: Re: How to retrieve next record? > From: mussa...@csz.com > To: larry.mart...@gmail.com > CC: mysql@lists.mysql.com > > On Thu, December 11, 2014 13:43, Larry Martell wrote: > > On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote: > >> Hi all, > >> > >> It seems like a simple question, however I'm not able to find the > >> answer. > >> > >> Let me explain. I have a DB with lots of columns, one is labeled as > >> 'kenteken' and it is also the primary key in the DB. I poke into this DB > >> with the command > >> > >> $sDBQuery1 = "SELECT * FROM kentekenlogtest WHERE kenteken = > >> '$sActueelkenteken'"; > >> > >> This is ok and gives me the correct result. However, then I want the > >> next > >> row (according to the primary key), but with what command? > >> > >> That's were I'm stuck. > >> > >> Didn't find anything like NEXT, so... what to look for? > > > > > > What do you mean by 'next' row? Since you're querying by primary key > > you will only get one row, right? > > > Related what is the form of the prmary key. If its numeric something like > $sDBQuery1 = "SELECT * FROM kentekenlogtest WHERE kenteken < > '$sActueelkenteken' limit 1" > might work. > > -- > William R. Mussatto > Systems Engineer > http://www.csz.com > 909-920-9154 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
update and control flow
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be very useful for update operations, but I can't get it right. If I read the documentation correctly, it should be possible to say something like UPDATE X if WORD like 'a%' SET COMMENT = 'a' elseif WORD like 'b%' SET COMMENT = 'b' END IF But this gives me an error message. What am I doing wrong? MM Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: unicode case insensitive but diacritics sensitive
Thanks for that answer. It squares with my solution: have an additional column that has the lower case values of the case sensitive unicode setting. Martin Mueller Professor emeritus of English and Classics Northwestern University On 11/25/14 6:48 AM, "Rik" wrote: >Not a unicode one that I know of, converting it to latin1 for the grouping >works for that particular use case, but I can't make any promises how it'd >work on your entire set which may hold any unicode character, a lot of >which cannot be converted to latin1: > >mysql> SET NAMES utf8; >Query OK, 0 rows affected (0.00 sec) > >mysql> CREATE TABLE test ( foo VARCHAR(3)) ENGINE=InnoDB COLLATE=utf8_bin; >Query OK, 0 rows affected (0.14 sec) > >mysql> SELECT GROUP_CONCAT(foo) FROM test GROUP BY foo; >Empty set (0.00 sec) > >mysql> INSERT INTO test VALUES ('Ete'),('été'),('ete'); >Query OK, 3 rows affected (0.05 sec) >Records: 3 Duplicates: 0 Warnings: 0 > >mysql> SELECT *, GROUP_CONCAT(foo) FROM test GROUP BY foo; >+---+---+ >| foo | GROUP_CONCAT(foo) | >+---+---+ >| Ete | Ete | >| ete | ete | >| été | été | >+---+---+ >3 rows in set (0.00 sec) > >mysql> SELECT *, GROUP_CONCAT(foo) FROM test GROUP BY foo COLLATE >utf8_general_ci; >+--+---+ >| foo | GROUP_CONCAT(foo) | >+--+---+ >| Ete | Ete,été,ete | >+--+---+ >1 row in set (0.00 sec) > >mysql> SELECT *, GROUP_CONCAT(foo) FROM test GROUP BY CONVERT(foo USING >latin1) COLLATE latin1_general_ci; >+---+---+ >| foo | GROUP_CONCAT(foo) | >+---+---+ >| Ete | Ete,ete | >| été | été | >+---+---+ >2 rows in set (0.00 sec > > >If you entire dataset fits in latin1, creating the table as such might be >the best solution in this case entirely, depending on the environment. >Another option is just to use utf8_bin as collation, but grouping by >LOWER(yourcolumnname), or if that's not enough performance, denormalizing >into an extra lowercase column. > > >On Mon, Nov 24, 2014 at 11:36 PM, Martin Mueller < >martinmuel...@northwestern.edu> wrote: > >> Is there a unicode setting on mysql that is case insensitive but >> diacritics sensitive? Given 'Ete', 'été', 'ete' a group by routine for >> such a setting would return two values: 'été', 'ete'. I couldn't find >> it, but I may not have known where to look. >> >> Martin Mueller >> >> Professor emeritus of English and Classics >> Northwestern University >> >> >> > >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
unicode case insensitive but diacritics sensitive
Is there a unicode setting on mysql that is case insensitive but diacritics sensitive? Given 'Ete', 'été', 'ete' a group by routine for such a setting would return two values: 'été', 'ete'. I couldn't find it, but I may not have known where to look. Martin Mueller Professor emeritus of English and Classics Northwestern University > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
table comments
The TABLES table in MySQL's information_schema has a TABLE_COMMENT column. Could one use that for ad hoc and manual annotation of that table? And if so, could one change its length? Or are there better ways of producing table notes that are kept with the database, as opposed to Evernote or some notebook where you never find it again? Martin Mueller Professor emeritus of English and Classics Northwestern University
RE: Query on some MySQL-internals
Good Afternoon Ajay Im not seeing any giant deltas between the two metrics except i did notice the elapsed time to run the metric on second instance was 3 times slower Any chance we can do pathping from your present location: 1)pathping SQLServerInstance1 2)pathping SQLServerInstance2 to determine if there is an intervening router that is slowing down the second instance? Does anyone have advice to get Ajay to track down why his second instance is non-preformant ? Martin __ > Date: Sun, 7 Sep 2014 23:06:09 +0530 > Subject: Re: Query on some MySQL-internals > From: ajaygargn...@gmail.com > To: mgai...@hotmail.com > CC: mysql@lists.mysql.com > > Hi Martin. > > Thanks for the reply. > > > As I had mentioned, we are running both the instances since last 6 > years or so, and the records are inserted/deleted on both the > instances. > > So, we did a "show table status like 'XX' \G;" on both the > instances, and following are the outputs (here "XX" is the table > upon which the OPTIMIZE command was run). > > Also note that the outputs are after the OPTIMIZE command had been run > on the respective instance-tables :: > > > 1) > Instance 1, which showed massive improvement in INSERT query > completion times after OPTIMIZE command was run on table XX:: > > db1>show table status like 'XX' \G; > *** 1. row *** > Name: XX > Engine: InnoDB > Version: 10 > Row_format: Compact > Rows: 12380147 > Avg_row_length: 473 > Data_length: 5865701376 > Max_data_length: 0 > Index_length: 522043392 > Data_free: 91226112 > Auto_increment: NULL > Create_time: NULL > Update_time: NULL > Check_time: NULL > Collation: latin1_swedish_ci > Checksum: NULL > Create_options: partitioned > Comment: > 1 row in set (0.08 sec) > > > 2) > Instance 2, which showed no improvement in INSERT query completion > times, after running OPTIMIZE command on table XX :: > > > db2>show table status like 'XX' \G; > *** 1. row *** > Name: XX > Engine: InnoDB > Version: 10 > Row_format: Compact > Rows: 13189570 > Avg_row_length: 407 > Data_length: 5376540672 > Max_data_length: 0 > Index_length: 518553600 > Data_free: 36700160 > Auto_increment: NULL > Create_time: NULL > Update_time: NULL > Check_time: NULL > Collation: latin1_swedish_ci > Checksum: NULL > Create_options: partitioned > Comment: > 1 row in set (0.24 sec) > > > > Thanks and Regards, > Ajay > > On Sat, Sep 6, 2014 at 8:06 PM, Martin Gainty wrote: > > > > > > > > > >> Date: Sat, 6 Sep 2014 14:26:22 +0530 > >> Subject: Query on some MySQL-internals > >> From: ajaygargn...@gmail.com > >> To: mysql@lists.mysql.com > >> > >> Hi all. > >> > >> > >> We are facing a very strange scenario. > >> > >> We have two mysql-instances running on the same machine, and they had > >> been running functionally fine since about 6 years or so (catering to > >> millions of records per day). > >> > >> However, since last few days, we were experiencing some elongated > >> slowness on both the instances. > >> So, we decided to "OPTIMIZE TABLE slow_table" on both the instances. > >> > >> We first ran the command on one instance. > >> That speeded up things massively (select count(*) that was earlier > >> taking 45 minutes was now running in less than 3 minutes). > >> > >> > >> We then ran the command on the second instance. However, that seemed > >> to have no effect. > >> We ran the command again (on the same instance); again it had no effect. > >> > >> > >> > >> What could be the reason of this strange behavior? > >> Both the instances run under fairly the same load > > MG>How do you extract the metrics to determine what the second instance is > > handling the same load as first instance? > > MG>vmstat? > > MG>iostat? > > MG>SHOW GLOBAL STATUS ? > > > >> and both instances > >> are mounted on the same partition (obviously, all the directories are > >> different). > >> > >> > >> Hoping for some light on this strange issue. > >> > >> > >> > >> Thanks and Regards, > >> Ajay > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: http://lists.mysql.com/mysql > >> > > > > -- > Regards, > Ajay > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql >
RE: Query on some MySQL-internals
> Date: Sat, 6 Sep 2014 14:26:22 +0530 > Subject: Query on some MySQL-internals > From: ajaygargn...@gmail.com > To: mysql@lists.mysql.com > > Hi all. > > > We are facing a very strange scenario. > > We have two mysql-instances running on the same machine, and they had > been running functionally fine since about 6 years or so (catering to > millions of records per day). > > However, since last few days, we were experiencing some elongated > slowness on both the instances. > So, we decided to "OPTIMIZE TABLE slow_table" on both the instances. > > We first ran the command on one instance. > That speeded up things massively (select count(*) that was earlier > taking 45 minutes was now running in less than 3 minutes). > > > We then ran the command on the second instance. However, that seemed > to have no effect. > We ran the command again (on the same instance); again it had no effect. > > > > What could be the reason of this strange behavior? > Both the instances run under fairly the same loadMG>How do you extract the > metrics to determine what the second instance is handling the same load as > first instance? MG>vmstat?MG>iostat? MG>SHOW GLOBAL STATUS ? > and both instances > are mounted on the same partition (obviously, all the directories are > different). > > > Hoping for some light on this strange issue. > > > > Thanks and Regards, > Ajay > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: database developer tool "Database Workbench 5" now available
> From: m.ton...@upscene.com > To: j...@ecoreality.org; mysql@lists.mysql.com > Subject: Re: database developer tool "Database Workbench 5" now available > Date: Fri, 5 Sep 2014 07:57:37 +0200 > > Hello Jan, list, > > >> From: "Martijn Tonies (Upscene Productions)" > >> > >> Database Workbench now comes in multiple editions with different > >> pricing models, there's always a version that suits you! > > > >Unless you don't do Winblows. > > > >Please put Windows dependency clearly in your announcements and on your > >website. I couldn't find it anywhere, until I attempted a download, and got > >a >useless .EXE file. MG>My development is identical ..Development on Windows..Production on Linux MG>When google routes me to Vladimir Putins site for "Official Windows Mysql Stack" you download god knows what MG>solution is to give the customer an in-between solution such as mysqld, mysqladmin and mysql shell scripts that will work under Windows cygwin MG>The Database Workbench version5 MySQL plugin README should detail *a seamless installation* for Windows cygwin MG>if I have to make changes to my.ini or etc/init.d the readme should be specific on what those changes should be MG>Readme should also be specific on how to successfully test mysql ports (presumably 3306)..i assume netstat -a | grep 3306? MG>Thanks > > The announcement said: > > " ... and works fine under Wine on Linux. " > > Several of our customers are long-time Linux users and are very happy with > Database Workbench. > > See also: > http://www.upscene.com/company/support/database_workbench_5_on_wine_ubuntu14 > > Hope this helps. > > > With regards, > > Martijn Tonies > Upscene Productions > http://www.upscene.com > > Download Database Workbench for Oracle, MS SQL Server, Sybase SQL > Anywhere, MySQL, InterBase, NexusDB and Firebird! > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql >
RE: inconsistent optimization
Jim/Jaime What engine are you implementing?/ Qual mecanismo de MySQL que você está implementando? Saludos desde Sud America Martín > Date: Wed, 20 Aug 2014 13:54:46 -0300 > Subject: Re: inconsistent optimization > From: edua...@gerencianet.com.br > To: j...@lowcarbfriends.com > CC: mysql@lists.mysql.com > > Well, > > Try to start checking the IOPs vs Disc. Check your iowait and the cache > size. > > Could you send a "create table" and the query for us? > > > > > > Atenciosamente, > > *Eduardo Fontinelle* > *Chief Technology Officer | G**erencianet* > Phone: +55 (31) 3603-0812 > > > > 2014-08-20 12:04 GMT-03:00 Jim : > > > Without going into specific details on queries... > > > > Using mysql 5.1 as provided with CentOS6, I've noticed some queries > > providing what I can best explain as inconsistent optimization. The > > database can be quieted to just controlled queries and at times the same > > query will return very quickly when at other times may take minutes. > > > > I don't see the same behavior with mysql5.0 under CentOS5. The same > > queries on the same data returns quickly consistently. > > > > When the queries run slowly they show in a process list as either in a > > "copy to temp table" or "sending data" state. At first I thought query > > restructuring to avoid the copy to temp table was a path to a solution, but > > now I don't think so since the same query changed so that it no longer > > needs a temp table will sit in the "sending data" state for a long time. > > > > The queries do eventually come back with correct results, but it takes > > minutes rather than milliseconds (sometimes slow; sometimes fast). > > > > Have others seen this behavior? Any explanations? > > Any reading to point to for further understanding? > > > > Thanks. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/mysql > > > >
RE: Proxy / connected failover question
> CC: vegiv...@tuxera.be; mysql@lists.mysql.com > From: wagnerbianch...@gmail.com > Subject: Re: Proxy / connected failover question > Date: Wed, 9 Jul 2014 08:31:05 -0300 > To: walterh...@olindata.com > > I like HAProxy as well as it simplifies many of the things you seem to be > looking for. > > -- > Wagner Bianchi > Mobile: +55.31.8654.9510 > > > Em 09/07/2014, às 07:48, "Heck, Walter" escreveu: > > > > Johan, > > > > I don't think there's any need for the heavyness (and ugliness ;) ) of > > MySQL Proxy. We're using haproxy for a similar setup (just with galera > > behind it, but that shouldn't really matter. Have a look at this blog post > > that explains most of it: > > http://www.olindata.com/blog/2014/04/managing-percona-xtradb-cluster-puppet#haproxy > > > > cheers, > > > > > > On Wed, Jul 9, 2014 at 12:11 PM, Johan De Meersman > > wrote: > > > >> Hullo peoples, > >> > >> I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck > >> with one shitty application that utterly breaks whenever the database goes > >> away unexpectedly. I can't change the application itself, so I find myself > >> looking for options that allow the heathen contraption to not notice it's > >> connection has switched. MG>how could a proxy server re-route a downed DB connection to another server? MG>does Proxy have a heartbeat on 3306 and reroute somewhere else when 3306 connection goes silent? MG>exactly how does either MySQLProxy or HAProxy handle these detection and reroute scenarios? > >> > >> > >> Thank you for any and all suggestions and information, > >> Johan > >> > >> What's tiny and yellow and very, very dangerous? > >> A canary with the root password. > > > > Best regards, > > > > Walter Heck > > CEO / Founder OlinData <http://olindata.com/?src=wh_gapp> - Open Source > > Training & Consulting > > MG>BR, MG>Martin
RE: mysqlcheck downtime > 30 minutes for Java web application
I would recommend start Here to analyze your tables: http://dev.mysql.com/doc/refman/5.1/en/analyze-table.html Once you have evidence of FTS or unbalanced index entries then optimise http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html Martin Gainty __ Member _ _ _ _ _ ___ _ _ _ _ _ |_ _| |_ ___ | _ |___ ___ ___| |_ ___ | __|___| _| |_ _ _ _ ___ ___ ___ | __|___ _ _ ___ _| |___| |_|_|___ ___ | | | | -_| | | . | .'| _| | -_| |__ | . | _| _| | | | .'| _| -_| | __| . | | | | . | .'| _| | . | | |_| |_|_|___| |__|__| _|__,|___|_|_|___| |_|___|_| |_| |_|__,|_| |___| |__| |___|___|_|_|___|__,|_| |_|___|_|_| |_| > From: tyfan...@uoregon.edu > To: webleh...@gmail.com; mysql@lists.mysql.com > Subject: RE: mysqlcheck downtime > 30 minutes for Java web application > Date: Fri, 13 Jun 2014 00:02:48 + > > I would love to know the answer to this as well. > > I know there are a number of functions of mysqlcheck... > -c to check for corruption.. and ensure nothing needs to be repaired > -o to Optimize, which is kind of like defragmenting, removing deleted rows.. > and this may be the one that is causing the 100% duplication & downtime.. > -r for repair what -c found, or if there was some unanticipated downtime. > > I'm trying to determine what the best practices is with MySQL databases. As > an Oracle DBA, I run stats fairly often for the CBO, but that doesn't look > like the same thing that -o does. > I'm guessing that for a medium-usage database, I'd use -o during a specified > downtime, perhaps accompanying the upgrade, whether it is monthly or > whichever, but run -c more often to check for corruption. > > Does anyone have any documentation or knowledge of best practices, especially > for version 5.6? > > ~ Tyfanie Wineriter ~ > > Database Administrator > University of Oregon > 1212 University of Oregon > Eugene, OR 97402-1212 > (541) 346-1366 > > > -Original Message- > From: Lukas Lehner [mailto:webleh...@gmail.com] > Sent: Wednesday, June 11, 2014 6:38 AM > To: mysql > Subject: mysqlcheck downtime > 30 minutes for Java web application > > Hi > > I read in "MySQL, Fifth Edition" by Paul DuBois that we should do a regular > mysqlcheck. > > We have all InnoDB tables. As far as I unterstand the tables get read and > write locked during mysqlcheck. > > The database will grow 100x in size, at the moment only initial load. > > It means big downtime. > > $ time mysqlcheck --all-databases > [...] > > real29m41.449s > user0m0.019s > sys 0m0.015s > > mysql> SELECT table_schema "Data Base Name", SUM( data_length + > index_length) / 1024 / 1024 > -> "Data Base Size in MB" FROM information_schema.TABLES GROUP BY > table_schema ; > ++--+ > | Data Base Name | Data Base Size in MB | > ++--+ > | imzweffefr | 38420.97170544 | > | information_schema | 0.00781250 | > | mysql | 0.63046169 | > ++--+ > 3 rows in set (5.86 sec) > > You all do mysqlcheck? Is it really mandatory? What's the risk if I don't do > it regularly? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: mysqlcheck downtime > 30 minutes for Java web application
Start Here to analyze your tables Martin Gainty __ _ _ _ _ _ ___ _ _ _ _ _ |_ _| |_ ___ | _ |___ ___ ___| |_ ___ | __|___| _| |_ _ _ _ ___ ___ ___ | __|___ _ _ ___ _| |___| |_|_|___ ___ | | | | -_| | | . | .'| _| | -_| |__ | . | _| _| | | | .'| _| -_| | __| . | | | | . | .'| _| | . | | |_| |_|_|___| |__|__| _|__,|___|_|_|___| |_|___|_| |_| |_|__,|_| |___| |__| |___|___|_|_|___|__,|_| |_|___|_|_| |_| > From: tyfan...@uoregon.edu > To: webleh...@gmail.com; mysql@lists.mysql.com > Subject: RE: mysqlcheck downtime > 30 minutes for Java web application > Date: Fri, 13 Jun 2014 00:02:48 + > > I would love to know the answer to this as well. > > I know there are a number of functions of mysqlcheck... > -c to check for corruption.. and ensure nothing needs to be repaired > -o to Optimize, which is kind of like defragmenting, removing deleted rows.. > and this may be the one that is causing the 100% duplication & downtime.. > -r for repair what -c found, or if there was some unanticipated downtime. > > I'm trying to determine what the best practices is with MySQL databases. As > an Oracle DBA, I run stats fairly often for the CBO, but that doesn't look > like the same thing that -o does. > I'm guessing that for a medium-usage database, I'd use -o during a specified > downtime, perhaps accompanying the upgrade, whether it is monthly or > whichever, but run -c more often to check for corruption. > > Does anyone have any documentation or knowledge of best practices, especially > for version 5.6? > > ~ Tyfanie Wineriter ~ > > Database Administrator > University of Oregon > 1212 University of Oregon > Eugene, OR 97402-1212 > (541) 346-1366 > > > -Original Message- > From: Lukas Lehner [mailto:webleh...@gmail.com] > Sent: Wednesday, June 11, 2014 6:38 AM > To: mysql > Subject: mysqlcheck downtime > 30 minutes for Java web application > > Hi > > I read in "MySQL, Fifth Edition" by Paul DuBois that we should do a regular > mysqlcheck. > > We have all InnoDB tables. As far as I unterstand the tables get read and > write locked during mysqlcheck. > > The database will grow 100x in size, at the moment only initial load. > > It means big downtime. > > $ time mysqlcheck --all-databases > [...] > > real29m41.449s > user0m0.019s > sys 0m0.015s > > mysql> SELECT table_schema "Data Base Name", SUM( data_length + > index_length) / 1024 / 1024 > -> "Data Base Size in MB" FROM information_schema.TABLES GROUP BY > table_schema ; > ++--+ > | Data Base Name | Data Base Size in MB | > ++--+ > | imzweffefr | 38420.97170544 | > | information_schema | 0.00781250 | > | mysql | 0.63046169 | > ++--+ > 3 rows in set (5.86 sec) > > You all do mysqlcheck? Is it really mandatory? What's the risk if I don't do > it regularly? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
Long integer constant problem in views
Hi List I have a table with a primary key with type binary(16) and a few columns. I'd trying to create a view that looks up all rows with a particular key, i.e. something like CREATE OR REPLACE VIEW foo AS SELECT * FROM mytable WHERE id = X'36a461c81cab40169791f49ad65a3728'; I use the mysql command line client to create the view. When I now inspect the view using, say, mysql workbench, the id has been mangled in the where clause which now reads WHERE (`mytable`.`id` = 0x9791f49ad65a37) I then tried expressing the id as something that will fit within 8 bytes WHERE id = X'36a461c81cab4016' << 16 | X'9791f49ad65a3728'; Unfortunately, this makes the query much slower. I have now worked around this in another way, but I'd like to know if there is a way of doing this? Thanks, /Martin Koch
RE: Animation studio asset management
To add to Admiral Nelsons observations As your database grows your options are to either scale up (boost Memory and Disks) or scale out (add more MySQL nodes) If you want to add MySQL additional nodes (without incurring resultant) downtime you may wish to consider MySQL Clustering http://books.google.com/books?id=_3nERYD9xqcC&pg=PA2&lpg=PA2&dq=MYSQL+and+%22Reasons+to+Cluster%22&source=bl&ots=L_i0E9iBZe&sig=ZUqEGux6YLa7lrtfQ_rU5pIOd14&hl=en&sa=X&ei=IVPYUJXbAbDJ0AHiq4H4BA&ved=0CDIQ6AEwAA#v=onepage&q=MYSQL%20and%20%22Reasons%20to%20Cluster%22&f=false Boxing Day is December 26thMartin Gainty __ Please do not alter or otherwise disrupt this transmission. > Date: Sun, 23 Dec 2012 22:39:01 -0800 > Subject: Re: Animation studio asset management > From: chadver...@gmail.com > To: mich...@j3ksolutions.com > CC: mysql@lists.mysql.com > > Thank you for the responses. > > The database would only be accessed internally by about 30-60 users max. > An average show could add anywhere from 5,000-20,000 records over a period > of a few months. We would do maybe 3-4 shows a year. > Maybe a few dozen records would be inserted daily, updates would not be as > common. > About 20-30 users would occasionally be running queries simultaneously, > worst case would be every employee (maybe 50-75) which would be highly > unlikely. > We currently have no dedicated database developers or design experts, > although if we grew to 50-75 we would probably consider hiring one (or two). > There are not really any security requirements as the server is local to > our network and won't contain sensitive information. > > My gut feeling is to go with the simplest solution and use one database, > however since I'm not a database design expert, I want to make sure I'm not > missing anything important. If and when we get over 100k records in a > single table, would we need to worry about performance then? I'm not > really familiar with what the scale of a large database is. If Dan's > statement of millions of rows is correct, then I probably don't need to > consider size as one of our performance considerations as it would take us > quite a long time to get that many entries. Also, many of these records > would be related to older shows and wouldn't be accessed as much. > > Thanks again for your expertise. > > Chad > > > On Sun, Dec 23, 2012 at 9:14 PM, Michael Anderson > wrote: > > > Database performance (like system performance) is always driven by a give > > and take process, a trade-off between resources (this includes design > > expertise) available, and the required results. > > > > How many records are you dealing with? > > How often are records are being added and/or updated? > > How many users will be running queries simultaneously, number of readonly, > > and number of updates and inserts? > > > > If only a handful of users, and less than 100,000 records, that rarely > > change, then you'll probably never have performance problems. > > > > However, it you have 100,000 users running queries simultaneously, and > > changing records regularly, then you may have some issues to address. > > Their are literally hundreds of solutions to performance problems, and the > > right solutions will depend on your particular requirements. > > > > Security, is much the same, dependent on the security requirements. > > Example: > > Security auditors claimed that the marketing product database was not > > secure. > > They said that it needed to be more secure. > > The CEO of the company asked a simple question, he said: > > "Whats the worst that could happen if an outsider gains access to this > > database?" > > Answer: "They might buy one of your products!" > > Lesson learned: Don't waste your time securing data that doesn't need to > > be secured. > > > > So, what are your requirements? > > > > > > > > > > > > On 12/23/2012 09:11 PM, Chad Vernon wrote: > > > >> Hi there, > >> I'm designing an animation studio database to track assets across multiple > >> shows. My original design was to have a "show" table to track which asset > >> belongs to which show with a show_id column. A couple coworkers suggested > >> having a database per show because they are worried about performance and > >> reliability vs a single database as the number of shows grows. I don't > >> think reliability would be different because it's all on the same MySQL > >> server anyways. Is that assumption correct? I've read a few articles > >> about multi-tenant database design, however the motivation for multiple > >> databases seems to be security which doesn't apply to us. Am I correct in > >> trying to push a single database design for this? If it helps, we have no > >> dedicated dba and currently a single mysql server machine. > >> > >> Thanks, > >> Chad > >> > >> > >
RE: call up the sales
We are unable to solve your problem unless you can display 1)all Foreign Key relationships indicating how one Table-column can access Primary key of another table2)It is impossible to aggregate PriceOfBook information thru SUM or any other aggregator function(s) since PriceOfBook column is missing on all your tables Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > From: haidarpes...@gmail.com > Date: Sun, 16 Dec 2012 13:59:36 +0700 > Subject: Re: call up the sales > To: mysql@lists.mysql.com > > I mean table B (sale of books) is TABLE C (sale of book). Sorry. > Sales reports on a monthly basis each publisher. > thanks for the help. > > 2012/12/16 Haidar Pesebe > > > Dear All, > > > > I am asking for help to solve my problem to call the sale of books. > > > > There are 3 tables which each like this: > > > > > > TABLE A (Publisher) > > --- > > ID : NAME : EMAIL : > > --- > > 1 : ABC : abc@abc > > 2 : CDE : cde@cde > > --- > > > > TABLE B (BOOKS TABLE) > > --- > > : IDBOOK : TITLE : PUBLISHER ID : ISBN > > --- > > : 1: TITLE 01: 1 : 001 > > : 2: TITLE 02: 1 : 002 > > : 3: TITLE 03: 2 : 003 > > : 4: TITLE 04: 2 : 004 > > - > > > > TABLE B (SALE OF BOOKS) > > > > > > : ID : ISBN : QTY : DATE : LOCATION > > > > > > : 1: 001: 20 : 2012-12-01 : > > : 2: 001: 11 : 2012-12-01 : > > : 3: 002: 15 : 2012-12-01 : > > : 4: 003: 10 : 2012-12-01 : > > : 5: 003: 7 : 2012-12-01 : > > : 6: 003: 8 : 2012-12-01 : > > : 7: 004: 10 : 2012-12-01 : > > --- > > > > How do I call up the sales in December 2012 for ABC Publisher or call the > > sale in 2012 for ABC publisher? > > > > Thanks and regards, > > Haidarpesebe > >
RE: [Info] Business db
indian spammer please take me off your list *Warm Regards* __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > From: catherine.tho...@emdbase.info > To: mysql@lists.mysql.com > Subject: [Info] Business db > Date: Fri, 5 Oct 2012 08:00:37 -0500 > > Hi, > > As entrepreneurs we are always looking for effective ways to land new > clients. By acquiring new clients, we are able to increase sales, build > credibility and grow our small businesses. There are proven strategies that > work for. Email marketing is indeed an effective and efficient way to market > and sell your products and services. It is best and cheapest way for staying > in touch with the customers and building solid relationship with them. We > Help You Achieve Your Sales Growth Objectives. > > We provide marketing services such as Opt in Email Database, List Building > and Email Campaign. We are specialized in providing Industry Specific Lists > (Healthcare, Chemical, Finance & Banking, IT Solutions, Manufacturing, etc.) > > Please fill in your requirement below and we will revert back to you with > details of the number of email contacts we can provide you. > > Target Industry: _ > > Target Geography: ___ > > Target Job Title: _ > > Apart from List services, we also Conduct Campaign Service. We have a > dedicated team which takes care of the email campaign, who can assist you in > marketing campaign that will automate most of your manual e-Marketing efforts > saving you time and money. We provide you tracking software for campaign so > that you can track the result such as click through, email response, leads > and so on. > > Let me know your thoughts and please keep me posted for any additional > information. If possible, refer me to the right person who makes decision on > prospect lead generation and be a part of our incentive program. > > Warm regards, > Catherine Thomas > Business Development Coordinator > Campaign Division > (302) 409 0513 > > > > Please consider the environment before printing this emailThis e-mail and any > files transmitted with it may contain confidential and or proprietary > information. This e-mail is intended solely for the use of the individual or > entity who is the intended recipient. Therefore, unauthorized use of this > information is prohibited. If you have received this e-mail in error, please > contact the sender by replying to this message and deleting this e-mail and > associated files from any system(s) it may be on. TC:12333PGHY323323 If you > do not wish to receive future emails from us, please reply as 'leave out'
RE: (real) silly question about variables...
in a mySQL statement the values are displayed BEFORE assignments are made Ciao, No MAS __ Per favore non alterare o perturbare la comunicazione > From: urk...@gmail.com > Subject: (real) silly question about variables... > Date: Thu, 4 Oct 2012 15:52:20 +0200 > To: mysql@lists.mysql.com > > Hi > > I know there'd be a reason, but I can't understand that.. > > mysql> select @valore:=rand(), @valore, @valore:="ciao", @valore; > +---+---+-+-+ > | @valore:=rand() | @valore | @valore:="ciao" | @valore | > +---+---+-+-+ > | 0.483624490428366 | 0.483624490428366 | ciao| 0 | > +---+---+-+-+ > 1 row in set (0.00 sec) > > mysql> select @valore:=rand(), @valore, @valore:="ciao", @valore; > +---+---+-+-+ > | @valore:=rand() | @valore | @valore:="ciao" | @valore | > +---+---+-+-+ > | 0.747058809499311 | 0.747058809499311 | ciao| ciao| > +---+---+-+-+ > 1 row in set (0.00 sec) > > why in the first execution the latest value is 0 and not 'ciao'? > and why in the first 2 columns the variables seems works as expected!? > > thank you in advance > > bye > MAS! > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: Mysql cluster installation error
CONTACT the server admin and request access to the MySQL Instance located there Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > Date: Sun, 23 Sep 2012 12:40:17 -0500 > Subject: Re: Mysql cluster installation error > From: aast...@gmail.com > To: mdyk...@gmail.com > CC: mysql@lists.mysql.com > > Thanks! > And how do i connect the cluster from the remote host. > When i try to connect one of the SQL node through remote host it says > access denied. > WHile the same is working fine from local host. > Kindly help. > Thanks! > > On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman wrote: > > > If all you need to transfer is schema, do it the same way you would any > > other table type: use mysqldump with the - - no-data option. > > > > On 2012-09-23 1:29 PM, "Aastha" wrote: > > > > Thanks Nitin. > > I specied the location of my.ini while starting the SQL node and it worked > > fine. > > > > I have anothe rquestion : > > How to connect the cluster and reomte host. And i have to copy a schema > > from one Mysql clsuter to another. How do i do that. > > > > Regards, > > > > > > On Sun, Sep 23, 2012 at 3:13 AM, Nitin Mehta wrote: > > > > > Hi Aastha, > > > > > > I'm not 10... > >
RE: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;
Possibly run your constructed query thru a regex expression e.g. String mydata = "SELECT * from table WHERE a Date: Sun, 23 Sep 2012 18:38:58 -0400 > Subject: Re: How to block SELECT * FROM table; but not SELECT * FROMT table > WHERE...; > From: fuller.art...@gmail.com > To: pownall...@gmail.com > CC: mysql@lists.mysql.com > > Tim, > > I think you misunderstood the question. Daniel wants to block Select > queries that ask for all rwows, and permit only queries that ask for some > rows, as restricted by the Where clause. > > Unfortunately, I don't think that can be done. But I'm not certain of that; > there might be a trick. > > Arthur > www.artfulsoftware.com > > On Sun, Sep 23, 2012 at 3:50 PM, Tim Pownall wrote: > > > select * from table where column=value means it will return only rows that > > match. as long as you have proper indexing there should not be any issues. > > > > On Sun, Sep 23, 2012 at 1:23 PM, Luis Daniel Lucio Quiroz < > > luis.daniel.lu...@gmail.com> wrote: > > > >
RE: Machine Learning
we'll need a user-friendly architecture diagram with a hopefully one to one mapping to DBSchema Table Elements..(run the napkin thru a scanner and publish it) once the Table Elements are defined then we'll need to populate Tables with columns..determine Primary Keys with Foreign keys..get the relationships defined and written down then create the database ..once the DB is up and running in an accesible location with sftp or scp running so we can import.. publish the JDBC connection string Martin __ ..place long winded disclaimer here.. > From: webmas...@lisol.co.uk > To: garotconk...@yahoo.com; mgai...@hotmail.com; ag4ve...@gmail.com > CC: mysql@lists.mysql.com > Subject: RE: Machine Learning > Date: Fri, 24 Aug 2012 09:04:21 +0100 > > Hi Garot, > > How is the visual diagram coming along ? > > I'd be good to have a good idea of core system specifics so that DB design > can be tailored to that ... of course, knowing that things will change as the > concept evolves. > > Thanks, > Justin > > -Original Message- > From: Garot Conklin [mailto:garotconk...@yahoo.com] > Sent: 23 August 2012 20:14 > To: Martin Gainty; ag4ve...@gmail.com > Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com > Subject: Re: Machine Learning > > That is in fact a very interesting approach... I like it very much. Any > architectural thoughts on an auto-population attempt? Odly I have not created > a db like this before, not from this large of an import anyway... Please > share some thoughts there and I will get that rolling... seems that if we can > get something physical going I would like to offer it up as a sandbox to all > those interested. I have a few X336's lying around my house just collecting > dust, they would be a great testing environment for all to work on. > > > > garotconk...@yahoo.com > > > > From: Martin Gainty > To: ag4ve...@gmail.com; garotconk...@yahoo.com > Cc: webmas...@lisol.co.uk; "mysql@lists.mysql.com" > Sent: Thursday, August 23, 2012 11:30 AM > Subject: RE: Machine Learning > > > Shawn and Garot > > I like the parsing capability of the lucene and its ability to stem incoming > queries.. > If you are able to start populating your data then we *should* be able to > start identifying which root terms we can pull for building lucene-indexes I > have an upcoming > stuck-in-JFK-airport-on-labor-day-waiting-for-the-next-am-flight-of-USscare > for an interrupted timeframe(i never learned how to 'sleep' in airport > terminal) as long as I can find a wifi connection (and an AC connection > within 6 hours) and use a working MySQL JDBC connection string..I should be > able to bang out a quick prototype.. > > Let me know how i can help out, > Martin Gainty > __ > ..place long-winded disclaimer here.. > > > > From: ag4ve...@gmail.com > > Date: Thu, 23 Aug 2012 10:42:55 -0400 > > Subject: Re: Machine Learning > > To: garotconk...@yahoo.com > > CC: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com > > > > just a few thoughts (things to look into) > > > > if you want to populate a db with command parameters, i'd mine the man > > pages. it's a consistent format and you should be able to find a > > parser for whatever language you prefer. > > > > if you want to see what has been entered and statistics about that > > process, look at the audit framework. it won't tell you success or > > failure, but you might be able to derive that based on the time, > > memory, and process usage that you can get from audit. auditd also > > maintains a db - you might look into the engine and schema they use. > > > > you might also find some interesting topics looking into language > > processing (after all, commands are a type of language). people > > generally use other database engines to do this type of thing - > > elastic search or some other things people have done with lucene > > maybe. > > > > do let us know where you go with this. it sounds quite interesting > > (and might help me with something i've been looking into)... and > > getting zsh to autocomplete options might be a bonus if you parse man > > pages and shove it into a db (i might do that part for you if i get a > > lazy afternoon). > > > > On Wed, Aug 22, 2012 at 7:51 PM, Garot Conklin > > wrote: > > > I am going to work up a visual diagram for this to better... > > > visualize (LOL) the lay of th
RE: view query is slow
If memory serves predicates convert strings to column-data-type (in your case DATE) this *should* help WHERE dateexam = STR_TO_DATE('2012-08-13','%Y-%m-%d') does this help? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: j...@newcenturydata.com > Subject: view query is slow > Date: Thu, 23 Aug 2012 11:30:17 -0700 > To: mysql@lists.mysql.com > > I am working on a view based on this query: > > === > SELECT > -- Patient Info > p.IdPatient, > p.IdLastword MRN, > p.NameLast, > p.NameFirst, > p.Addr1, > p.Addr2, > p.AddrCity, > p.AddrState, > p.AddrZip, > p.Gender, > p.DateOfBirth, > -- Provider Info > af.IdAffil, > af.PractName, > af.OfficeName, > -- Exam Info > e.IdExam, > e.dateexam, > a.WorkArea dept, > a.Room location, > e.ProcModeCode, > e.ProcName, > e.IdRefSite, > ec.IdCPT, > e.zzk exam_zzk, > ec.zzk examcpt_zzk > FROM patient_ p > LEFT JOIN exams e ON e.IdPatient = p.IdPatient > LEFT JOIN Examcpt_ ec ON (e.IdExam = ec.IdExam AND '1' = Quantity) > LEFT JOIN Copy_ c ON CONCAT(e.IdAppt , '0') = c.IdApptType > LEFT JOIN Appt_ a ON e.IdAppt = a.IdAppt > LEFT JOIN Affil_ af ON c.IdPractAffil = af.IdAffil > WHERE > p.AddrState = 'WA' > AND e.statusnumber = '4' > AND e.IdRefSite <> 'S50' > AND e.IdRefSite <> 'S51' > AND e.IdREfSite <> 'S63' > AND p.DateOfBirth < DATE_ADD(CURDATE(), INTERVAL '-2' MONTH) > AND a.zzk IS NOT NULL > > > If I run this query itself (not in the view), and add this: > > AND e.dateexam = '2012-08-13' > > it runs like lightning, super fast. But if I run the query against the view, > for example "SELECT * FROM exam_view WHERE dateexam = '2012-08-13' > > It is so glacially slow that I end up having to kill the query. What is going > on, and how can I fix this? > > Jim McNeely > Northwest Radiologists > Senior Database Programmer > 360-788-9022 desk > 360-303-3332 mobile > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: Machine Learning
Shawn and Garot I like the parsing capability of the lucene and its ability to stem incoming queries.. If you are able to start populating your data then we *should* be able to start identifying which root terms we can pull for building lucene-indexes I have an upcoming stuck-in-JFK-airport-on-labor-day-waiting-for-the-next-am-flight-of-USscare for an interrupted timeframe(i never learned how to 'sleep' in airport terminal) as long as I can find a wifi connection (and an AC connection within 6 hours) and use a working MySQL JDBC connection string..I should be able to bang out a quick prototype.. Let me know how i can help out, Martin Gainty __ ..place long-winded disclaimer here.. > From: ag4ve...@gmail.com > Date: Thu, 23 Aug 2012 10:42:55 -0400 > Subject: Re: Machine Learning > To: garotconk...@yahoo.com > CC: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com > > just a few thoughts (things to look into) > > if you want to populate a db with command parameters, i'd mine the man > pages. it's a consistent format and you should be able to find a > parser for whatever language you prefer. > > if you want to see what has been entered and statistics about that > process, look at the audit framework. it won't tell you success or > failure, but you might be able to derive that based on the time, > memory, and process usage that you can get from audit. auditd also > maintains a db - you might look into the engine and schema they use. > > you might also find some interesting topics looking into language > processing (after all, commands are a type of language). people > generally use other database engines to do this type of thing - > elastic search or some other things people have done with lucene > maybe. > > do let us know where you go with this. it sounds quite interesting > (and might help me with something i've been looking into)... and > getting zsh to autocomplete options might be a bonus if you parse man > pages and shove it into a db (i might do that part for you if i get a > lazy afternoon). > > On Wed, Aug 22, 2012 at 7:51 PM, Garot Conklin wrote: > > I am going to work up a visual diagram for this to better... visualize > > (LOL) the lay of the land. I will forward it when i have it completed then > > I hope we can continue the architectural discussion here! Thanks > > > > -Garot > > > > > > garotconk...@yahoo.com > > > > > > > > From: Garot Conklin > > To: Garot Conklin ; "webmas...@lisol.co.uk" > > ; 'Martin Gainty' ; > > "mysql@lists.mysql.com" > > Sent: Tuesday, August 21, 2012 4:40 PM > > Subject: Re: Machine Learning > > > > to elaborate: > > > > I would almost rather qualify from the OS perspective what will work in > > advance, but take into consideration any failing condition. I may be > > getting a bit too specific at this juncture however as I am already apply > > this logic to issues I see in MY environment rather than total ambiguity, > > which is a best position here. > > > > I am ultimately expecting the learning algorithm to create new and > > excitingly effective ways of stringing commands together to solve issues, > > this being a notable aspect in and of itself, then creating some > > centralization based on what the machine determines as a best solution. > > > > Seems a relative "snapshot of the system" pre and post execution would be > > favorable as well so long as resources are not taxed as a result. This > > discussion is leading me to believe that this will be a multifaceted db > > solution without a doubt comprised of multiple layers of abstraction > > ultimately rolling up into a single master cluster for all the higher level > > analytics and internal testing cycles to then roll out the new primary > > protocols, which may themselves take place in a sub-instance of each > > possible scenario. > > > > I have also though of populating a db or multiple db's with actual text in > > the form of .pdf's of actual technical manuals... not certain the benefit > > of the written language abstraction there but the thought process > > extraction might be an interesting end indeed. > > > > > > > > garotconk...@yahoo.com > > > > > > > > From: Garot Conklin > > To: "webmas...@lisol.co.uk" ; 'Martin Gainty' > > ; "mysql@lists.mysql.com" > > Sent: Tuesday, August 21, 2012 4:09 PM > >
RE: help with correlated subquery
assign realistic alias names OuterJoin should be called OuterJoin InnerJoin should be called InnerJoin If you want only the most restricitive criteria that match resultsets from both select statements use INNER JOIN if you want all results from both resultsets (cartesian JOIN) use OUTER JOIN Finally: Be aware FUNCTIONS such as AVG cast off indexing and should be avoided unless the FUNCTION(columnName) itself is indexed GROUP BY re-arranges your query so its best to introduce GROUP BY in stages use realistic alias names like Dept and EmployeeNumber and avoid aliases that cause confusion like 'a' or 'foo' Develop in stages and write down what YOU EXPECT vs WHAT each query produces .. If the Individual Select doesnt produce expected results..STOP and correct the SELECT Statement Diagram out what you expect results from any of the INNER JOIN, OUTER JOIN, LEFT JOIN or RIGHT JOIN operations will produce If the executed JOIN Statement does not produce expected results STOP and correct the JOIN clause BEFORE incorporating more functionality Obfuscation and confusion can hopelessly sidetrack any intelligent analysis Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Tue, 21 Aug 2012 20:26:51 -0600 > Subject: Re: help with correlated subquery > From: larry.mart...@gmail.com > To: h...@tbbs.net > CC: mysql@lists.mysql.com > > On Tue, Aug 21, 2012 at 8:07 PM, wrote: > >>>>> 2012/08/21 16:35 -0600, Larry Martell >>>> > > I am trying to write a query that selects from both a correlated > > subquery and a table in the main query, and I'm having a lot of > > trouble getting the proper row count. I'm sure this is very simple, > > and I'm just missing it. I'll try and present a simple example. For > > this example, there are 27 rows, organized like this: > > > > > > mysql> select count(*), target_name_id, ep, wafer_id from data_cst > > where target_name_id = 44 group by target_name_id, ep, wafer_id; > > +--++--+--+ > > | count(*) | target_name_id | ep | wafer_id | > > +--++--+--+ > > |6 | 44 | 1,1 | 16 | > > |3 | 44 | 1,1 | 17 | > > |6 | 44 | 1,2 | 16 | > > |3 | 44 | 1,2 | 17 | > > |6 | 44 | 1,3 | 16 | > > |3 | 44 | 1,3 | 17 | > > +--++--+--+ > > 6 rows in set (0.00 sec) > > > > I need to get an average of a column grouped by target_name_id, ep as > > well as the average of the averages grouped by target_name_id, ep, > > wafer_id, and I also need the count of the rows in the target_name_id, > > ep group. My query is getting the correct averages, but incorrect row > > counts: > > > > mysql> select count(*), target_name_id, ep, avg(bottom), avg(averages) > > from (select avg(bottom) as averages, target_name_id as t, ep as e > > from data_cst where target_name_id = 44 group by target_name_id, ep, > > wafer_id) x, data_cst where target_name_id = t and ep = e group by > > target_name_id, ep; > > +--++--+-+-+ > > | count(*) | target_name_id | ep | avg(bottom) | avg(averages) | > > +--++--+-+-+ > > | 18 | 44 | 1,1 | 21.8056667 | 21.8545833 | > > | 18 | 44 | 1,2 | 121.798 | 121.83983335000 | > > | 18 | 44 | 1,3 | 349.763 | 349.75016665000 | > > +--++--+-+-+ > &g
RE: Machine Learning
Im thinking any of the JSR-286 Portal Management Systems can *probably* handle initial authentication and authentication-token access to all of the resources via token passing http://en.wikipedia.org/wiki/List_of_enterprise_portal_vendors http://portals.apache.org/jetspeed-2/ As far event models you might want to think of Observer Pattern specifically when you want one or more Nodes to observe or be notified of Change in Subject or delta-property http://userpages.umbc.edu/~tarr/dp/lectures/Observer.pdf Here is a concrete Java example of Observer pattern in Java http://www.vogella.com/articles/DesignPatternObserver/article.html As far as HW Requirements..the only requirement I see is for a MultiProcessor with some *kind of* LoadBalancer to arbitrate Load between the 1..n Nodes WDYT? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: webmas...@lisol.co.uk > To: garotconk...@yahoo.com; mgai...@hotmail.com; mysql@lists.mysql.com > Subject: RE: Machine Learning > Date: Tue, 21 Aug 2012 20:37:45 +0100 > > Ah, > > > > Getting clearer and clearer. > > > > So these ‘nodes’ could ‘learn’ and ‘teach’ at the same time – right ? For > instance, N1 runs a command in ‘domain’ D20 which it successful – it send > information to node N20 that is the authority on domain D20 and N20 records > it as success; N5 runs a command in domain D20 which goes wrong, and sends > info to N20 and N20 records failure and sends a correct call to N5. Is this > what you have in mind ? > > > > There are a lot of variables to be considered, for instance: > > 1) Command A version 1 can run very happily on operating system version > 2, but fails in OS version 1 > > 2) Command A version 1 can run happily on OS version 2 on a 2G RAM, but > fail on OS version 2 on 1G RAM > > 3) etc > > > > I think the DB design issues will become straightforward once the model is > quite clear. > > > > Justin > > > > From: Garot Conklin [mailto:garotconk...@yahoo.com] > Sent: 21 August 2012 17:14 > To: webmas...@lisol.co.uk; 'Martin Gainty'; mysql@lists.mysql.com > Subject: Re: Machine Learning > > > > 1)Refer to it for ‘knowledge’ (for instance, of what the latest > version of a command is) > > It would most likely end up being "central" in this sense: > > A distributed collection of systems; i.e. (possible defined in roles) > > DB's > > FE's > > REPL's > > Cache's > > Each DB would have its own collection of remediation's that would > then be indexed to populate a central db for trending/correlation etc... > > The "Collective" itself would function as a single conceptual > implementation. A VIP for example might be associated with a specific role, > say Web FE's and remediate only/all of them, but only have some relative > access to the core db of say the Network from a Primary index perspective to > make/draw associations/conclusions to issues at hand. > > > > > 2)Send their ‘knowledge’ (for instance, of the latest command > versions) to it for storage and distribution to others > > Rather than "latest command versions" I envision this to be more > encapsulated as "latest successful invocation of the command string" and it > inverse as well (to trend/metric-ize the failures thus lending to perpetual > optimization). > > > > I like how this is fleshing out... This is helping me to define what I am > really trying to accomplish. Thanks very much for everyone responding here, > this is wonderful, please keep this going... >
RE: Machine Learning
Im thinking any of the JSR-286 Portal Management Systems can *probably* handle initial authentication and authentication-token access to all of the resources via token passing http://en.wikipedia.org/wiki/List_of_enterprise_portal_vendors http://portals.apache.org/jetspeed-2/ As far event models you might want to think of Observer Pattern specifically when you want one or more Nodes to observe or be notified of Change in Subject or delta-property http://userpages.umbc.edu/~tarr/dp/lectures/Observer.pdf Here is a concrete Java example of Observer pattern in Java http://www.vogella.com/articles/DesignPatternObserver/article.html As far as HW Requirements..the only requirement I see is for a MultiProcessor with some *kind of* LoadBalancer to arbitrate Load between the 1..n Nodes WDYT? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: webmas...@lisol.co.uk > To: garotconk...@yahoo.com; mgai...@hotmail.com; mysql@lists.mysql.com > Subject: RE: Machine Learning > Date: Tue, 21 Aug 2012 20:37:45 +0100 > > Ah, > > > > Getting clearer and clearer. > > > > So these ‘nodes’ could ‘learn’ and ‘teach’ at the same time – right ? For > instance, N1 runs a command in ‘domain’ D20 which it successful – it send > information to node N20 that is the authority on domain D20 and N20 records > it as success; N5 runs a command in domain D20 which goes wrong, and sends > info to N20 and N20 records failure and sends a correct call to N5. Is this > what you have in mind ? > > > > There are a lot of variables to be considered, for instance: > > 1) Command A version 1 can run very happily on operating system version > 2, but fails in OS version 1 > > 2) Command A version 1 can run happily on OS version 2 on a 2G RAM, but > fail on OS version 2 on 1G RAM > > 3) etc > > > > I think the DB design issues will become straightforward once the model is > quite clear. > > > > Justin > > > > From: Garot Conklin [mailto:garotconk...@yahoo.com] > Sent: 21 August 2012 17:14 > To: webmas...@lisol.co.uk; 'Martin Gainty'; mysql@lists.mysql.com > Subject: Re: Machine Learning > > > > 1)Refer to it for ‘knowledge’ (for instance, of what the latest > version of a command is) > > It would most likely end up being "central" in this sense: > > A distributed collection of systems; i.e. (possible defined in roles) > > DB's > > FE's > > REPL's > > Cache's > > Each DB would have its own collection of remediation's that would > then be indexed to populate a central db for trending/correlation etc... > > The "Collective" itself would function as a single conceptual > implementation. A VIP for example might be associated with a specific role, > say Web FE's and remediate only/all of them, but only have some relative > access to the core db of say the Network from a Primary index perspective to > make/draw associations/conclusions to issues at hand. > > > > > 2)Send their ‘knowledge’ (for instance, of the latest command > versions) to it for storage and distribution to others > > Rather than "latest command versions" I envision this to be more > encapsulated as "latest successful invocation of the command string" and it > inverse as well (to trend/metric-ize the failures thus lending to perpetual > optimization). > > > > I like how this is fleshing out... This is helping me to define what I am > really trying to accomplish. Thanks very much for everyone responding here, > this is wonderful, please keep this going... >
RE: Machine Learning
Im thinking any of the JSR-286 Portal Management Systems can *probably* handle initial authentication and authentication-token access to all of the resources via token passing http://en.wikipedia.org/wiki/List_of_enterprise_portal_vendors http://portals.apache.org/jetspeed-2/ As far event models you might want to think of Observer Pattern specifically when you want one or more Nodes to observe or be notified of Change in Subject or delta-property http://userpages.umbc.edu/~tarr/dp/lectures/Observer.pdf Here is a concrete Java example of Observer pattern in Java http://www.vogella.com/articles/DesignPatternObserver/article.html As far as HW Requirements..the only requirement I see is for a MultiProcessor with some *kind of* LoadBalancer to arbitrate Load between the 1..n Nodes WDYT? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: webmas...@lisol.co.uk > To: garotconk...@yahoo.com; mgai...@hotmail.com; mysql@lists.mysql.com > Subject: RE: Machine Learning > Date: Tue, 21 Aug 2012 20:37:45 +0100 > > Ah, > > > > Getting clearer and clearer. > > > > So these ‘nodes’ could ‘learn’ and ‘teach’ at the same time – right ? For > instance, N1 runs a command in ‘domain’ D20 which it successful – it send > information to node N20 that is the authority on domain D20 and N20 records > it as success; N5 runs a command in domain D20 which goes wrong, and sends > info to N20 and N20 records failure and sends a correct call to N5. Is this > what you have in mind ? > > > > There are a lot of variables to be considered, for instance: > > 1) Command A version 1 can run very happily on operating system version > 2, but fails in OS version 1 > > 2) Command A version 1 can run happily on OS version 2 on a 2G RAM, but > fail on OS version 2 on 1G RAM > > 3) etc > > > > I think the DB design issues will become straightforward once the model is > quite clear. > > > > Justin > > > > From: Garot Conklin [mailto:garotconk...@yahoo.com] > Sent: 21 August 2012 17:14 > To: webmas...@lisol.co.uk; 'Martin Gainty'; mysql@lists.mysql.com > Subject: Re: Machine Learning > > > > 1)Refer to it for ‘knowledge’ (for instance, of what the latest > version of a command is) > > It would most likely end up being "central" in this sense: > > A distributed collection of systems; i.e. (possible defined in roles) > > DB's > > FE's > > REPL's > > Cache's > > Each DB would have its own collection of remediation's that would > then be indexed to populate a central db for trending/correlation etc... > > The "Collective" itself would function as a single conceptual > implementation. A VIP for example might be associated with a specific role, > say Web FE's and remediate only/all of them, but only have some relative > access to the core db of say the Network from a Primary index perspective to > make/draw associations/conclusions to issues at hand. > > > > > 2)Send their ‘knowledge’ (for instance, of the latest command > versions) to it for storage and distribution to others > > Rather than "latest command versions" I envision this to be more > encapsulated as "latest successful invocation of the command string" and it > inverse as well (to trend/metric-ize the failures thus lending to perpetual > optimization). > > > > I like how this is fleshing out... This is helping me to define what I am > really trying to accomplish. Thanks very much for everyone responding here, > this is wonderful, please keep this going... >
RE: Machine Learning
Forgive my flawed human intervention into the flawlessly scheduled and impeccably managed operational tasks performed by the 'perfect machine' I guess its time for another 'stress pill' Martin > Date: Tue, 21 Aug 2012 04:40:49 -0500 > From: mich...@j3ksolutions.com > To: mysql@lists.mysql.com > Subject: Re: Machine Learning > > I think it was the HAL-9000 in the movie 2001: A Space Odyssey > > > On 08/20/2012 06:25 PM, Martin Gainty wrote: > > When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that > > is running the show constantly admonishing its creator to "take another > > stress pill" > > > > Sounds like a fun project > > > > Keep us apprised, > > Martin Gainty > > __ > > Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité > > > > Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene > > Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte > > Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht > > dient lediglich dem Austausch von Informationen und entfaltet keine > > rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von > > E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > > Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le > > destinataire prévu, nous te demandons avec bonté que pour satisfaire > > informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie > > de ceci est interdite. Ce message sert à l'information seulement et n'aura > > pas n'importe quel effet légalement obligatoire. Étant donné que les email > > peuvent facilement être sujets à la manipulation, nous ne pouvons accepter > > aucune responsabilité pour le contenu fourni. > > > > > > Date: Mon, 20 Aug 2012 13:50:04 -0700 > > From: garotconk...@yahoo.com > > Subject: Re: Machine Learning > > To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com > > > > Ya the idea is not anything new, but must be apparently quit difficult or > > not a priority as I have yet to find it already implemented anywhere... Far > > be it from me to not make some attempt here anyway... > > I am creating a fully automated framework from which a distributed > > infrastructure can be maintained. I have been writing automation > > scripts/code for some time now and the logical progression is to embark on > > a full concept of systems health auto remediation. I have numerous > > "monitoring" solutions under my control however none that properly > > (in my opinion) implements any real learning algorithms from which to > > draw even a minimalists view of automation. I like mySQL therefor began > > thinking about creating the aspects (lobes) of the "brain" as a relational > > database(s). So this is only one facet of what I am trying to do, however > > leveraging a full command set of shell utilities/commands/programs seemed > > to be a good starting point before I get into the "hard" stuff ! > > > > -Garot > > garotconk...@yahoo.com > > From: "webmas...@lisol.co.uk" > > To: 'Martin Gainty' ; garotconk...@yahoo.com; > > mysql@lists.mysql.com > > Sent: Monday, August 20, 2012 3:55 PM > > Subject: RE: Machine Learning > > > > > > Hi Garot, > > > > > > > > You'll have to elaborate some more ... I understand you may want to protect > > the idea as well, so if you can narrow it down to some technical specifics > > then it'll help. > > > > > > > > What is the objective of this system, for instance ? > > > > > > > > Thanks, > > > > Justin > > > > > > > > From: Martin Gainty [mailto:mgai...@hotmail.com] > > Sent: 20 August 2012 19:23 > > To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com > > Subject: RE: Machine Learning > > > > > > > > > > > > From: garotconk...@yahoo.com > > Subject: Re: Machine Learning > > To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com > > > > > > My initial thought was to propagate the db with everything and allow the > > algorithm to then begin to determin trends/patterns > > MG>which trends or patterns will you be modelling? > > > > and begin either an indexing methodology > > MG
RE: Machine Learning
When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that is running the show constantly admonishing its creator to "take another stress pill" Sounds like a fun project Keep us apprised, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Mon, 20 Aug 2012 13:50:04 -0700 From: garotconk...@yahoo.com Subject: Re: Machine Learning To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com Ya the idea is not anything new, but must be apparently quit difficult or not a priority as I have yet to find it already implemented anywhere... Far be it from me to not make some attempt here anyway... I am creating a fully automated framework from which a distributed infrastructure can be maintained. I have been writing automation scripts/code for some time now and the logical progression is to embark on a full concept of systems health auto remediation. I have numerous "monitoring" solutions under my control however none that properly (in my opinion) implements any real learning algorithms from which to draw even a minimalists view of automation. I like mySQL therefor began thinking about creating the aspects (lobes) of the "brain" as a relational database(s). So this is only one facet of what I am trying to do, however leveraging a full command set of shell utilities/commands/programs seemed to be a good starting point before I get into the "hard" stuff ! -Garot garotconk...@yahoo.com From: "webmas...@lisol.co.uk" To: 'Martin Gainty' ; garotconk...@yahoo.com; mysql@lists.mysql.com Sent: Monday, August 20, 2012 3:55 PM Subject: RE: Machine Learning Hi Garot, You'll have to elaborate some more ... I understand you may want to protect the idea as well, so if you can narrow it down to some technical specifics then it'll help. What is the objective of this system, for instance ? Thanks, Justin From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: 20 August 2012 19:23 To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: RE: Machine Learning From: garotconk...@yahoo.com Subject: Re: Machine Learning To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com My initial thought was to propagate the db with everything and allow the algorithm to then begin to determin trends/patterns MG>which trends or patterns will you be modelling? and begin either an indexing methodology MG>which indexes are you considering: Unique index, primary index or foreign index? additional table/db creation process or both to further optimize the calls being made MG>optimize based on execution time or diskspace allocated, EliminatingFTS or some other criteria? MG>https://dev.mysql.com/doc/refman/5.5/en/optimization.html and build in some internal levels of redundancy. MG>what about replication MG>http://dev.mysql.com/doc/refman/5.5/en/replication.html I am actually approaching this with some degree of biological conception in the multipathing within our own brains however until I have something up and running under some substantial load however I may not get a complete picture. Thanks, Garot Interesting Martin _ From: webmas...@lisol.co.uk ; To: 'Garot Conklin' ; 'Martin Gainty' ; ; Subject: RE: Machine Learning Sent: Mon, Aug 20, 2012 7:13:25 AM Hi Garot, This sounds an interesting idea. Are you looking to store all known commands and their options or are you looking for a 'formula' for calling any unix command ? The reason for my question is that, at the end of the day, a unix command is just a program that is run in the operating system. Each program comes with its own options and acceptable inputs. I don't know if there is a rule or convention for structuring these commands. Are you then looking to build a system that '
RE: Machine Learning
From: garotconk...@yahoo.com Subject: Re: Machine Learning To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com My initial thought was to propagate the db with everything and allow the algorithm to then begin to determin trends/patterns MG>which trends or patterns will you be modelling? and begin either an indexing methodology MG>which indexes are you considering: Unique index, primary index or foreign index? additional table/db creation process or both to further optimize the calls being made MG>optimize based on execution time or diskspace allocated, EliminatingFTS or some other criteria? MG>https://dev.mysql.com/doc/refman/5.5/en/optimization.html and build in some internal levels of redundancy. MG>what about replication MG>http://dev.mysql.com/doc/refman/5.5/en/replication.html I am actually approaching this with some degree of biological conception in the multipathing within our own brains however until I have something up and running under some substantial load however I may not get a complete picture. Thanks, Garot Interesting Martin From: webmas...@lisol.co.uk ; To: 'Garot Conklin' ; 'Martin Gainty' ; ; Subject: RE: Machine Learning Sent: Mon, Aug 20, 2012 7:13:25 AM Hi Garot, This sounds an interesting idea. Are you looking to store all known commands and their options or are you looking for a 'formula' for calling any unix command ? The reason for my question is that, at the end of the day, a unix command is just a program that is run in the operating system. Each program comes with its own options and acceptable inputs. I don't know if there is a rule or convention for structuring these commands. Are you then looking to build a system that 'knows' all commands and 'how to' call them ? Thanks, Justin -Original Message- From: Garot Conklin [mailto:garotconk...@yahoo.com] Sent: 20 August 2012 03:39 To: Martin Gainty; mysql@lists.mysql.com Subject: Re: Machine Learning The initial goal is to provide a working framework from which to call all UNIX shell command combinations as the underlying storage mechanism for a machine learning algorithm. I would like to build a completely self aware instantiation that will maintain itself on all levels... I postulate that the first place to start would be in determining a method for maintaining all possible remediation combinations including the unknown to eventually be learned from and populate new knowledge into the database. Thank you for the reply, Garot
RE: Machine Learning
Garot Can ypou provide any specific goal(s) on what you would like to achieve? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Sat, 18 Aug 2012 18:11:51 -0700 > From: garotconk...@yahoo.com > Subject: Machine Learning > To: mysql@lists.mysql.com > > Although this may be a feeble first thought on a machine learning framework, > I thought I would ask this group regardless. Can anyone weigh in on the > possibility (or known existence) of creating a db leveraging all Linux system > commands (with all flags). Thanks. > > > garotconk...@yahoo.com
RE: trouble with perl
I know I had the same problem with PHP when mysql.dll was off my PATH..put the 2 mysql libraries on the first directory from your PATH 05/30/2008 08:17 PM 2,125,824 libmysql.dll 06/13/2012 06:31 PM34,304 php_mysql.dll be aware when things go wrong with DLL's you have no way to fix it except 1)grab the source 2)build it ..usually thru .\configure then .\make install 3)make sure the new binary gets installed to the first directory on your PATH Viel Gluck, Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Wed, 8 Aug 2012 13:28:42 -0400 > Subject: Re: trouble with perl > From: per...@elem.com > To: elim@gmail.com > CC: mysql@lists.mysql.com > > On Wed, Aug 8, 2012 at 1:12 PM, Elim Qiu wrote: > > But when I use browser for the system testing (perl_test.cgi and forum.pl), > > both report me that DBD:mysql is not installed (or not available) > > It's possible that DBD::mysql is installed in a place where it's not > in the library path for your CGI script, or that you have more than > one Perl installed on your system. > > I'd suggest you get some help either from the group that makes mwforum > or on the Perl Beginner's list, since this is not a MySQL issue. The > Perl Beginners list is here: http://lists.perl.org/list/beginners.html > > - Perrin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: UDF writing to unix socket - segfaults?
this is pure speculation unless we can get ahold of the source code for your specific version of glibc and determine what the maximum sizes are .. otherwise anything I suggest would be speculative..lets take a look at http://fossies.org/dox/glibc-2.16.0/sysdeps_2mach_2hurd_2sendto_8c_source.html ssize_t 29 __sendto (int fd, 30 const void *buf, 31 size_t n, 32 int flags, 33 const struct sockaddr_un *addr, 34 socklen_t addr_len) Here his maximum buffer length for sending is unsigned int specifically size_t so.. are both send and receive entities IPv4 or both entities are IPv6 if thats the case.. can you send 0 Bytes 2 bytes 4 bytes 8 bytes at what maximum length of buffer does the segfault occur ? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: p...@computer.org > Subject: RE: UDF writing to unix socket - segfaults? > Date: Wed, 8 Aug 2012 15:39:09 +0200 > To: mysql@lists.mysql.com > > Martin Gainty wrote: > > > assuming you worked out the access to network by your code permissions > > When I open the unix socket, I give it 0777. > > > that means memory heap or stack is being overrun...you would be well > > advised to download the connect() and sendto() code from the OS vendor > > I'm running on Linux, so that is glibc - they work fine in a lot of > other code. I find it hard to suspect those two. > > > /Per > > -- > Per Jessen, Zürich (23.0°C) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: UDF writing to unix socket - segfaults?
assuming you worked out the access to network by your code permissions that means memory heap or stack is being overrun...you would be well advised to download the connect() and sendto() code from the OS vendor and toss in plenty of codeguard and debug statements and recompile and rebuild. Mit Fruendlichen Grüßen Martin (12.2°C) __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: p...@computer.org > Subject: UDF writing to unix socket - segfaults? > Date: Wed, 8 Aug 2012 08:26:23 +0200 > To: mysql@lists.mysql.com > > I am writing a UDF for sending messages to a local daemon. I've been > trying to make it use a UNIX socket, but it keeps segfaulting on > connect() or sendto(). I have double and tripled checked everything, > but I'm not finding anything. > > After a day or two, I finally decided to switch to UDP and writing to > localhost instead, which works fine. I still feel writing to a UNIX > socket ought to work and even if I've got a permission issue or > similar, a segfault is not the appropriate handling. Any clues? > > > -- > Per Jessen, Zürich (16.5°C) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: About character_set_*
Unless your effort is to convert all text strings to Mainland Chinese only ...Dont forget 'Locale' http://dev.mysql.com/doc/refman/5.5/en/locale-support.html Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: rja...@yahoo-inc.com > To: zzgang2...@gmail.com; mysql@lists.mysql.com > Date: Tue, 7 Aug 2012 11:55:15 -0700 > Subject: RE: About character_set_* > > The answer is long and involved... > http://mysql.rjweb.org/doc.php/charcoll > > > -Original Message- > > From: Zhigang Zhang [mailto:zzgang2...@gmail.com] > > Sent: Tuesday, August 07, 2012 3:25 AM > > To: mysql@lists.mysql.com > > Subject: About character_set_* > > > > Hello. > > > > > > > > As I know, when client send data to server, the encoding converting > > process > > is: > > > > > > > > character_set_client --> character_set_connection --> db table > > encoding. > > > > > > > > I think it is a short path than above way: > > > > > > > > character_set_client --> db table encoding. > > > > > > > > Why it is converted to "character_set_connection"? > > > > > > > > > > > > Yours > > > > Zhigang. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: New guy
Bonjour Raymond Nous espérons que cela vaut votre temps Bon chance! Martin __ Note de déni et de confidentialitéCe message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Thu, 21 Jun 2012 21:39:34 +0100 > Subject: Re: New guy > From: eroomy...@gmail.com > To: radan...@osullivan-quebec.qc.ca > CC: mysql@lists.mysql.com > > Welcome Raymond, hope you enjoy your stay :) > > On Thu, Jun 21, 2012 at 8:47 PM, Raymond D'Anjou < > radan...@osullivan-quebec.qc.ca> wrote: > > > I don't know if new members usually introduce themselves here... > > ...but if not, why not? > > > > I was very active on the SQL Server news group a few years back but this > > MYSQL stuff is new to me. > > Seems I'll be muddling around for at least a little while so I might have > > a few questions in the near future. > > > > Thanks in advance, > > Raymond from Québec City > > > > Raymond D'Anjou > > Programmeur-analyste WEB > > Artmérik International > > 600, rue Saint-Jean > > Québec (Québec) G1R 1P8 > > www.artmerik.com<http://www.artmerik.com> > > Tél.: 418-529-6800 > > Téléc.: 418-529-1982 > > > >
RE: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express
Miguel.. i do not have VC2010 but as my memory recalls the C runtime library (MSVCRT*.dll) would be the first library on %PATH% .. and all missing functions *should* be located inside the dll (e.g. __CrtSetReportFile ) can you 1) locate MSVCRT*.dll on your %PATH% 2) dumpbin -exports MSVCRT*.dll Saludos Cordiales (desde EEUU) Martin __ Porfavor no altere esta communicacion..Gracias > Date: Tue, 19 Jun 2012 10:24:48 -0400 > Subject: Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ > 2010 Express > From: chamael...@gmail.com > To: renit...@gmail.com > CC: mysql@lists.mysql.com > > On Tue, Jun 19, 2012 at 2:48 AM, Miguel Cardenas wrote: > > Hello friends > > 1>mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external > > symbol __CrtSetReportFile referenced in function _DbugExit > > 1>mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external > > symbol __CrtSetReportFile > > 1>mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external > > symbol __CrtSetReportMode referenced in function _DbugExit > > 1>mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external > > symbol __CrtSetReportMode > > 1>mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external > > symbol __CrtDumpMemoryLeaks referenced in function _my_end > > 1>mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external > > symbol __CrtCheckMemory referenced in function _my_end > > > > Do I have to include an aditional library so the symbols are resolved > > correctly? The release mode works perfect and the application runs > > fine in that way only... > > The missing functions should be provided by the Visual Studio debug > runtime library. Are all source files in your own code compiled and > program linked with one, and only one, of the flags /MDd (dynamic > linking) or /MTd (static linking)? > > Lars Nilsson > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: Simple Email System (SES) Provider
Hi Don Your best solution is to setup your own Mail server (Preferably on SSL) http://en.wikipedia.org/wiki/Comparison_of_mail_servers Configure Open Relay to 'Off' Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet ezen üzenet tartalma miatt. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: d...@pointmade.net > To: mysql@lists.mysql.com > Subject: Simple Email System (SES) Provider > Date: Fri, 1 Jun 2012 17:33:22 -0700 > > Hi all, > > I built a system in PHP/mySQL where a group of users post events, sign- > up for events, change their arrival times, remove thier names from > events, and post related notes on the events. Each time an action is > done, an email is generated to the entire group that their has been a > change. Pretty standard stuff... > > Today I just got an Mail Delivery System email with this error: > > Domain dwdcweb.info has exceeded the max emails per hour (350/350 > (100%)) allowed. Message will be reattempted later > > I contacted my VPS provider and they just alerted me that there is a > limit on how many emails my server can send per hour. > > They recommended I find a 3rd party service provider with support PHP > API connections. > > My budget is limited. Does anyone have any suggestions of companies > that might work for my scenario? > > Any feedback is appreciated ;-) > > Don > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
RE: Percona: Contact Details - a word on poaching
Johann I would like to *think* the dutch would be agreeable to advice from German and or French supporters of the EU Occasionally I am contacted by someone in the Hague for Database Administrator Positions If you've been good about NOT doing strip searches on political enemies I can get you in the door On the other hand if you've been a full blown nazi with illegal wiretaps, strip searches and harassment you might wind up in the Hague for different circumstances. I am reminded of the platitude: United we stand..Divided we fall Bedankt, Martin Gainty __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet ezen üzenet tartalma miatt. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Tue, 3 Apr 2012 10:41:39 +0200 > From: vegiv...@tuxera.be > To: wmo...@ucsc.edu > CC: mysql@lists.mysql.com > Subject: Re: Percona: Contact Details - a word on poaching > > - Original Message - > > From: "Wes Modes" > > > > Hi, I received a suggestion from Baron Schwartz that I consider your > > company for consulting advice as a solution to an enquiry I made to > > the MySQL list. I did not respond to Baron Schwartz and now I receive > > this email from an account executive. I don not think I am alone is > > believing poaching the list is unethical. > > > > Please feel free to have your experts offer suggestions and advice, > > but having those experts directly passing contacts on to sales execs does > > not feel okay. Using the MySQL lists as a honey pot for sales > > opportunities is not why the list exist. > > > I'm slightly in two minds, here. On the one hand, yes, the list isn't made > for being poached. > > On the other hand, it is my experience that Percona is very liberal in > dispensing free - and good - advice here. Your recent enquiry is not an > obvious thing, however. Percona is still a business, and your problem is > unlikely to be solved just like that - it seems appropriate for them to offer > their services. The sales guy might've waited a bit longer to see if you > responded, but it still doesn't feel all that pushy, to me. > > You say you haven't answered, yet; so you also haven't quite told them that > you're /not/ in the market, either :-) I'm sure a simple "no, not right now" > is sufficient, if you're not interested. > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql >
Re: Uninstall MySql Service
There is good advice by Rob Allen at http://akrabat.com/computing/uninstalling-mysql-on-mac-os-x-leopard/ for the Mac To uninstall MySQL and completely remove it (including all databases) from your Mac do the following: * Use mysqldump to backup your databases to text files! * Stop the database server * sudo rm /usr/local/mysql * sudo rm -rf /usr/local/mysql* * sudo rm -rf /Library/StartupItems/MySQLCOM * sudo rm -rf /Library/PreferencePanes/My* * edit /etc/hostconfig and remove the line MYSQLCOM=-YES- * rm -rf ~/Library/PreferencePanes/My* * sudo rm -rf /Library/Receipts/mysql* * sudo rm -rf /Library/Receipts/MySQL* * sudo rm -rf /private/var/db/receipts/*mysql* Perhaps it will work with Windows, mutatis mutandis On 11/19/11 12:29 AM, "AndrewMcHorney" wrote: >Hello > >I want to completely reinstall my sql server due to prior install >issues. How can you uninstall the MySql service? I am running under >window 7. > >Andrew > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: >http://lists.mysql.com/mysql?unsub=martin.muel...@mac.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how do I make utf8 the default encoding for my MySQL installation
Is it possible to make utf8 the default for all databases and transactions in a MySQL installation? The current default is Latin1. There is a suggestion on the Web to edit the my.cnf file as follows [mysqld] init_connect=’SET collation_connection = utf8_general_ci’ init_connect=’SET NAMES utf8′ default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci skip-character-set-client-handshake On a Mac with MySQL 5.5.17 this produces the error [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' The Reference Manual is very tortuous but lacks instructions that are clear to a not very technical user. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL install on OS X Lion does not create root account
I have been struggling with installing MySQL 5.5.17 on a Mac running OS 10.7. My machine had 5.5.15 on it. I keep getting user denied access messages (Error 1045). I thought at first it was a matter of a password not being flushed from a previous installation and went through repeated install and uninstall routines, using the instructions by Rob Allen at (http://akrabat.com/computing/uninstalling-mysql-on-mac-os-x-leopard/) . I also followed various instructions in the MySQL documentation for resetting lost passwords. But the results persuaded me that the problem is something else: the installer does not create a root account or a mysql account in the user table. Thus the update command for resetting the root password executes correctly but update 0 rows. And logging in with the skip-grants-table lets you address some queries to the mysql user table. "Select count(user) from user" returns 0, as does "select user, password from user." So it appears that the installation routine (from the disk image) does not populate the user table with accounts from which you could then perform other activities. Does anybody have any idea what is going on here or what I could be doing wrong?
problem with installing MySQL 5.5 on OS Lion
I had MySQL 5.5.15 running on OS X Lion, deleted it, and tried to install 5.5.17. I have run into problems that I cannot solve. To begin with the end, I can run start mysqld with the skip-grant-tables option and connect with mysql. If I issue the command select * from mysql the result returns an empty set. This squares with the following finding. I had thought that lost passwords caused problems and ran the procedure for updating the root password that is set forth in the MySQL documentation. The procedure executes, except that it says that 0 rows were updated. So I assume that the user account root does not exist on the machine. There is a mysql user account on my Mac, but there may not be a mysql user entry in the user table. If I try to connect to the server with the mysql command when the server is started in the ordinary fashion I get the error message Access denied for user 'martin'@'localhost' (using password: NO) ditto for commands like mysql p u root mysql u root and the like. I should add that I followed Rob Allen's instructions for completely uninstalling previous versions, and theoretically speaking there should be no traces of earlier passwords on my system. But I'm not sure. I should add that I also followed the Post-installation steps inPaul Dubois's MySQL, and I noticed something odd. According to him, if you have a .tar package you need to run the mysql_install_db script. If you have a .dmg package, the installer runs it for you. When the .dmg package had the problems I described above, I tried a fresh installation from the .tar package. But the command bin/mysql_install_db user=mysql does not work , and in fact there is no script by that name in the /usr/local/mysql/bin directory. In short, in my installation there seems a gap between mysql and mysql, and I can't find any good explanations for what I might have done wrong or how I could fix it. I'll be grateful for any help.
RE: Hungarian Notation [Was Re: Too many aliases]
Jan- the upside is you dont have to look up a variable to know what type it is: zVariable is Null termed string bVariable is boolean nVariable is an Integer fVariable is a float dVariable is a double.. cVariable is a char Martin __ easy peasy..Shawshank Redemption > Subject: Hungarian Notation [Was Re: Too many aliases] > From: j...@bytesmiths.com > Date: Sat, 6 Aug 2011 09:58:43 -0700 > To: mysql@lists.mysql.com > > > From: Johnny Withers > > > > http://en.wikipedia.org/wiki/Hungarian_notation > > "The original Hungarian notation... was invented by Charles Simonyi... who > later became Chief Architect at Microsoft." > > Ugh. That explains a lot! > > The only time I let types intrude on names is with booleans, which I try to > name with a state-of-being verb, such as "has_paid", "is_member", > "has_children", etc. > > > On Thu, Aug 4, 2011 at 9:41 AM, Mike Diehl wrote: > > > >> Well, while we're on the subject of SQL style, can anyone tell me why I'm > >> always seeing people prefixing the name of a table with something like > >> "tbl?" > > > You can't do anything about the length of your life, but you can do something > about its width and depth. -- H. L. Mencken > Jan Steinman, EcoReality Co-op > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com >
RE: Free Navicat
you will need the x86-64bit distro which contains the x86-64 bit distribution of libatkmm-1.6.so.1RPMs are error prone because they are version unaware..navicat should refactor their install to a version aware utility such as maven IMHO Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Tue, 26 Jul 2011 17:05:58 +0530 > From: adarsh.sha...@orkash.com > To: li...@olindata.com > CC: mysql@lists.mysql.com > Subject: Re: Free Navicat > > Ya , I know that but I fail to install Mysql-workbench in Linux Systems > ( CentOS , Ubuntu ) > > Error shows like below : > > [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm > error: Failed dependencies: > libatkmm-1.6.so.1()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libcairomm-1.0.so.1()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libcrypto.so.10()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libgdkmm-2.4.so.1()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libgio-2.0.so.0()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libgiomm-2.4.so.1()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libglibmm-2.4.so.1()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libgtkmm-2.4.so.1()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > liblua-5.1.so()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libpangomm-1.4.so.1()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libpython2.6.so.1.0()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libsigc-2.0.so.0()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libssl.so.10()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libstdc++.so.6(GLIBCXX_3.4.10)(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libstdc++.so.6(GLIBCXX_3.4.11)(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libstdc++.so.6(GLIBCXX_3.4.9)(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libuuid.so.1(UUID_1.0)(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libxml2.so.2(LIBXML2_2.4.30)(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > libzip.so.1()(64bit) is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > pexpect is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 > python(abi) = 2.6 is needed by > mysql-workbench-gpl-5.2.34-1el6.x86_64 > python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 > [root@ws-test Desktop]# > > Is there is a any detailed link to install it with dependencies. > > Thanks > Walter Heck - OlinData.com wrote: > > You can try MySQL Workbench instead. It's FOSS too: http://wb.mysql.com/ > > > > have fun! > > > > On Tue, Jul 26, 2011 at 14:31, Adarsh Sharma > <mailto:adarsh.sha...@orkash.com>> wrote: > > > > Dear all, > > > > Is there is any free version of Navicat to access data from Mysql. > > I am using 30-day trial version. > > > > Thanks > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?unsub=li...@olindata.com > > > > > > > > > > -- > > Walter Heck > > -- > > Founder @ OlinData (http://olindata.com) > > Co-founder @ Tribily (http://tribily.com) > > -- > > Follow @tribily on Twitter and/or 'Like' our Facebook page at > > http://www.facebook.com/tribily > > >
RE: dumb question?
Rik and Crew String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are enabled Column names are never surrounded by ticks or double quotes so TABLE table_name FOO VARCHAR(30) where the INSERT statement for table table_name column FOO would look like: INSERT INTO table_name FOO VALUES('VALUES ARE ALWAYS SURROUNDED BY TICK MARKS UNLESS ANSI_QUOTES ARE ENABLED'); Bedankt, Martin > Subject: Re: dumb question? > From: rik.was...@grib.nl > To: mysql@lists.mysql.com > Date: Wed, 6 Jul 2011 16:39:16 +0200 > > On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote: > > On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote: > > > (error code) 1064 > > > (error message) HY000 [Actual][MySQL] You have an error in your SQL > > > syntax; check the manual that corresponds to your MySQL server version > > > for the right syntax to use near '"DMPPRuser") VALUES ('MYNAME')' at line > > > 1 > > > > You'll need to enable ANSI_QUOTES to be able the use '"' as an > > identifier quote character rather then MySQL's default '`'. > > > > See: > > http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes > > Oh, and if possible, go for even more standards-compliant: > http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi > > -- > Rik > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com >
RE: Query on wait_timeout
TRAN (or TRANSACTION) will apply an implicit lock on the table which remains until the TRAN is commit or rollback subsequent DML statements on that same table will be forced to wait UNTIL the TRAN is commit or rollback when the statement for the second update on the same table comes along there is a deadlock a the first TRAN has an update lock on that same table...the second statement will not execute UNTIL the first statement TRAN is either commit or rollback releasing the initial lock on that table Viel Gluck, Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet ezen üzenet tartalma miatt. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Thu, 16 Jun 2011 15:21:38 +0530 > From: adarsh.sha...@orkash.com > To: mysql@lists.mysql.com > Subject: Re: Query on wait_timeout > > Thanks Suresh but I find it very difficult to implement it :- > > Suresh Kuna wrote: > > > > Try this out:-) > > > > Below are the steps to generate a deadlock so that the behaviour of a > > deadlock can be illustrated: > > > > -- 1) Create Objects for Deadlock Example > > USE TEMPDB > > > Is I have to create temdb database as below : > create database tempdb > before running the command : > > For running below commands , I have to create database dbo or it is > something else > > > > CREATE TABLE dbo.foo (col1 INT) > > INSERT dbo.foo SELECT 1 > > > > CREATE TABLE dbo.bar (col1 INT) > > INSERT dbo.bar SELECT 1 > > > > -- 2) Run in first connection > > BEGIN TRAN > > UPDATE tempdb.dbo.foo SET col1 = 1 > > > Don;t understand how to implement it . Is BEGIN TRAN or BEGIN > TRANSACTION command > > > > -- 3) Run in second connection > > BEGIN TRAN > > UPDATE tempdb.dbo.bar SET col1 = 1 > > > Can U explain the below and commands : > > > > UPDATE tempdb.dbo.foo SET col1 = 1 > > > > > -- 4) Run in first connection > > UPDATE tempdb.dbo.bar SET col1 = 1 > > > > Connection two will be chosen as the deadlock victim > > > > > > > > On Thu, Jun 16, 2011 at 10:53 AM, Adarsh Sharma > > mailto:adarsh.sha...@orkash.com>> wrote: > > > > How we can create a deadlock manually to test this problem. > > > > Thanks > > > > > > Suresh Kuna wrote: > > > > Good question Yogesh, I can say the best solution is > > > > Create a deadlock and test it, you will come to know more > > about it. > > > > On Wed, Jun 15, 2011 at 3:38 PM, Yogesh Kore > > mailto:yogeshk...@gmail.com>> wrote: > > > > > > > > Hi, > > > > Small doubt for wait_timeout. > > > > If my wait_timeout is set for 180 seconds and if any > > deadlock occures and > > both query are waiting to execute. What wil happen in that > > case? > > 1. Do the connection will wait till deadlock is removed or > > 2. Connection will close after 180 seconds as both queries > > are ideal and > > waiting for each other. > > > > Thanks, > > Yogesh > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > Thanks > > Suresh Kuna > > MySQL DBA >
RE: DBCP error
connection leaks will occur because of code maladies did you check your code to ensure: you are closing Statement Handles when you have finished executing the statement? you are closing Connection Handles when you have finished DML and DDL operations with the Database? ? Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > Date: Fri, 6 May 2011 15:42:56 +0530 > Subject: Fwd: DBCP error > From: dhaval.jais...@via.com > To: mysql@lists.mysql.com > CC: shrinivas.devarko...@via.com > > Hi All, > > We are frequently getting DBCP error. We have seen this error in > catalina.log & apps log. This issue has started since last 2 -3 days. We > have checked the application code when this error has occured and assure > that there is no connection leakage in code. Mysql server is also running > fine. We have tune memory parameters in mysql, however effectless. Still we > are getting the same error. > > Any suggestion/solution would be appreciated. > > > Mysql server version: 5.0.45 > > JDBC version: mysql-connector-java-5.1.5-bin.jar > > apache Tomcat version: 6.0.16 > > > server.xml parameters are as follows:: > > > url="jdbc:mysql://hostname:3306/dbname" username="user" password="pass" > maxActive="40" maxIdle="20" maxWait="5000" > > > > ERROR: > > > 2011-05-05 16:32:57,666 [ajp-8009-177] ERROR TrainSearchResultCache.java - > Error retrieving Train Search from DB: s- > > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, > pool error Timeout waiting for idle object > > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104) > > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) > > at > com.eos.gds.data.DatabaseManager.getConnection(DatabaseManager.java:73) > > at > com.eos.gds.data.DatabaseManager.getConnection(DatabaseManager.java:60) > > > > Caused by: java.util.NoSuchElementException: Timeout waiting for idle object > > at > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:958) > > at > org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84) > > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96) > > ... 28 more > > > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications > link failure > > Last packet sent to the server was 24 ms ago. > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > > at > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) > > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2873) > > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2763) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3299) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961) > > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543) > > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925) > > at > org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) > > at > com.eos.gds.cach
RE: Input needed...
> From: h.rei...@thelounge.net > To: mysql@lists.mysql.com > Subject: Re: Input needed... > > Am 06.05.2011 13:26, schrieb J M: > > Config: > > > > Running on 8G Server.. Currently utilizing 7G.. running only mysql.. > > > [mysqld] > > innodb_data_home_dir = /var/lib/mysql/ > > innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend > > bad - you get one flat storage-pool which will grow > and never can be rudced with "optimize table" MG>so the datafile could never be reduced with OPTIMIZE TABLE MG>http://www.pythian.com/news/1067/difference-between-innodb_data_file_path-and-innodb_file_per_table/ MG>would you suggest using innodb_file_per_table for more granular control? MG>is it worth the effort to export the database and reimport the data into new db using innodb_file_per_table enabled in my.cnf? MG>http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_file_per_table > danke, Martin
RE: Input needed...
Harald- could you re-iterate the details of the malady or error you are experiencing? danke, Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > Date: Fri, 6 May 2011 07:26:20 -0400 > Subject: Re: Input needed... > From: jerom...@gmail.com > To: h.rei...@thelounge.net > CC: mysql@lists.mysql.com > > Config: > > Running on 8G Server.. Currently utilizing 7G.. running only mysql.. > > [client] > port= 3306 > socket = /var/lib/mysql/mysql.sock > > > [mysqld] > port= 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer_size = 384M > max_allowed_packet = 1M > table_open_cache = 512 > sort_buffer_size = 2M > read_buffer_size = 2M > read_rnd_buffer_size = 8M > myisam_sort_buffer_size = 64M > thread_cache_size = 8 > query_cache_size = 32M > thread_concurrency = 8 > max_connections = 802 > wait_timeout = 15 > > > log-bin=mysql-bin > > server-id = 1 > > > > innodb_data_home_dir = /var/lib/mysql/ > innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend > innodb_log_group_home_dir = /var/lib/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 > > [mysqldump] > quick > max_allowed_packet = 16M > > [mysql] > no-auto-rehash > > [myisamchk] > key_buffer_size = 256M > sort_buffer_size = 256M > read_buffer = 2M > write_buffer = 2M > > [mysqlhotcopy] > interactive-timeout > > On Thu, May 5, 2011 at 2:46 PM, Reindl Harald wrote: > > > please post your my.cnf settings becuase stats are useless without > > knowing the configuration and without knowing your hardware (memory!) > > nobody can say what buffers are making sense > > > > i would use "mysqltuner.pl" because it shows in the most cases good > > advises > > > > Am 05.05.2011 20:42, schrieb J M: > > > Hi, > > > > > > I have this stats: I have tuned some of it but I was wondering if > > someone > > > can give inputs regarding it: > > > > > > * > > > __ Key _ > > > Buffer used54.63M of 384.00M %Used: 14.23 > > > Current 123.21M%Usage: 32.09 > > > Write hit 99.97% > > > Read hit 100.00% > > > > > > __ Questions ___ > > > Total 87.40M18.4/s > > > QC Hits 50.63M10.7/s %Total: 57.93 > > > DMS 24.04M 5.1/s 27.50 > > > Com_ 8.52M 1.8/s9.75 > > > COM_QUIT 4.24M 0.9/s4.85 > > > -Unknown 28.31k 0.0/s0.03 > > > Slow 10 s 9.21k 0.0/s0.01 %DMS: 0.04 Log: OFF > > > DMS24.04M 5.1/s 27.50 > > > SELECT 21.98M 4.6/s 25.14 91.41 > > > UPDATE1.74M 0.4/s1.99 7.24 > > > INSERT 211.35k 0.0/s0.24 0.88 > > > DELETE 111.77k 0.0/s0.13 0.46 > > > REPLACE 0 0/s0.00 0.00 > > > Com_8.52M 1.8/s9.75 > > > set_option4.26M 0.9/s4.87 > > > change_db 4.22M 0.9/s4.83 > > > show_table_ 9.33k 0.0/s0.01 > > > > > > __ SELECT and Sort _ > > > Scan 838.37k 0.2/s %SELECT: 3.81 > > > Range 2.12M 0.4/s9.64 > > > Full join 988 0.0/s0.00 > > > Range check 0 0/s0.00 > > > Full rng join 0 0/s0.00 > > > Sort scan 3.71M 0.8/s > > > Sort range 3.63M 0.8/s > > > Sort mrg pass 82.85k 0.0/s > > > > > > __ Quer
RE: Запрос
(ich spreche nicht Russen) Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > From: mr.victor-tutun...@yandex.ru > To: mysql@lists.mysql.com > Subject: Запрос > Date: Thu, 28 Apr 2011 16:01:41 +0700 > > > Подскажите по чему не устанавливается или какие действия надо сделать чтобы > выйти из этого приложения. > -- > Vitek > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com >
RE: mysql deal with specail character problem
correct here is the output of INFORMATION_SCHEMA.COLUMNS Create Table: CREATE TEMPORARY TABLE `COLUMNS` ( `TABLE_CATALOG` varchar(512) DEFAULT NULL, `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '', `TABLE_NAME` varchar(64) NOT NULL DEFAULT '', `COLUMN_NAME` varchar(64) NOT NULL DEFAULT '', `ORDINAL_POSITION` bigint(21) unsigned NOT NULL DEFAULT '0', `COLUMN_DEFAULT` longtext, `IS_NULLABLE` varchar(3) NOT NULL DEFAULT '', `DATA_TYPE` varchar(64) NOT NULL DEFAULT '', `CHARACTER_MAXIMUM_LENGTH` bigint(21) unsigned DEFAULT NULL, `CHARACTER_OCTET_LENGTH` bigint(21) unsigned DEFAULT NULL, `NUMERIC_PRECISION` bigint(21) unsigned DEFAULT NULL, `NUMERIC_SCALE` bigint(21) unsigned DEFAULT NULL, `CHARACTER_SET_NAME` varchar(64) DEFAULT NULL, `COLLATION_NAME` varchar(64) DEFAULT NULL, `COLUMN_TYPE` longtext NOT NULL, `COLUMN_KEY` varchar(3) NOT NULL DEFAULT '', `EXTRA` varchar(27) NOT NULL DEFAULT '', `PRIVILEGES` varchar(80) NOT NULL DEFAULT '', `COLUMN_COMMENT` varchar(255) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 If i had configured utf16 or any character-set which supports DBCS then i *could* implement CJK languages in the DB how goes the recovery ? Martin __ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: je...@gii.co.jp > To: tyzha...@gmail.com; mysql@lists.mysql.com > Subject: RE: mysql deal with specail character problem > Date: Thu, 21 Apr 2011 09:35:02 -0400 > > >-Original Message- > >From: ?? [mailto:tyzha...@gmail.com] > >Sent: Thursday, April 21, 2011 7:09 AM > >To: mysql > >Subject: mysql deal with specail character problem > > > >Hi: > >I have a table that the field a is primary key; > >I insert a record like this > >insert into table(a,b,c) values('?',1,1) > >Then i insert a record like this > > insert into table(a,b,c) values('?',1,1) > > > >mysql post a error execute failed: Duplicate entry '?-1-1' for key 1; > > > >it is strange, the primary key field is not the same, but i get this error. > > > >any one can help me? > > > [JS] What is the character set and collation for that field? Please post the > output of > > SHOW CREATE TABLE x\G > > (Please use the \G, so that the output will fit in your message better.) > > There is something wrong with the way your data is going in, because the > commas are not being seen properly. You are putting in > > '?',1,1 > > but MySQL is showing > > '?-1-1' > > in the error message! That is a clue. > > I have put plenty of Japanese and Chinese characters into my database, so > don't give up hope. > > >Thanks > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com >
RE: Practical connection limits MySQL 5.1/5.5
i agree with harald if you're using Java you should consider pooling your database connections with DBCP http://commons.apache.org/dbcp/ feel free to ping me for implementation details takk, Martin __ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Wed, 13 Apr 2011 23:59:43 +0200 > From: h.rei...@thelounge.net > To: mysql@lists.mysql.com > Subject: Re: Practical connection limits MySQL 5.1/5.5 > > > Am 13.04.2011 23:50, schrieb Jeff Lee: > > Hey All, > > > > Can anyone provide some guidance as to what the practical connection limits > > to MySQL 5.1/5.5 are under linux? > > > > We're running a ruby on rails application that establishes 50 to 100 > > connections to our database upon startup resulting in around 1,000 > > persistent db connections. > > depends on how much RAM the box has > remind that every connection needs some MB for buffers > > > I've been told to expect anywhere from 5 - 10x > > our current transaction volume and I'm trying to predict where we're going > > to top out. > > i can not image why 1000 connections are needed in a real world application > throw away the aüülication if it does not support connection-pooling in 2011 > > > The servers are pretty beefy so I don't have a problem > > reserving memory for connections if that's what it takes but was more > > concerned about other problems that might be caused by having so many > > connections > > even if you have enough memory why will you throw it away for a > unusual connection count instead use the RAm for innodb-buffer-pool, > query-cache, key-buffers? > > >
RE: from excel to the mySQL
Vaz please do not insert bogus display names into the email display name (such as Vaz when your real name is haidarpesebe) most responsible mail-admins wont tolerate this type of spoofing or any type of email spoofing and if your name is VAZ use the email address created for VAZ instead of haidarpesebe Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > Date: Tue, 3 Aug 2010 19:40:58 +0100 > Subject: Re: from excel to the mySQL > From: pagong...@gmail.com > To: haidarpes...@gmail.com > CC: mysql@lists.mysql.com > > Hi, > > Ive always used navicat for mysql and it does wonders for import/export > (wether it be from excel or any other file type) and also general database > management. Actually, too many features to list here, check the website: > > http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html > > > > > Pag > > > On Tue, Aug 3, 2010 at 10:23 AM, HaidarPesebe wrote: > > > Dear All, > > I'm needs a way to upload data from excel to the mySQL database. Dear all, > > I need help is how to upload data from excel columns and load into mysql > > database using php? > > Thanks > > HaidarPesebe
RE: query results group/summed by interval
no that would give you the count for each second interval instead of using the interval variable 5 Aveeks floor: FLOOR(X) Returns the largest integer value not greater than X. 1st (seconds/5) interval example 5/5=1 floor(5/5) = 1 supplied value would truncate and give you the int not greater than X then multiply by 5 1*5=5 is correct Aveeks sum function: SUM([DISTINCT] expr) Returns the sum of expr. If the return set has no rows, SUM() returns NULL. The DISTINCT keyword can be used in MySQL 5.0 to sum only the distinct values of expr. SUM() returns NULL if there were no matching rows. sum(calls) from calls group by 5 * floor(seconds/5) sum(calls) from calls group by 5 * floor(5/5) sum(calls) from class group by 5 * 1 sum(calls) from class group by 5 is correct 2nd(seconds/5) interval example 10/5=2 floor(10/5)=2 supplied value would truncate and give you the int not greater than X then multiply by 5 2*5=10 is correct Aveeks sum function sum(calls) from calls group by 5 * floor(seconds/5) sum(calls) from calls group by 5 * floor(10/5) sum(calls) from class group by 5 * 2 sum(calls) from class group by 10 would be applicable only if the interval was 10 Aveek if your interval is 5 change: sum(calls) from calls group by 5 * floor(seconds/5) to sum(calls) from calls group by floor(seconds/5) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Sat, 31 Jul 2010 10:31:43 +0700 > From: cuong.m...@vienthongso.com > To: ave...@yahoo-inc.com > CC: mustafa...@gmail.com; mysql@lists.mysql.com > Subject: Re: query results group/summed by interval > > Hi Aveek, > > I think Ghulam just want to count calls for each intervals > so the query should looks like this: > > select count(*) as total_calls, queue_seconds > from calls group by queue_seconds order by total_calls; > > > - Original Message - > From: "Aveek Misra" > To: "Ghulam Mustafa" , mysql@lists.mysql.com > Sent: Tuesday, July 27, 2010 5:54:13 PM > Subject: RE: query results group/summed by interval > > try this ... > > select 5 * floor(seconds/5) as start, 5 * floor(seconds/5) + 5 as end, > sum(calls) from calls group by 5 * floor(seconds/5); > > This should give you an output of the type > > +---+--++ > | start | end | sum(calls) | > +---+--++ > | 0 | 5 | 387 | > | 5 | 10 | 225 | > | 10 | 15 | 74 | > +---+--++ > > > Thanks > Aveek > > From: Ghulam Mustafa [mustafa...@gmail.com] > Sent: Tuesday, July 27, 2010 3:53 PM > To: mysql@lists.mysql.com > Subject: query results group/summed by interval > > Hi everyone, > > i have two columns (seconds, number of calls), i need to produce a > report which will show total number of calls in intervals (let'say 10 > seconds interval), i know i can do this programmability in my script but > i was wondering if it's possible to accomplish this behavior within > mysql. for example i have following data. > > +--+---+ > | calls | queue_seconds | > +--+---+ > | 250 | 0.00 | > | 28 | 1.00 | > | 30 | 2.00 | > | 56 | 3.00 | > | 23 | 4.00 | > | 31 | 5.00 | > | 33 | 6.00 | > | 50 | 7.00 | > | 49 | 8.00 | > | 62 | 9.00 | > | 74 | 10.00 | > ... > ... and so on... > ... > +--+---+ > > now result should look like this with a 5 seconds interval. > > +--+---+ > | count(*) | queue_seconds | > +--+---+ > | 250 | 0.00 | > | 168 | 5.00 | > | 268 | 10.00 | > ... > ... and so on... > ... > +--+---+ > > i would really appreciate your help. > > Best Regards. >
RE: query results group/summed by interval
no that would give you the count for each second interval instead of using the interval variable 5 Aveeks floor: FLOOR(X) Returns the largest integer value not greater than X. 1st (seconds/5) interval example 5/5=1 floor(5/5) = 1 supplied value would truncate and give you the int not greater than X then multiply by 5 1*5=5 is correct Aveeks sum function: SUM([DISTINCT] expr) Returns the sum of expr. If the return set has no rows, SUM() returns NULL. The DISTINCT keyword can be used in MySQL 5.0 to sum only the distinct values of expr. SUM() returns NULL if there were no matching rows. sum(calls) from calls group by 5 * floor(seconds/5) sum(calls) from calls group by 5 * floor(5/5) sum(calls) from class group by 5 * 1 sum(calls) from class group by 5 is correct 2nd(seconds/5) interval example 10/5=2 floor(10/5)=2 supplied value would truncate and give you the int not greater than X then multiply by 5 2*5=10 is correct Aveeks sum function sum(calls) from calls group by 5 * floor(seconds/5) sum(calls) from calls group by 5 * floor(10/5) sum(calls) from class group by 5 * 2 sum(calls) from class group by 10 would be applicable only if the interval was 10 Aveek if your interval is 5 change: sum(calls) from calls group by 5 * floor(seconds/5) to sum(calls) from calls group by floor(seconds/5) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Sat, 31 Jul 2010 10:31:43 +0700 > From: cuong.m...@vienthongso.com > To: ave...@yahoo-inc.com > CC: mustafa...@gmail.com; mysql@lists.mysql.com > Subject: Re: query results group/summed by interval > > Hi Aveek, > > I think Ghulam just want to count calls for each intervals > so the query should looks like this: > > select count(*) as total_calls, queue_seconds > from calls group by queue_seconds order by total_calls; > > > - Original Message - > From: "Aveek Misra" > To: "Ghulam Mustafa" , mysql@lists.mysql.com > Sent: Tuesday, July 27, 2010 5:54:13 PM > Subject: RE: query results group/summed by interval > > try this ... > > select 5 * floor(seconds/5) as start, 5 * floor(seconds/5) + 5 as end, > sum(calls) from calls group by 5 * floor(seconds/5); > > This should give you an output of the type > > +---+--++ > | start | end | sum(calls) | > +---+--++ > | 0 | 5 | 387 | > | 5 | 10 | 225 | > | 10 | 15 | 74 | > +---+--++ > > > Thanks > Aveek > > From: Ghulam Mustafa [mustafa...@gmail.com] > Sent: Tuesday, July 27, 2010 3:53 PM > To: mysql@lists.mysql.com > Subject: query results group/summed by interval > > Hi everyone, > > i have two columns (seconds, number of calls), i need to produce a > report which will show total number of calls in intervals (let'say 10 > seconds interval), i know i can do this programmability in my script but > i was wondering if it's possible to accomplish this behavior within > mysql. for example i have following data. > > +--+---+ > | calls | queue_seconds | > +--+---+ > | 250 | 0.00 | > | 28 | 1.00 | > | 30 | 2.00 | > | 56 | 3.00 | > | 23 | 4.00 | > | 31 | 5.00 | > | 33 | 6.00 | > | 50 | 7.00 | > | 49 | 8.00 | > | 62 | 9.00 | > | 74 | 10.00 | > ... > ... and so on... > ... > +--+---+ > > now result should look like this with a 5 seconds interval. > > +--+---+ > | count(*) | queue_seconds | > +--+---+ > | 250 | 0.00 | > | 168 | 5.00 | > | 268 | 10.00 | > ... > ... and so on... > ... > +--+---+ > > i would really appreciate your help. > > Best Regards. >
RE: Why is MySQL always linked to PHP?
MySQL is written in C if your requirement is to write extension packages for MySQL then use the OS specific C compiler to write the functions deferring to MySQL staff to handle your other questions Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: j...@bytesmiths.com > To: mysql@lists.mysql.com > Subject: Re: Why is MySQL always linked to PHP? > Date: Thu, 22 Jul 2010 22:23:50 -0700 > > > On 22 Jul 10, at 21:01, Anirudh Sundar wrote: > > > SO ONE CANNOT COMPARE PHP WITH C. > > I can compare anything I want to -- I took a poetry class in college! > ("Her teeth were like the stars, 'cause they came out at night." :-) > > If you STOP SHOUTING, people might take you more seriously. > > > There are only two ways to look at life: One is as if nothing is a > miracle. The other is as if everything is a miracle. -- Albert Einstein > Jan Steinman, EcoReality Co-op > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
RE: How to become a DBA on MySQL
Keith/Jerry/Caludio/Alba Here are some possible locations where i used to instruct 1)http://www.aictrain.com ..they are primarily boston based not sure if they have any online courses yet 2)http://www.champlain.com Champlain has a a number of online courses..if you have any questions ask program coordinator gary his address is sav...@champlain.edu My understanding is that oracle may offer some DBA courses in the future Keep us apprised Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: je...@gii.co.jp > To: keithcl...@k-wbookworm.com > CC: claudio.na...@gmail.com; alba.albe...@libero.it; mysql@lists.mysql.com > Subject: RE: How to become a DBA on MySQL > Date: Tue, 13 Jul 2010 17:53:31 -0400 > > Sorry, I wish I did. > > I've used courses at lvsonline.com for all kinds of things (programming, > graphics, etc.), but I didn't see anything about MySQL DBA. All of the > courses > I took there were good. They all had lab work that you submitted to the > instructor. > > DBA might not lend itself to that. > > Regards, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington Ave. > Farmington, CT 06032 > > 860.674.8796 / FAX: 860.674.8341 > E-mail: je...@gii.co.jp > Web site: www.the-infoshop.com > > > >-Original Message- > >From: Keith Clark [mailto:keithcl...@k-wbookworm.com] > >Sent: Tuesday, July 13, 2010 3:58 PM > >To: Jerry Schwartz > >Cc: 'Claudio Nanni'; 'alba.albetti'; 'mysql' > >Subject: RE: How to become a DBA on MySQL > > > >Jerry, > > > >Do you know of any reputable online classes that you could point me to? > > > >Keith > > > >On Tue, 2010-07-13 at 14:25 -0400, Jerry Schwartz wrote: > >> You might want to see if there are any online classes that could get you > >> started. I usually start by reading a big, thick book -- but I've found > >> that > >> spending a week or two on an introductory-level online class gives me a big > >> head start. > >> > >> "Modern" documentation tends to be lacking (IMNSHO). All too many reference > >> books are written on the principle of "If you know exactly what you want to > >> do, here's roughly how to do it." You can wander around for a long time not > >> knowing what a feature is for. > >> > >> Regards, > >> > >> Jerry Schwartz > >> Global Information Incorporated > >> 195 Farmington Ave. > >> Farmington, CT 06032 > >> > >> 860.674.8796 / FAX: 860.674.8341 > >> E-mail: je...@gii.co.jp > >> Web site: www.the-infoshop.com > >> > >> > >> >-Original Message- > >> >From: Claudio Nanni [mailto:claudio.na...@gmail.com] > >> >Sent: Tuesday, July 13, 2010 1:56 PM > >> >To: alba.albetti > >> >Cc: mysql > >> >Subject: Re: How to become a DBA on MySQL > >> > > >> >Reference is everywhere, but you need a sort of starting point. > >> > > >> >In your case I would say get this > >> >book<http://www.amazon.com/MySQL-4th-Paul- > >> >DuBois/dp/0672329387/ref=sr_1_1?ie=UTF8&s=books&qid=1279043056&sr=1-1> > >> >and > >> >read: > >> > > >> > > >> > - Part III > >> > - Part IV-D (quick read) > >> > > >> > > >> >You will benefit from Part I as well as developer. > >> > > >> >In my opinion this book is clear and linear, good to learn MySQL. > >> > >
RE: Select w/ group by question
> Date: Wed, 14 Jul 2010 10:25:22 -0400 > Subject: Select w/ group by question > From: smulle...@gmail.com > To: mysql@lists.mysql.com > > I'm having trouble formulating a query to gather the following data. I can > do this via a script, but now it is more or less just bothering me if there > is an easy/efficient way to gather the following data from a single query. > > Example Tables > > > Products > Type Cost Vendor_id > -- > --- > apple 1 1 > apple 3 2 > apple 7 3 > pear 2 1 > pear 4 2 > pear 2 3 > > Vendors > Vendor_id Vendor_name > > 1 Walmart > 2 Target > 3 Kmart > > > I would like to obtain the least cost of each product type and its > associated vendor. > > So...I would like to see a result similiar to the following: > > Type Cost Vendor_id Vendor_name > apple 1 1 Walmart > pear 2 1 Walmart > (Note: both vendors 1 and 3 have the same cost which is the lowest. I'm not > really concerned with which vendor is chosen in the result set here.) > > > If I do: select a.type, min(a.cost), a.vendor_id, b.vendor_name from products a join vendors b on a.vendor_id = b.vendor_id group by a.type,a.vendor_id, b.vendor_name all rows are returned because the type/vendor_id/vendor_name are unique amongst each row. If you remove the vendor_id and vendor_name from the group by, select a.type, min(a.cost), a.vendor_id,b.vendor_name from products a join vendors b on a.vendor_id = b.vendor_id group by a.type; you get a single row with the lowest cost for each product, but the vendor_id's and vendor_name's are incorrect because you are not grouping by them. > > Is there a way to do this from a single query. I know I can concat things > together and imbed a select in my where clause to get the result I want, but > this is horribly inefficient. > My real tables have somewhere around 30 million rows in them. MG>put ascending indexes on vendor_id and vendor_name columns MG>reorg the tables so the rows will be in vendor_name (within vendor_id) order MG>reselect MG>select a.type, min(a.cost), a.vendor_id,b.vendor_name from MG>products a join vendors b MG>on a.vendor_id = b.vendor_id MG>order by a.type; > > Thanks > > Scott _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
RE: query help
i would monitor the performance on outer-join to determine if your server pegging cpu,disk i/o or memory when executing te outer-join then perhaps populating a temp table (and deleting the non-matching records..those records which will be considered in transaction) as joerg suggested i was hoping to use a trigger perhaps a trigger may work is it possible to initiate the trigger on login/connect or some other initiating event when entering the database.. thus far trigger events are DML only? http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html if not then you can create a test script which will create and populate the temp table thru cron http://www.databasejournal.com/features/mysql/article.php/3833146/Running-MySQL-in-Batch-Mode.htm would be interested to know which solution works best Vielen Danke, Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > From: rich...@rushlogistics.com > To: joerg.bru...@sun.com; mysql@lists.mysql.com > Subject: Re: query help > CC: jblanch...@pocket.com; rich...@rushlogistics.com > Date: Wed, 16 Jun 2010 08:23:21 -0400 > > Thank you very much for all the insightful replies. I think I can get it to > work with a join. > > > Joerg Bruehe wrote: > > > > Hi! > > > > > > Jay Blanchard wrote: > > > [snip] > > > I have a table similar to this: > > > > > > - > > > |transactions | > > > |ID |DATE |EMPLOYEE| > > > |234 |2010-01-05| 345 | > > > |328 |2010-04-05| 344 | > > > |239 |2010-01-10| 344 | > > > > > > Is there a way to query such a table to give the days of the year that > > > employee 344 did not have a transaction? > > > [/snip] > > > > > > SELECT DATE > > > FROM transactions > > > WHERE EMPLOYEE != '344' > > > GROUP BY DATE; > > > > I strongly doubt this will work - what if several employees have > > transactions on the same day? > > > > No, what the poster effectively needs is a set difference: > > Take the set of all candidate dates, and subtract the set of days on > > which the employee in question did have a transaction. > > > > The first difficulty will be to construct the set of candidate dates, as > > this needs a decision what to do about non-working dates (weekends, > > public holidays, ...) and how to determine them - depending on the > > business logic, that set may be specific to the employee (personal > > vacation!). > > > > Only when this has been decided, there is the question how to implement > > the set difference: > > - SQL "minus" is a candidate, but MySQL doesn't support that AFAIK. > > - Outer Join is the other possibility, as proposed by Gavin. > > - Having all candidate dates in some temporary table and then deleting > > those with a transaction is another way, but probably very slow. > > (The advantage of this might be that it is the most flexible way.) > > > > > > Jörg > > > > -- > > Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com > > Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin > > Geschaeftsfuehrer: Juergen Kunz > > Amtsgericht Muenchen: HRB161028 > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
RE: Best way to purge old records from a huge table?
Hi Brian- i think the best way to ensure your dates are using -MM-DD format is for your dml to reference dates with DATE_FORMAT('-MM-DD','%Y-%m-%d') e.g. mysql> select DEIT_EVENT_SEQUENCE_ID,DEIT_EVENT_STATUS_CODE,DEIT_EVENT_DATE from DEIT; +++-+ | DEIT_EVENT_SEQUENCE_ID | DEIT_EVENT_STATUS_CODE | DEIT_EVENT_DATE | +++-+ |1 | 1 | 2006-09-04 | |2 | 2 | 2006-09-05 | |3 | 3 | 2006-09-06 | +++-+ 3 rows in set (0.00 sec) mysql> delete from DEIT where DEIT_EVENT_DATE select DEIT_EVENT_SEQUENCE_ID,DEIT_EVENT_STATUS_CODE,DEIT_EVENT_DATE from DEIT; +++-+ | DEIT_EVENT_SEQUENCE_ID | DEIT_EVENT_STATUS_CODE | DEIT_EVENT_DATE | +++-+ | 2 | 2 | 2006-09-05 | | 3 | 3 | 2006-09-06 | +++-+ 2 rows in set (0.00 sec) hth Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: br...@briandunning.com > Subject: Best way to purge old records from a huge table? > Date: Fri, 4 Jun 2010 08:10:07 -0700 > To: mysql@lists.mysql.com > > Hey all - > > I have a table with 12,000,000 records spread over about 6 years. I'm trying > to delete all but the last 2 years, but no matter how small of a group I try > to delete at a time, it keeps hanging up the server and I eventually have to > restart MySQL. The table looks like this: > > `creation` timestamp NOT NULL default CURRENT_TIMESTAMP on update > CURRENT_TIMESTAMP, > `lat` double NOT NULL default '0', > `lon` double NOT NULL default '0', > `referer` int(12) NOT NULL default '0', > PRIMARY KEY (`referer`,`lat`,`lon`), > KEY `creation` (`creation`,`referer`) > > And the query I've been trying looks like this: > > delete from tablename where `creation` < '2006-04-01 00:00:00' > > ...trying to do the oldest 1 month of records at a time. So am I just trying > a really inefficient query? Is there a better way to do this? > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1
RE: Strange errors / messages on slave server
> In less technical terms, if the master goes faster than the slave, the slave > will puke. MG>then the master will have to teach the slave MG>is the master the entrenched bureacucrat or is that the slave? > > Regards, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington Ave. > Farmington, CT 06032 > > 860.674.8796 / FAX: 860.674.8341 > > www.the-infoshop.com > > > > > > > > >Machiel Richards > > > > > >-Original Message- > >From: Machiel Richards [mailto:machi...@rdc.co.za] > >Sent: 02 June 2010 9:41 AM > >To: mysql@lists.mysql.com > >Subject: Strange errors / messages on slave server > > > >Good day all > > > > > > > > I hope someone can assist me with this. > > > > > > > > While doing the normal routine daily health checks on one of > >our clients' servers I came across some strange behaviour from the slave > >server. (two servers setup in master / slave replication) > > > > > > > > While looking at the current Innodb buffer pool usage > >(master server), I noticed that the usage went up from 44% yesterday to > >98.7% today, however nothing on the master server suggested why. > > > > > > > > I went on to look at the save server and found very strange > >behaviour (for me anyway) and I am hoping someone can assist in explaining > >this to me and some possible corrective actions: > > > > > > > > When running show slave status, it seems that there was an > >error logged which show in the output as below: > > > > > > > >mysql> show slave status; > > > >+--+--+-+--- > >--+---+--+-+ > >--+---+---+--+-- > >-+-+-+-- > >--++-+-- > >---++--- > > > >+--- > >---+-+-+-+-- > >--+---+++--- > >-+-+---++--- > >+ > > > >| Slave_IO_State | Master_Host | Master_User | > >Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos | > >Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | > >Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB > >| Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | > >Replicate_Wild_Ignore_Table | Last_Errno | Last_Error > >| Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | > >Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | > >Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | > >Seconds_Behind_Master | > > > >+--+--+-+--- > >--+---+--+-+ > >--+---+---+--+-- > >-+-+-+-- > >--++-+-- > >---++--- > > > >+--- > >---+-+-+-+-- > >--+---+++--- > >-+-+---++--- > >+ > > > >| Waiting for master to send event | MASTER.SERVER | repladmin | > >3306 | 60 | mysql-bin.000327 | 672223064 | > >SLAVE-relay-bin.001016 | 598540830 | mysql-bin.000326 | Yes > >| No | | | > >| | | > >| 1206 | Error 'The total number of locks exceeds the lock table size' > >on query. Default database: 'profiler'. Query: 'update profile_options set > >`value` = REPLACE(`value`, '.', '') where list_item_id = 11' | 0 > >| 598540693 | 1746329551 | None | | > >0 | No | | | > >| | | NULL | > > > >+--+--+-+--- > >--+---+--+-+ > >--+---+---+--+-- > >-+-+-+-- > >--++-+-- > >---++--- > >--
RE: Security issues
Good Morning Rob- I agree with you that security is a very serious topic and should be addressed as such Please read security alert page listed at tech-resources http://dev.mysql.com/tech-resources/articles/security_alert.html I hope this addresses your question, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: wult...@gmail.com > Date: Mon, 24 May 2010 13:45:35 -0700 > Subject: Re: Security issues > To: mgai...@hotmail.com > CC: je...@gii.co.jp; mysql@lists.mysql.com > > On Mon, May 24, 2010 at 1:42 PM, Martin Gainty wrote: > > Good Afternoon Rob- > > > > if you're implementing either glassfish or weblogic webserver > > your "best fit solution" would be Oracle Identity Manager > > > > there are 'other' identity solutions such as RSA which are > > 1)far more complex .. > > 2)virtually hackproof.. > > at random intervals RSA implements an alternate encryption algorithm with an > > alternate keysize > > > > RSA issues smart cards which contain sufficient biometric information > > to authenticate you > > (and pass the authentication token to the OS) > > > > does this help? > > Martin Gainty > > I am explicitly not setting up identity solutions or anything else. > All I want is a page from mysql which lists security issues.and what > versions are effected. I don't think that this is such an insane > thought... > > > -- > Rob Wultsch > wult...@gmail.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
RE: Security issues
Good Afternoon Rob- if you're implementing either glassfish or weblogic webserver your "best fit solution" would be Oracle Identity Manager there are 'other' identity solutions such as RSA which are 1)far more complex .. 2)virtually hackproof.. at random intervals RSA implements an alternate encryption algorithm with an alternate keysize RSA issues smart cards which contain sufficient biometric information to authenticate you (and pass the authentication token to the OS) does this help? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: wult...@gmail.com > Date: Mon, 24 May 2010 13:27:52 -0700 > Subject: Re: Security issues > To: je...@gii.co.jp > CC: mgai...@hotmail.com; mysql@lists.mysql.com > > On Mon, May 24, 2010 at 12:07 PM, Jerry Schwartz wrote: > >>-Original Message- > >>From: Rob Wultsch [mailto:wult...@gmail.com] > >>Sent: Saturday, May 22, 2010 11:52 AM > >>To: Martin Gainty > >>Cc: mysql@lists.mysql.com > >>Subject: Re: Security issues > >> > >>On Sat, May 22, 2010 at 5:44 AM, Martin Gainty wrote: > >>> Good Morning Rob- > >>> > >>> one vulnerability (with UDFs) > >>> http://dev.mysql.com/tech-resources/articles/security_alert.html > >>> > >>> a manager considering a enterprise-wide security solution may want > >>> to consider Oracle Identity Manager (with Glassfish 3.2) > >>> http://under-linux.org/en/content/oracle-introduces-schedule-for-glassfish- > >>556/ > >>> > >>> Does this help? > >>> Martin Gainty > >> > >>Martin, > >> > >>Thank you for the reply. > >> > >>The guys across the street have a single page with cliff notes about > >>every vulnerability effecting every supported version*. The page I > >>noted was comprehensive. Martin, what you listed was a page with an > >>single vuln and a page which looks like a product. > >> > > [JS] This is always a tough call for a software developer. On the one hand, > > announcing an unfixed problem alerts users; but at the same time, it also > > alerts abusers. Some companies go one way, some go the other. > > > > Regards, > > > > Jerry Schwartz > > Global Information Incorporated > > 195 Farmington Ave. > > Farmington, CT 06032 > > > > 860.674.8796 / FAX: 860.674.8341 > > > I explicitly do not want a list of unfixed problems. I want a list of > fixed issues and what versions are effected. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
RE: Master - master replication
mg>zoom down to walters question(s) > Hi Carl, > > On Mon, May 24, 2010 at 13:42, Carl wrote: > > 1. Is the data visible during transmission? > > Not sure what you mean there? mg>he means if someone was sharking the line would they be able to see Financial Information / HealthInformation that are protected by federal law?(at least in the USYMMV) > > > 2. Is there a way to encrypt the data during transmission? > > MySQL supports SSL encryption of replication. Here's a good starting > point: http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-ssl.html mg>if you can convince the powers that be to update your webserver and all backend server to support SSL then ALL transmissions would need to be encrypted using the SSL encrpytion mg>..otherwise go with PGP.. > > cheers, > > Walter Heck > Engineer @ Open Query (http://openquery.com) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > > > > > > -- > John Daisley > > Certified MySQL 5 Database Administrator > Certified MySQL 5 Developer > Cognos BI Developer > > Telephone: +44 (0)7918 621621 > Email: john.dais...@butterflysystems.co.uk > > > > > -- > John Daisley > > Certified MySQL 5 Database Administrator > Certified MySQL 5 Developer > Cognos BI Developer > > Telephone: +44 (0)7918 621621 > Email: john.dais...@butterflysystems.co.uk _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
RE: Master - master replication
yes.. SSL can implement number of encryption algorithms but when a webserver configuration is configured with HTTP (instead ofHTTPS) http://www.pgp.com/ export mysql rows to PGP encrypter ..transmit via some secure mechanism sftp/scp (or ftp/cp without secure handshakes) the PGP decrypter at the other end will decrypt the received rows and construct import/update statements to MYSQL ? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: c...@etrak-plus.com > To: wal...@openquery.com > CC: mysql@lists.mysql.com > Subject: Re: Master - master replication > Date: Mon, 24 May 2010 07:24:35 -0500 > > Walter, > > Don't know how I missed that but it exactly what I needed. > > Thanks, > > Carl > - Original Message - > From: "Walter Heck" > To: "Carl" > Cc: > Sent: Monday, May 24, 2010 5:49 AM > Subject: Re: Master - master replication > > > Hi Carl, > > On Mon, May 24, 2010 at 13:42, Carl wrote: > > 1. Is the data visible during transmission? > Not sure what you mean there? > > > 2. Is there a way to encrypt the data during transmission? > MySQL supports SSL encryption of replication. Here's a good starting > point: http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-ssl.html > > cheers, > > Walter Heck > Engineer @ Open Query (http://openquery.com) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ The New Busy is not the old busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3
RE: Master - master replication
Hello Carl MySQL advertises an encryption package using the ENCRYPT('hello') but to date i have'nt find any information on where to download and configure the encrpytion package did you look at http://www.critotech.com ? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: c...@etrak-plus.com > To: mysql@lists.mysql.com > Subject: Master - master replication > Date: Mon, 24 May 2010 06:42:06 -0500 > > I am setting up master - master replication between two sites that are in > separate facilities that are hundreds of miles apart. > > The operating systems are Slackware 13, the MySql version is 5.1.41 (will > probably upgrade to latest.) > > I have two questions: > > 1. Is the data visible during transmission? > > 2. Is there a way to encrypt the data during transmission? > > Thanks, > > Carl > _ The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
RE: Security issues
Good Morning Rob- one vulnerability (with UDFs) http://dev.mysql.com/tech-resources/articles/security_alert.html a manager considering a enterprise-wide security solution may want to consider Oracle Identity Manager (with Glassfish 3.2) http://under-linux.org/en/content/oracle-introduces-schedule-for-glassfish-556/ Does this help? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: wult...@gmail.com > Date: Fri, 21 May 2010 22:50:06 -0700 > Subject: Security issues > To: mysql@lists.mysql.com > > Given the rather serious recent bug fixes I have been thinking a good > bit about security. Does MySQL AB/Sun/Oracle maintain a page similar > to http://www.postgresql.org/support/security.html which lists > security issues and what releases they effected? > > -- > Rob Wultsch > wult...@gmail.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
RE: Database Quotas
i guess my thinking is more along the lines of implementing a lustre interface http://en.wikipedia.org/wiki/Lustre_%28file_system%29#Architecture where the chronology *may* follow: the File's Metadata attributes are written the particulars of where the data is written would be handled by OSS which delegates to 1..n target nodes (which then passes the information to that target's LVM / RAID device) Both MDS and OSS can implement either ext3 or ZFS/DMU Storage algos..in either case the metadata(MDT) metadata object record is written by the MDS .. the data will be written to one or more LOV formatted ext3 or ZFS/DMU nodes specifying byte-offset and size.. When the requesting client issues a write request for the OST the governing OSS issues the write request to the target that can fulfill it..if the requested target cannot complete the request that target passes ENOSPC back to OSS which then looks up the next target The admin of the target node will be notified of the failed attempt by alert or log but the OSS will hunt for the next target that can fulfill the write request of the OST this is my (albeit cursory) interpretation of Object Oriented Disk Architectures does this conform to your understanding? Martin Gainty __ Please do not alter/modify or disrupt this transmission. Thank You > Date: Fri, 21 May 2010 07:21:22 -0700 > From: t...@soe.ucsc.edu > To: mgai...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Database Quotas > > > if MYSQL attempts to insert more bytes than what is available > > on disk you will get 28 ENOSPC No space left on device > > http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html > > Does it figured that out before it tries to write a record? So, if I have 2KB > left on the device and I write a 4KB record, does the first 2KB get written > and then the error occurs, or does the error occur before the write is > attempted? > > I guess what I'm asking is will the tables be marked as "crashed" when an > ENOSPC happens, or will the tables still be in good health? > > If they're still in good health, then I suppose that I could use ZFS file > systems to allocate space for databases...it just seems that this ought to be > a feature of the database. :) > > Tim Gustafson > Baskin School of Engineering > UC Santa Cruz > t...@soe.ucsc.edu > 831-459-5354 _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
RE: Database Quotas
Tim- if MYSQL attempts to insert more bytes than what is available on disk you will get 28 ENOSPC No space left on device http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html does this help? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Thu, 20 May 2010 18:09:42 -0700 > From: t...@soe.ucsc.edu > To: noel.but...@ausics.net > CC: mysql@lists.mysql.com > Subject: Re: Database Quotas > > > Ummm, you're going to have the same problem either way when > > the limit is reached, be it a MySQL quota or system quota, > > if its full, its full. > > Yes, but mySQL could return a more friendly "you're out of space" message and > not corrupt the data files if a given statement would cause the database to > exceed its quota (and it could do so in a way that doesn't corrupt the > database files) > > Or it could work the opposite way: check the current usage against the quota > before executing a statement, and if the database is already over quota, > don't even attempt it. > > Tim Gustafson > Baskin School of Engineering > UC Santa Cruz > t...@soe.ucsc.edu > 831-459-5354 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
RE: Getting Array to display on SELECT
RGB encoding? sorry..thats for graphic designers Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > To: mysql@lists.mysql.com > From: g...@paulgdesigns.com > Subject: Getting Array to display on SELECT > Date: Tue, 20 Apr 2010 18:16:52 -0400 > > I'm frankly not sure if this is a MySQL question or PHP, but I thought I > would start here. > > I have a form that I have a (ever growing) list of checkboxes, Here is a > sample of the code for it. > > > > It seems to go in, when I say seems to, I get a result of Array in the > table, the code is listed below. I have tried various solutions I found in > searching the issue, but have only been able to so far get Array. > > echo 'Id NumberDate > EnteredCaptionWhere > TakenKeywordsDescriptionImage'; > while ($row = mysqli_fetch_array($data)) { > > echo '' . $row['image_id']. ''; >echo '' . $row['submitted']. ''; > echo '' . $row['caption']. ''; > echo '' . $row['where_taken'] . ''; > echo '' . $row['keyword']. ''; >echo '' . $row['description'] . ''; > if (is_file($row['image_file'])) { > echo ' height="100px"/>'; > } > > As a bonus question, does anyone have any idea why the image would show up > in IE9, and not FF? > > Thanks for your help. > > Gary > > > __ Information from ESET NOD32 Antivirus, version of virus signature > database 5045 (20100420) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
RE: DATE_FORMAT parameter question
Hi Carsten thanks for providing mysql support at 846pm kobenhavn time (on a fridag no less) I will DEFINITELY check this out Takk! Martin Gainty __ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Ãtant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Fri, 9 Apr 2010 19:02:33 +0200 > From: cars...@bitbybit.dk > To: mgai...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: DATE_FORMAT parameter question > > If you'll excuse the shameless plug: I once created a tool to help find > the exact parameters to use for PHPs date() and MySQLs DATE_FORMAT(). > Please see > > http://bitbybit.dk/php/date_format/ > > (Yes, it looks horrible. But it works) > > / Carsten > > Martin Gainty skrev: > > Good Afternoon All > > > > > > following the documentation available at > > > > http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html > > > > i wish to select a date using DD-MON-YY format but my format of '%y-%b-%d' > > appears to be incorrect > > > > > > > > mysql> select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL; > > ++ > > | DATE_FORMAT('11-10-09','%y-%b-%d') | > > ++ > > | 11-Oct-09 | > > ++ > > 1 row in set (0.00 sec) > > > > > > > > mysql> show variables like "%VERSION%"; > > +-+--+ > > | Variable_name | Value | > > +-+--+ > > | protocol_version | 10 | > > | version | 5.1.25-rc-community-log | > > | version_comment | MySQL Community Server (GPL) | > > | version_compile_machine | ia32 | > > | version_compile_os | Win32 | > > +-+--+ > > 5 rows in set (0.00 sec) > > > > > > it seems when i follow the documentation which states %d is used for day > > and %y is year i see: > > mysql> select DATE_FORMAT('11-10-09','%d-%b-%y') from DUAL; > > ++ > > | DATE_FORMAT('11-10-09','%d-%b-%y') | > > ++ > > | 09-Oct-11 | > > > > > > > > but if i switch %y and %d in date_format I get the correct result e.g. > > > > mysql> select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL; > > ++ > > | DATE_FORMAT('11-10-09','%y-%b-%d') | > > ++ > > | 11-Oct-09 | > > ++ > > 1 row in set (0.00 sec) > > > > > > any ideas on what I am doing wrong with format string to produce desired > > DD-MON-YY format? > > > > > > > > Many Thanks, > > Martin Gainty > > __ > > Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité > > > > Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene > > Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte > > Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht > > dient lediglich dem Austausch von Informationen und entfaltet keine > > rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von > > E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > > > > Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le > > destinataire prévu, nous te demandons avec bonté que pour satisfaire > > informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie > > de ceci est interdite. Ce message sert à l'information seulement et n'aura > > pas n'importe quel effet légalement obligatoire. Ãtant donné que les email > > peuvent facilement être sujets à la manipulation, nous ne pouvons accepter > > aucune res
RE: DATE_FORMAT parameter question
(Agradecimentos para o conselho) Eu espero que o homem responsável parará a chuva e permitirá a todos nós a oportunidade de dessecar e apreciar a luz do sol Obrigado! Martin Gainty __ Por favor não altere/interrompa ou altere esta transmissão > To: mysql@lists.mysql.com > From: j...@consultorweb.cnt.br > Subject: Re: DATE_FORMAT parameter question > Date: Fri, 9 Apr 2010 12:56:46 -0300 > > Basicay, your date_format works like: > > select DATE_FORMAT('YY-MM-DD','%y-%b-%d') from DUAL; > > "Martin Gainty" escreveu na mensagem > news:blu142-w2137936b18ae273dbd6cb1ae...@phx.gbl... > > Good Afternoon All > > > following the documentation available at > > http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html > > i wish to select a date using DD-MON-YY format but my format of '%y-%b-%d' > appears to be incorrect > > > > mysql> select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL; > ++ > | DATE_FORMAT('11-10-09','%y-%b-%d') | > ++ > | 11-Oct-09 | > ++ > 1 row in set (0.00 sec) > > > > mysql> show variables like "%VERSION%"; > +-+--+ > | Variable_name | Value| > +-+--+ > | protocol_version| 10 | > | version | 5.1.25-rc-community-log | > | version_comment | MySQL Community Server (GPL) | > | version_compile_machine | ia32 | > | version_compile_os | Win32| > +-+--+ > 5 rows in set (0.00 sec) > > > it seems when i follow the documentation which states %d is used for day and > %y is year i see: > mysql> select DATE_FORMAT('11-10-09','%d-%b-%y') from DUAL; > ++ > | DATE_FORMAT('11-10-09','%d-%b-%y') | > ++ > | 09-Oct-11 | > > > > but if i switch %y and %d in date_format I get the correct result e.g. > > mysql> select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL; > +--------+ > | DATE_FORMAT('11-10-09','%y-%b-%d') | > ++ > | 11-Oct-09 | > ++ > 1 row in set (0.00 sec) > > > any ideas on what I am doing wrong with format string to produce desired > DD-MON-YY format? > > > > Many Thanks, > Martin Gainty > __ > Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité > > Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene > Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte > Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht > dient lediglich dem Austausch von Informationen und entfaltet keine > rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von > E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > > Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le > destinataire prévu, nous te demandons avec bonté que pour satisfaire > informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie > de ceci est interdite. Ce message sert à l'information seulement et n'aura > pas n'importe quel effet légalement obligatoire. Ãtant donné que les email > peuvent facilement être sujets à la manipulation, nous ne pouvons accepter > aucune responsabilité pour le contenu fourni. > > > > _ > Hotmail is redefining busy with tools for the New Busy. Get more from your > inbox. > http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2 > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
DATE_FORMAT parameter question
Good Afternoon All following the documentation available at http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html i wish to select a date using DD-MON-YY format but my format of '%y-%b-%d' appears to be incorrect mysql> select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL; ++ | DATE_FORMAT('11-10-09','%y-%b-%d') | ++ | 11-Oct-09 | ++ 1 row in set (0.00 sec) mysql> show variables like "%VERSION%"; +-+--+ | Variable_name | Value| +-+--+ | protocol_version| 10 | | version | 5.1.25-rc-community-log | | version_comment | MySQL Community Server (GPL) | | version_compile_machine | ia32 | | version_compile_os | Win32| +-+--+ 5 rows in set (0.00 sec) it seems when i follow the documentation which states %d is used for day and %y is year i see: mysql> select DATE_FORMAT('11-10-09','%d-%b-%y') from DUAL; ++ | DATE_FORMAT('11-10-09','%d-%b-%y') | ++ | 09-Oct-11 | but if i switch %y and %d in date_format I get the correct result e.g. mysql> select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL; ++ | DATE_FORMAT('11-10-09','%y-%b-%d') | ++ | 11-Oct-09 | +----+ 1 row in set (0.00 sec) any ideas on what I am doing wrong with format string to produce desired DD-MON-YY format? Many Thanks, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Ãtant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
RE: Tokutek Acquires Oracle
short of exxon there is no other entity that comes close to acquiring Oracle Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: jschwa...@the-infoshop.com > To: prajapat...@gmail.com; mysql@lists.mysql.com > Subject: RE: Tokutek Acquires Oracle > Date: Thu, 1 Apr 2010 14:28:31 -0400 > > Happy April Fool's Day. > > Regards, > > Jerry Schwartz > The Infoshop by Global Information Incorporated > 195 Farmington Ave. > Farmington, CT 06032 > > 860.674.8796 / FAX: 860.674.8341 > > www.the-infoshop.com > > >-Original Message- > >From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] > >Sent: Thursday, April 01, 2010 10:39 AM > >To: MySQL > >Subject: Tokutek Acquires Oracle > > > >Hi guys, > > > >Is the information is true. > > > >http://planet.mysql.com/ > > > >http://tokutek.com/2010/04/tokutek-acquires-oracle/ > > > >Regards, > >Krishna > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_1
RE: how things get messed up
i agree with jerry put date/timestamps on each record..(that way you know when the record was created/modified) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: jschwa...@the-infoshop.com > To: vikkiatb...@yahoo.in; vegiv...@tuxera.be > CC: mysql@lists.mysql.com > Subject: RE: how things get messed up > Date: Tue, 16 Feb 2010 11:02:22 -0500 > > >-Original Message- > >From: Vikram A [mailto:vikkiatb...@yahoo.in] > >Sent: Friday, February 12, 2010 4:13 AM > >To: Johan De Meersman > >Cc: MY SQL Mailing list > >Subject: Re: how things get messed up > > > >Sir, > > > >Thanks for your suggestion, > >I will go for blob storage, because our application will maintain the data on > >yearly basis[stupersonal2008, stupersonal2009 etc.]. So i feel we may not > >face > >such kind of performance issue in our application. > > > [JS] It sounds like you are planning to have one table per year. Regardless > of > where you put your blobs, I think that is a bad idea from a design > standpoint. > It will make it harder to find historical information. > > If your database is relatively small, then I'd just keep everything in one > table. If it is big, then roll data that is five years old into an archive > table. That will give you only two places, and an easy-to-follow rule to tell > you where to look. > > Regards, > > Jerry Schwartz > The Infoshop by Global Information Incorporated > 195 Farmington Ave. > Farmington, CT 06032 > > 860.674.8796 / FAX: 860.674.8341 > > www.the-infoshop.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ Hotmail: Powerful Free email with security by Microsoft. http://clk.atdmt.com/GBL/go/201469230/direct/01/
RE: Happy Christmas
Guten Tag/Bonjour/Hello Pete Haben Sie ein gutes Weihnachten/Ayez bon Noël/Have a good Christmas Staaten von Amerika/Etats Unis/United States of America Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: pbsb...@googlemail.com > To: mysql@lists.mysql.com > Subject: Happy Christmas > Date: Fri, 25 Dec 2009 10:33:35 + > > Hope you are all having a Happy Christmas. > > Regards > > Peter > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141665/direct/01/
RE: missing ttydefaults.h
no i havent ..any clues as to location of kernel headers? (apologies for the newbie question) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Wed, 4 Nov 2009 09:02:39 -0500 > Subject: Re: missing ttydefaults.h > From: mdyk...@gmail.com > To: mgai...@hotmail.com > CC: mysql@lists.mysql.com > > Let me guess, > > you are doing a source build on a linux box? Have you installed the > kernel headers? > > - michael dykman > > 2009/11/4 Martin Gainty : > > > > In file included from readline.c:54: > > readline/readline.h:70:29: sys/ttydefaults.h: No such file or directory > > > > any clue where i can locate? > > Martin Gainty > > __ > > Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité > > > > Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene > > Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte > > Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht > > dient lediglich dem Austausch von Informationen und entfaltet keine > > rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von > > E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > > Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le > > destinataire prévu, nous te demandons avec bonté que pour satisfaire > > informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie > > de ceci est interdite. Ce message sert à l'information seulement et n'aura > > pas n'importe quel effet légalement obligatoire. Étant donné que les email > > peuvent facilement être sujets à la manipulation, nous ne pouvons accepter > > aucune responsabilité pour le contenu fourni. > > > > > > > > _ > > Bing brings you maps, menus, and reviews organized in one place. > > http://www.bing.com/search?q=restaurants&form=MFESRP&publ=WLHMTAG&crea=TEXT_MFESRP_Local_MapsMenu_Resturants_1x1 > > > > -- > - michael dykman > - mdyk...@gmail.com > > "May you live every day of your life." > Jonathan Swift > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ Find the right PC with Windows 7 and Windows Live. http://www.microsoft.com/Windows/pc-scout/laptop-set-criteria.aspx?cbid=wl&filt=200,2400,10,19,1,3,1,7,50,650,2,12,0,1000&cat=1,2,3,4,5,6&brands=5,6,7,8,9,10,11,12,13,14,15,16&addf=4,5,9&ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen2:112009