Deleted Columns_priv Table MySQL
Jun 24, 2009I accidentally deleted the columns_priv table in mysql database. How can I bring it back can anyone show me the structure of that table so I can build it back.
View 4 Replies
ADVERTISEMENT
Mysql: Copying To Tmp Table
May 18, 2009mysql: Copying to tmp table, what causes that?
My server is majorly overloading and mysql is atop the cpu, and when I do a processlist there are about 20 copying to tmp table processes.
MySQL Table Crashed
Sep 28, 2007Table '231_message' is marked as crashed and should be repaired
I haven't ever had this happen, is all my data truely lost or can i 'repair' it
i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame )
either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database
Optimizing Large MySQL Table
Nov 2, 2009I optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions..
1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf?
2.- Should I repair it using phpmyadmin or just from the shell?
3.- Should I stop http traffic during this optimization?
This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average:
Code:
Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram
/etc/my.cnf
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
skip-bdb
query_cache_limit=1M
query_cache_size=48M
query_cache_type=1
max_connections=1200
interactive_timeout=100
wait_timeout=300
connect_timeout=10
thread_cache_size=128
key_buffer=48M
join_buffer=8M
max_allowed_packet=16M
table_cache=2036
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
# Add
max_heap_table_size = 48M
tmp_table_size = 48M
low_priority_updates=1
concurrent_insert=2
[mysqldump]
quick
max_allowed_packet=16M
[mysql.server]
user=mysql
#basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/slow-queries.log
On the other side, i have the same hardware for the webserver..
Mysql: Incorrect Key File For Table
Apr 20, 2009I have a server with many db on mysql 5
Any db contains 5 table with data
This data is processed by routine
Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"
The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..
MYSQL Incorrect Key File For Table
Jul 3, 2008what I can do about the following database error in mysql?
Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it
I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.
How To Alter Tabel And Create Table In Mysql
Jun 24, 2009I have a script and there are some modifications that I want to make
In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this.
I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it.
Should I use phpmyadmin or whats the correct way?
Mysql Disable INSERT Access To Specific User/table
Apr 26, 2009How can I disable INSERT access to specific table.
The user should have full access the the DB except insert to specific table.
The tables_priv allow to set what enable and not what disable.
I'm using mysql v5
Mysql Deleted Several Tables Under High Server Load
Apr 27, 2007we have mysql 5 setup and this morning at around 10:07 tables started disappearing as they were being accessed by different clients.
Databases that had 40 tables now had 30, etc. Only the tables that were attempted to be accessed were gone. This is the first time something like this has happened.
The following output was given:
This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose the
problem, but since we have already crashed, something is definitely wrong and this may fail.
key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=208
max_connections=500
threads_connected=156
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1096188 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0xaf82930
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xb143932c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x816b1a0
0xaf1898
0x20
0x81ac49d
0x8182914
0x8189010
0x8189df1
0x818a738
0x818ae5c
0xaeb371
0x9c4ffe
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read [url]and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xaf36620 = SELECT * FROM `sessions` WHERE `PHPSESSID` = '5e6775cd3c6f187d8c575127ba73be19'
thd->thread_id=113407
The manual page at [url]contains
information that should help you find out what is causing the crash.
mysqld: my_new.cc:51: int __cxa_pure_virtual(): Assertion `"Pure virtual method called." == "Aborted"' failed.
Number of processes running now: 0
070427 10:07:49 mysqld restarted
070427 10:07:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070427 10:07:53 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 227822203.
InnoDB: Doing recovery: scanned up to log sequence number 0 227822203
070427 10:07:53 InnoDB: Started; log sequence number 0 227822203
070427 10:07:54 [Note] /usr/sbin/mysqld: ready for connections.
How To Run OPTIMIZE TABLE
Mar 25, 2009Today i need to run "OPTIMIZE TABLE" from MySQLTuner recommendation.
Now i don't know how to run it ? I try to put in SQL Query via phpmyadmin and:
SQL query:
OPTIMIZE TABLE
MySQL said:
#1064 - 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 '' at line 1
Full BGP Table
Apr 19, 2007Can i expect a 7204VXR NPE-300 router with 256Meg to hold a full BGP table?
Would it be possible to hold to full BGP tables (multihoming) with a NPE-400 with 512Meg?
Attachment Table
Oct 21, 2007I have a site running on vps and the attachment table got crashed , I am unable to repair it :
thesymbi_vb.attachment
error : Not enough memory for blob at 605100 (need 6315809)
warning : Number of rows changed from 4 to 3081
status : OK
This is result of repairing from WHM, how to repair it?
My.cnf Have Delete The Table
May 9, 2007i have update my.cnf with the following configuration and now i have a lor of customer that have lost him table, seem that this configuration have delete in random .Myi files, i would put this my.cnf also on others server but i would undestand which setting in this .cnf make problem for the table.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=96M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=384M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=3M ## 1MB for every 1GB of RAM
read_buffer_size=3M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci
[mysql.server]
user=mysql
#basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Can't Initialize Iptables Table
Mar 12, 2008On my new unmanaged VPS i keep getting mass emails sent to me saying -
iptables v1.2.11: can't initialize iptables table `filter': iptables who? (do you need to insmod?)
Perhaps iptables or your kernel needs to be upgraded.
Im a bit of a n00b when it comes to unmanaged servers, just wondering if anyone knows whats wrong and how to fix.
Table Marked As Crashed.
Apr 5, 2009I have a table that is showing
MySQL Error: 145 (Table './dollarpt_ptc/flinks' is marked as crashed and should be repaired)
I've repaired it via
mysqlcheck --repair --all-databases
that didn't work. I've tried
find /var/lib/mysql/* -name *MYI |xargs myisamchk -o -r
as well with no luck.
I then dropped the table and I still get the message. I know it's using the correct database, so any help would be appreciated.
It's like there is a table where this data is kept, but I've looked and can't find anything.
Import Just One Table From A Sql Backup
Nov 13, 2007I have a sql backup and I just want to restore the attachment table from it! , can anyone explain me how to do so?
View 4 Replies View RelatedMysqldump :: JUST The Data, NO Table Information
Apr 14, 2008From Linux Shell, I need to back up a mysql database, JUST the data, NO Table information. Which options in mysqldump do I use?
View 14 Replies View RelatedDisk Doesn't Contain A Valid Partition Table
Feb 2, 2008I am unable to mount the 2nd disk's extended partition. Please help.
Commands I tried and returns....
Quote:
mount -t ext2 /dev/hdd2 /second
mount: wrong fs type, bad option, bad superblock on /dev/hdd2,
missing codepage or other error
In some cases useful info is found in syslog - try
dmesg | tail or so
Quote:
mount -t ext3 /dev/hdd2 /second
mount: wrong fs type, bad option, bad superblock on /dev/hdd2,
missing codepage or other error
In some cases useful info is found in syslog - try
dmesg | tail or so
Also I tried to add it to /etc/fstab but it says the same error, Disk /dev/hdd2 doesn't contain a valid partition table... I am able to mount /dev/hdd1 successfully.
Internal Server Error - When Reading Table
Nov 28, 2008In the forum [url]suddenly we got Internal Server Error. Our host claims it is because of corrupted database accorind the logs:
081128 11:44:38 [ERROR] Got error 126 when reading table './lykman_clubcento/lykman11_members'
Repairing the database from cpanel didnt work. Old available backups are not available.
Ip_conntrack: Table Full, Dropping Packet
Mar 20, 2008ip_conntrack: table full, dropping packet
What does that error mean? It's related to iptables right? When I do this cat /proc/sys/net/ipv4/ip_conntrack_max, I get
65536
I increased it
131072
Because someone recommended me this number because I have 4gb of RAM. But I still get the table full errors or
host kernel: printk: 500 messages suppressed
What should I do? Should I keep increasing the number? How do I know how much I can increase it by?
Nf_conntrack: Table Full, Dropping Packet
Mar 30, 2007I have 2 identical boxes with FC6 and the same settings and almost the same amount of traffic.
Kernel is 2.6.20-1.2925.fc6 SMP
One is running without problem. The other become slow after few days and from errors I get this message:
nf_conntrack: table full, dropping packet
The table do not clean up automatically as reboot solve the problem. How to flush nt_conntrack table without reboot?
The limit is 65536, setting it double seems to solve the problem but I'm not sure it is the way to go.
Kernel: TCP: Time Wait Bucket Table Overflow With VePortal
Oct 5, 2009Any one facing any issue when Running CPanel on the VPS.
I always seem to be getting these errors only for Cpanel VPS only.
kernel: TCP: time wait bucket table overflow
kernel: TCP: too many of orphaned sockets (90 in CT****)
Even Cpanel Install by SSH or VePortal gives the same error.
Plesk 12.x / Linux :: Unable To Find Row By Field Login With Value In Smb Users Table
Aug 25, 2014On a couple of domains I get this error if I click on the domain in the domains option or in the Subscriptions list.
Unable to find row by field login with value domain.com in smb_users table.
How can I fix this?